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. … Continue reading Create User for Oracle Integration cloud in Oracle Cloud Infrastructure aka OCI

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 … Continue reading Manual Backup of Autonomous Database in OCI

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 … Continue reading Oracle Integration Cloud aka OIC in Oracle Cloud Infrastructure

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 … Continue reading Provisioning a New Autonomous Transaction processing in OCI – Part 2

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.. … Continue reading Starting WLS Admin Server – Invalid credentials passed in Oracle E-Business Suit R12.2.X

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 … Continue reading Forgotten APPS password retrieved for Oracle E-Business Suite R12.2.X

19c Physical Standby Database Switch over to Primary Database

At Primary: - 1.. Check for name, db_unique_name and primary check for database_role 1.1 Similarly check for current archive log status or no of archived log sequence. select SEQUENCE#,archived FROM V$ARCHIVED_LOG; or select max(SEQUENCE#),archived FROM V$ARCHIVED_LOG group by archived; or alter session set  nls_date_format='DD-MON-YYYY HH24:MI:SS'; select sequence#, first_time, next_time, archived FROM v$archived_log ORDER BY sequence#; … Continue reading 19c Physical Standby Database Switch over to Primary Database

Upgrade to Oracle 19c GRID Infrastructure from 12c GRID Bingo !!!!

1.. login to GRID Primary node as GRID Owner 2.. Navigate to 19c_GRID_HOME and execute gridSetup.sh if you have already applied RUP patches. For me i have already applied RUP 19.14.X cd /u101/app/19.3.0/grid/grid_home [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_BASE [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_HOME [oragrid@node1 grid_home]$ [oragrid@node1 grid_home]$ unset ORACLE_SID [oragrid@node1 grid_home]$ ./gridSetup.sh 3.. … Continue reading Upgrade to Oracle 19c GRID Infrastructure from 12c GRID Bingo !!!!

When the software home is already registered in the central inventory

Cause :- Before executing gridsetup.sh , the Dry-Run Upgrade  was performed by executing the command: gridSetup.sh -dryRunForUpgrade And The gridSetup.sh -dryRunForUpgrade command updates the Oracle Inventory (oraInventory) with the new Oracle Grid Infrastructure home. Login as grid user :- [oragrid@node1 grid_home]$ /u101/app/19.3.0/grid/grid_home/oui/bin/runInstaller -silent -waitforcompletion -detachHome ORACLE_HOME='/u101/app/19.3.0/grid/grid_home' -local Starting Oracle Universal Installer... Checking swap space: must … Continue reading When the software home is already registered in the central inventory

19c Converting Physical Standby Database to the Snapshot Standby Database !!!!

A snapshot standby database is a fully update-able standby database that is created by converting a physical standby database into a snapshot standby database. A snapshot Standby is open in the read-write mode and hence it is possible to process transactions independently of the primary database. At the same time, it maintains protection by continuing … Continue reading 19c Converting Physical Standby Database to the Snapshot Standby Database !!!!