Configure connection between OIC and Autonomous Database in OCI

1.. Login to OCI cloud account, click on the Tab Developer Service and under the Tab Application Integration click on Tab Integration 2. Select required compartment appropriately and click on the Tab Create and then enter details as follows and at the end click on tab Create. 3. Once OIC instance is created, click on …

Advertisement

Sequences to Stop and Start RAC Services

1.. Shutdown LISTENER[oragrid@node1 ~]$ srvctl status listener -n node1.askmedawaa.comListener LISTENER is enabled on node(s): node1.askmedawaa.comListener LISTENER is running on node(s): node1.askmedawaa.com[oragrid@node1 ~]$ srvctl stop listener -n node1.askmedawaa.com[oragrid@node1 ~]$[oragrid@node1 ~]$ srvctl status listener -n node1.askmedawaa.comListener LISTENER is enabled on node(s): node1.askmedawaa.comListener LISTENER is not running on node(s): node1.askmedawaa.com1.1 Login in to another node which you have …

Generate an API Signing Key using Console in OCI for the User

An API key is an RSA key pair in PEM format used for signing API requests. 1.. Login to OCI console and navigate to user detail page 2..  Click on Tab AOI Keys Note :- Either you can download keys or else if you have already generated keys, you can use them also 3..  Click …

Install Oracle Database Software in non-interactive or silent mode or without GUI mode !

1.. Login to server with Oracle Database user and navigate to cd $ORACLE_HOME/install/response. 1.2 If required take a backup of response file or edit it manually. 2..  For Software only installation enter installation options as INSTALL_DB_SWONLY #------------------------------------------------------------------------------# Do not change the following system generated value.#------------------------------------------------------------------------------oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 #-------------------------------------------------------------------------------# Specify the installation option.# It can be one of the …

Create User for Oracle Integration cloud in Oracle Cloud Infrastructure aka OCI

1. Login into your OCI Cloud Console 1.1. Under Profile click on the Identity Domain available 2 Create group and user for OIC 2.1. Click on Tab Groups and then Create Group 2.2 Click on Tab User and then click on Tab Create User 2.3 Assign user to Group OIC_ADMIN Click on the Tab Groups. …

Manual Backup of Autonomous Database in OCI

1.. Login to your OCI cloud console and create object storage bucket for Autonomous Database backup Note: - Only standard storage tier is supported for backup 1.2 Create and Form Swift storage URL The format of the URL to specify a bucket: - Sample URL:- https://swiftobjectstorage.region.oraclecloud.com/v1/namespace-string/bucket_name For given above format once you get the information as …

Oracle Integration Cloud aka OIC in Oracle Cloud Infrastructure

Oracle Integration aka OIC: -Oracle Integration is a unified platform which helps to integrate applications, automate processes, and create applications.In summary: -• Use integrations to design, monitor, and manage connections between the different applications• Create process applications to automate and manage your business work flows aka (Process Cloud Service)• Build custom web and mobile applications …

Provisioning a New Autonomous Transaction processing in OCI – Part 2

1.. Login to your Oracle Cloud Account, navigate to Oracle Database Tab and then click on it. Now select choice of your database. 1.2.. Select choice of your compartment where you want to provision database of your choice and for e.g click on Create Autonomous Database. Make sure you have selected right compartment of your …

Starting WLS Admin Server – Invalid credentials passed in Oracle E-Business Suit R12.2.X

Enter the WebLogic Admin password:Enter the APPS Schema password:Starting WLS Admin Server…Invalid credentials passed.Note :- I was trying to start after long time and had forgotten password. 1.. Navigate to $EBS_DOMAIN_HOME/servers/AdminServer/security/ [applmgr@appsserver security]$ cd $EBS_DOMAIN_HOME/servers/AdminServer/security/[applmgr@appsserver security]$[applmgr@appsserver security]$ ls -lthrtotal 4.0K-rw-r--r--. 1 applmgr oinstall 118 Feb 4 2019 boot.propertiesand do cat[applmgr@appsserver security]$ cat boot.propertiesusername={AES}figS+bMcKpb9//BlXr0q6jPG7laIUQ0rhRu5bEWhAe8=password={AES}euyJGTV1O9v4pMevP8+WlVKT3S1QwHWZK2Qbnt9rhls=[applmgr@appsserver security]$ 2.. …

Forgotten APPS password retrieved for Oracle E-Business Suite R12.2.X

1.. Create Function to decrypt the encrypted password 1.1 Login to database as SYSDBA SQL> create FUNCTION apps.decrypt_appspwd_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';/ Function created.SQL> 2.. Use select statement to see decrypted password of apps user in database SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';ENCRYPTED_FOUNDATION_PASSWORDZHB17D1EC6227652CCB4155CEE29F7438D7625C572EC265394AA2943A0B0D7591F91D757FD351642CD331F2DB73C48925677 3.. Copy and …