Execute the recreation commands of Oracle EBS inventory as follows.
Database Tier
[oracle@ebis bin]$ /testfs/TEST/db/12.1.0/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/db/12.1.0" ORACLE_HOME_NAME="OraDb12c_home1"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'AttachHome' was successful.
Application Tier fs1
[oracle@ebis bin]$ /testfs/TEST/fs1/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs1/EBSapps/10.1.2" ORACLE_HOME_NAME="TEST_TOOLS__testfs_TEST_fs1_EBSapps_10_1_2"
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-15_04-16-51PM. Please wait ...
'AttachHome' was successful.
[oracle@ebis bin]$ /testfs/TEST/fs1/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs1/FMW_Home/oracle_common" ORACLE_HOME_NAME="OH_fs1_oracle_common"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-15_04-22-46PM. Please wait ...[oracle@ebis bin]$ The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /testfs/TEST/oraInventory
'AttachHome' was successful.
[oracle@ebis bin]$ /testfs/TEST/fs1/FMW_Home/webtier/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs1/FMW_Home/webtier" ORACLE_HOME_NAME="OH_fs1_webtier"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-15_04-33-54PM. Please wait ...[oracle@ebis bin]$
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /testfs/TEST/oraInventory
'AttachHome' was successful.
[oracle@ebis bin]$ /testfs/TEST/fs1/FMW_Home/Oracle_EBS-app1/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs1/FMW_Home/Oracle_EBS-app1" ORACLE_HOME_NAME="OH_fs1_Oracle_EBS_app1"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /testfs/TEST/oraInventory
'AttachHome' was successful.
Application Tier fs2
[oracle@ebis bin]$ /testfs/TEST/fs2/FMW_Home/oracle_common/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs2/FMW_Home/oracle_common" ORACLE_HOME_NAME="OH_fs2_oracle_common"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-15_04-48-03PM. Please wait ... The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /testfs/TEST/oraInventory
'AttachHome' was successful.
[oracle@ebis bin]$ /testfs/TEST/fs2/FMW_Home/webtier/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs2/FMW_Home/webtier" ORACLE_HOME_NAME="OH_fs2_webtier"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-15_04-55-46PM. Please wait ...[oracle@ebis bin]$ The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /testfs/TEST/oraInventory
'AttachHome' was successful.
[oracle@ebis bin]$ /testfs/TEST/fs2/EBSapps/10.1.2/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs2/EBSapps/10.1.2" ORACLE_HOME_NAME="TEST_TOOLS__testfs_TEST_fs2_EBSapps_10_1_2"
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-11-15_04-44-50PM. Please wait ...
'AttachHome' was successful.
[oracle@ebis bin]$ /testfs/TEST/fs2/FMW_Home/Oracle_EBS-app1/oui/bin/runInstaller -silent -attachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME="/testfs/TEST/fs2/FMW_Home/Oracle_EBS-app1" ORACLE_HOME_NAME="OH_fs2_Oracle_EBS_app1"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 98286 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /testfs/TEST/oraInventory
'AttachHome' was successful.
Reference
E-Business Suite Applications Manager Central Inventory & Local Inventory Details For System Administration Install, Clone, Upgrade and Maintenance (Doc ID 1550950.1)
Thursday, November 15, 2018
Oracle JCS - Weblogic server Issue Resolution
Error/Issue
Admin server is working but other servers are not working in JCS weblogic server.
Below error is given in the weblogic server admin output.
WARNING: Can not connect DB with URL jdbc:oracle:thin:@//xxx:1526/TEST.5679382404.oraclecloud.internal
java.sql.SQLException: ORA-28001: the password has expired
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:507)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:440)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:614)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
Root Cause
Database user passwords have been expired
Resolution
Connect to cdb using SQLPLUS <USERNAME>/<PASSWORD>
ALTER SESSION SET CONTAINER= <PDB1>;
SELECT username, account_status from CDB_USERS where ACCOUNT_STATUS like 'EXP%' and username like '%SP%';
SP549992516_STB
SP549992516_MDS
SP549992516_OPSS
SP549992516_IAU_APPEND
SP549992516_IAU_VIEWER
You will get output of all the users with account expired. Now follow one of the below solution.
1) One solution is to alter the OPSS database schema so the password is the same as specified when the Infrastructure domain was configured.
alter user <schema prefix>_OPSS identified by <original_pwd_here>;
By default the schema password is set to Weblogic Administrator password during the provisioning of the Oracle Java Cloud Service instance.
Altering the database user in this way will reactivate the account if it has expired. If the original password is used, no action is required to reconfigure JPS and the OPSS jdbc datasource (as shown below).
OR
2) You follow the note below to change the User password (only if you do not know the password):
<FMW 12c Infrastructure AdminServer / NodeManager Fail to Start : ORA-28001: password has expired or ORA-01017: invalid username/password; ( Note 1682942.1 )>
Reference
https://docs.oracle.com/en/cloud/paas/java-cloud/jscug/changing-database-schema-password.html#GUID-3290C685-E975-460E-94AE-419406092FE0
https://docs.oracle.com/en/cloud/paas/java-cloud/jscug/problems-failure-running-service-when-schema-user-password-expires.html
Admin server is working but other servers are not working in JCS weblogic server.
Below error is given in the weblogic server admin output.
WARNING: Can not connect DB with URL jdbc:oracle:thin:@//xxx:1526/TEST.5679382404.oraclecloud.internal
java.sql.SQLException: ORA-28001: the password has expired
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:507)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:440)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:614)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
Root Cause
Database user passwords have been expired
Resolution
Connect to cdb using SQLPLUS <USERNAME>/<PASSWORD>
ALTER SESSION SET CONTAINER= <PDB1>;
SELECT username, account_status from CDB_USERS where ACCOUNT_STATUS like 'EXP%' and username like '%SP%';
SP549992516_STB
SP549992516_MDS
SP549992516_OPSS
SP549992516_IAU_APPEND
SP549992516_IAU_VIEWER
You will get output of all the users with account expired. Now follow one of the below solution.
1) One solution is to alter the OPSS database schema so the password is the same as specified when the Infrastructure domain was configured.
alter user <schema prefix>_OPSS identified by <original_pwd_here>;
By default the schema password is set to Weblogic Administrator password during the provisioning of the Oracle Java Cloud Service instance.
Altering the database user in this way will reactivate the account if it has expired. If the original password is used, no action is required to reconfigure JPS and the OPSS jdbc datasource (as shown below).
OR
2) You follow the note below to change the User password (only if you do not know the password):
<FMW 12c Infrastructure AdminServer / NodeManager Fail to Start : ORA-28001: password has expired or ORA-01017: invalid username/password; ( Note 1682942.1 )>
Reference
https://docs.oracle.com/en/cloud/paas/java-cloud/jscug/changing-database-schema-password.html#GUID-3290C685-E975-460E-94AE-419406092FE0
https://docs.oracle.com/en/cloud/paas/java-cloud/jscug/problems-failure-running-service-when-schema-user-password-expires.html
Oracle DBCS Backup Error Resolution
Error
Below error is given when login to the DBCS.
login as: opc
Authenticating with public key "key"
Passphrase for key "key":
*** OBKUP::ERROR INFO ***
OBKUP::ERROR Cannot complete the Archivelogs Backup to Cloud Storage
OBKUP::ERROR KBHS-00715 HTTP CONNECTION ERROR
OBKUP::ERROR An http error was detected please verify your connectivity
*** OBKUP::ERROR END ***
Root Cause
Cloud account password of user xyz@yyyy.com has been changed.
Resolution
As root user, create a file to hold backup configuration:
# vi /tmp/bkp.conf
The contents of file should be:
bkup_cfg_files=yes
bkup_disk=yes
bkup_disk_recovery_window=7
bkup_oss=yes
bkup_oss_recovery_window=30
bkup_oss_url=https://xxx.storage.oraclecloud.com/v1/Storage-xxx/DBaaS
bkup_oss_user=xyz@yyyy.com
bkup_oss_passwd=actualPassword
(Replace actualPassword with correct password of user xyz@yyyy.com)
Change permission on this file as:
# chmod 0600 /tmp/bkp.conf
Now, execute the backup assistant as below
# /var/opt/oracle/ocde/assistants/bkup/bkup -cfg /tmp/bkp.conf
Below error is given when login to the DBCS.
login as: opc
Authenticating with public key "key"
Passphrase for key "key":
*** OBKUP::ERROR INFO ***
OBKUP::ERROR Cannot complete the Archivelogs Backup to Cloud Storage
OBKUP::ERROR KBHS-00715 HTTP CONNECTION ERROR
OBKUP::ERROR An http error was detected please verify your connectivity
*** OBKUP::ERROR END ***
Root Cause
Cloud account password of user xyz@yyyy.com has been changed.
Resolution
As root user, create a file to hold backup configuration:
# vi /tmp/bkp.conf
The contents of file should be:
bkup_cfg_files=yes
bkup_disk=yes
bkup_disk_recovery_window=7
bkup_oss=yes
bkup_oss_recovery_window=30
bkup_oss_url=https://xxx.storage.oraclecloud.com/v1/Storage-xxx/DBaaS
bkup_oss_user=xyz@yyyy.com
bkup_oss_passwd=actualPassword
(Replace actualPassword with correct password of user xyz@yyyy.com)
Change permission on this file as:
# chmod 0600 /tmp/bkp.conf
Now, execute the backup assistant as below
# /var/opt/oracle/ocde/assistants/bkup/bkup -cfg /tmp/bkp.conf
Tuesday, August 21, 2018
Updating EBS Cloud Admin Tool to Latest Version on Oracle Cloud Infrastructure Classic
[root@ff1daa opc]# cat /etc/ebscm.conf
version=18.2.1
previous_version=18.1.1
tf_version=0.10.8
ocirubysdk_version=1.2.4
ocicli_version=2.4.7
ocitfprovider_version=2.0.7
chefclient_version=12.16.42
chefdk_version=1.0.3
chefserver_version=12.17.5
remoteclone_version=1.7
otd_version=12.2.1.2.0
knife-oc_version=2.0.14
knife-ebs_version=1.0.0
knife-bmc_version=1.0.0
ebsinfra_version=1.0.0
provider=ocic
mode=upgrade
status=completed
[root@ff1daa opc]# su - oracle
[oracle@ff1daa ~]$ cd /u01/install/APPS/apps-unlimited-ebs
[oracle@ff1daa apps-unlimited-ebs]$
[oracle@ff1daa apps-unlimited-ebs]$ ls
bin ebs_misc lib README.md
build EBS-New-Prov-backups.txt LICENSE RemoteClone
change_log ebsoc local resources
DBTargets.txt ebs-unlimited.properties out self-update
EBS-METADATA java ProvisionEBS.pl summary
[oracle@ff1daa apps-unlimited-ebs]$ mkdir ~/ebs-orch-backup
[oracle@ff1daa apps-unlimited-ebs]$
[oracle@ff1daa apps-unlimited-ebs]$ cd EBS-METADATA/
[oracle@ff1daa EBS-METADATA]$
[oracle@ff1daa EBS-METADATA]$
[oracle@ff1daa EBS-METADATA]$ ls
ebsocmetadata.json OCIClassicOSImage.json psu_bp_label.json
[oracle@ff1daa EBS-METADATA]$ cp OCIClassicOSImage.json ~/ebs-orch-backup
[oracle@ff1daa EBS-METADATA]$ cd /u01/install/APPS/apps-unlimited-ebs/bin
[oracle@ff1daa bin]$ ls
createEBSChefServer.pl job_scheduler.sh selfUpdate.pl
DRSwitchOver.pl ProvisionEBSBackup.pl UpdateOplan.pl
ebsocMain.pl ProvisionEBSOnBMCSBackup.pl updatePrivateIP.sh
[oracle@ff1daa bin]$ perl selfUpdate.pl
Attempting to upgrade EBS Admin Tool to Version: 18.2.1.1 ..
Downloading the latest archive (EBSCloudAdminTools_v18.2.1.1.tgz)..
Extracting latest archive file..
Executing setup.sh
========================================================
Setting up Oracle EBS Cloud Admin Tool VM
Verify /tmp/EBSCloudAdminTools_v18.2.1.1/setup.out for complete details.
========================================================
Creating directory /u01/setupbkp.20180821024457
Moving /u01/install/APPS/apps-unlimited-ebs/bin to /u01/setupbkp.20180821024457
Moving /u01/install/APPS/apps-unlimited-ebs/lib to /u01/setupbkp.20180821024457
Moving /u01/install/APPS/apps-unlimited-ebs/resources to /u01/setupbkp.20180821024457
Current Chef Server version "12.17.5" is same as available version "12.17.5". No action performed.
Extracting apps-unlimited-ebs.zip to /u01/install/APPS
Copying chef-12.16.42-1.el6.x86_64.rpm
Un-installing gem knife-ebs
Un-installing gem knife-oc
Installing gem knife-oc
Installing gem knife-ebs
Extracting RemoteClone.zip to /u01/install/APPS/apps-unlimited-ebs
========================================================================
Oracle EBS Cloud Admin Tool VM is setup successfully
Version: 18.2.1.1
Mode: upgrade
Verify /tmp/EBSCloudAdminTools_v18.2.1.1/setup.out for complete details.
========================================================================
EBS Admin Tool Upgraded Successfully, Please restart the interview..
[oracle@ff1daa bin]$
[root@ff1daa opc]# cat /etc/ebscm.conf
version=18.2.1.1
previous_version=18.2.1
tf_version=0.10.8
ocirubysdk_version=1.2.4
ocicli_version=2.4.7
ocitfprovider_version=2.0.7
chefclient_version=12.16.42
chefdk_version=1.0.3
chefserver_version=12.17.5
remoteclone_version=1.7
otd_version=12.2.1.2.0
knife-oc_version=2.0.14
knife-ebs_version=1.0.0
knife-bmc_version=1.0.0
ebsinfra_version=1.0.0
provider=ocic
mode=upgrade
status=completed
Reference
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/deploying_ebs_cloud_admin_tool/09admintool.html#section8
version=18.2.1
previous_version=18.1.1
tf_version=0.10.8
ocirubysdk_version=1.2.4
ocicli_version=2.4.7
ocitfprovider_version=2.0.7
chefclient_version=12.16.42
chefdk_version=1.0.3
chefserver_version=12.17.5
remoteclone_version=1.7
otd_version=12.2.1.2.0
knife-oc_version=2.0.14
knife-ebs_version=1.0.0
knife-bmc_version=1.0.0
ebsinfra_version=1.0.0
provider=ocic
mode=upgrade
status=completed
[root@ff1daa opc]# su - oracle
[oracle@ff1daa ~]$ cd /u01/install/APPS/apps-unlimited-ebs
[oracle@ff1daa apps-unlimited-ebs]$
[oracle@ff1daa apps-unlimited-ebs]$ ls
bin ebs_misc lib README.md
build EBS-New-Prov-backups.txt LICENSE RemoteClone
change_log ebsoc local resources
DBTargets.txt ebs-unlimited.properties out self-update
EBS-METADATA java ProvisionEBS.pl summary
[oracle@ff1daa apps-unlimited-ebs]$ mkdir ~/ebs-orch-backup
[oracle@ff1daa apps-unlimited-ebs]$
[oracle@ff1daa apps-unlimited-ebs]$ cd EBS-METADATA/
[oracle@ff1daa EBS-METADATA]$
[oracle@ff1daa EBS-METADATA]$
[oracle@ff1daa EBS-METADATA]$ ls
ebsocmetadata.json OCIClassicOSImage.json psu_bp_label.json
[oracle@ff1daa EBS-METADATA]$ cp OCIClassicOSImage.json ~/ebs-orch-backup
[oracle@ff1daa EBS-METADATA]$ cd /u01/install/APPS/apps-unlimited-ebs/bin
[oracle@ff1daa bin]$ ls
createEBSChefServer.pl job_scheduler.sh selfUpdate.pl
DRSwitchOver.pl ProvisionEBSBackup.pl UpdateOplan.pl
ebsocMain.pl ProvisionEBSOnBMCSBackup.pl updatePrivateIP.sh
[oracle@ff1daa bin]$ perl selfUpdate.pl
Attempting to upgrade EBS Admin Tool to Version: 18.2.1.1 ..
Downloading the latest archive (EBSCloudAdminTools_v18.2.1.1.tgz)..
Extracting latest archive file..
Executing setup.sh
========================================================
Setting up Oracle EBS Cloud Admin Tool VM
Verify /tmp/EBSCloudAdminTools_v18.2.1.1/setup.out for complete details.
========================================================
Creating directory /u01/setupbkp.20180821024457
Moving /u01/install/APPS/apps-unlimited-ebs/bin to /u01/setupbkp.20180821024457
Moving /u01/install/APPS/apps-unlimited-ebs/lib to /u01/setupbkp.20180821024457
Moving /u01/install/APPS/apps-unlimited-ebs/resources to /u01/setupbkp.20180821024457
Current Chef Server version "12.17.5" is same as available version "12.17.5". No action performed.
Extracting apps-unlimited-ebs.zip to /u01/install/APPS
Copying chef-12.16.42-1.el6.x86_64.rpm
Un-installing gem knife-ebs
Un-installing gem knife-oc
Installing gem knife-oc
Installing gem knife-ebs
Extracting RemoteClone.zip to /u01/install/APPS/apps-unlimited-ebs
========================================================================
Oracle EBS Cloud Admin Tool VM is setup successfully
Version: 18.2.1.1
Mode: upgrade
Verify /tmp/EBSCloudAdminTools_v18.2.1.1/setup.out for complete details.
========================================================================
EBS Admin Tool Upgraded Successfully, Please restart the interview..
[oracle@ff1daa bin]$
[root@ff1daa opc]# cat /etc/ebscm.conf
version=18.2.1.1
previous_version=18.2.1
tf_version=0.10.8
ocirubysdk_version=1.2.4
ocicli_version=2.4.7
ocitfprovider_version=2.0.7
chefclient_version=12.16.42
chefdk_version=1.0.3
chefserver_version=12.17.5
remoteclone_version=1.7
otd_version=12.2.1.2.0
knife-oc_version=2.0.14
knife-ebs_version=1.0.0
knife-bmc_version=1.0.0
ebsinfra_version=1.0.0
provider=ocic
mode=upgrade
status=completed
Reference
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/deploying_ebs_cloud_admin_tool/09admintool.html#section8
Tuesday, May 22, 2018
Oracle APEX, ORDS Deployment on Apache Tomcat
Steps of Oracle APEX, ORDS Deployment on Apache Tomcat
1. Install Oracle Database
2. Create a tablespace.
CREATE TABLESPACE APEX_DATA DATAFILE '/u01/APEX/db/data/apex_001.dbf' SIZE 500M AUTOEXTEND ON NEXT 1M;
3. Download Oracle appex and unzip ( Also ORACLE_HOME/apex directory can be used )
sqlplus / as sysda
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX_DATA APEX_DATA TEMP /i/
SQL> @apxchpwd.sql
SQL> @apex_rest_config.sql
SQL> @apex_epg_config.sql /u01/APEX/db/11.2.0
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Check the port setting for XML DB Protocol Server.
SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
0
1 row selected.
SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.
SQL> EXEC DBMS_XDB.sethttpport(8080);
PL/SQL procedure successfully completed.
4. Check the APEX URL is working fine. http://<server-name>:<port>/apex
5. Download and unzip Apache Tomcat
# su - tomcat
export JAVA_HOME=/home/tomcat/jdk1.8.0_77
export CATALINA_HOME=/home/tomcat/apache-tomcat-7.0.68
export CATALINA_BASE=$CATALINA_HOME
Start and stop Tomcat using the following scripts.
$ $CATALINA_HOME/bin/startup.sh
$ $CATALINA_HOME/bin/shutdown.sh
6. Configure ORDS using following steps.
ALTER USER APEX_LISTENER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
-- The next one will fail if you've never installed ORDS before. Ignore errors.
ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
# su - tomcat
$ mkdir /home/tomcat/ords
$ cd /home/tomcat/ords
$ unzip /tmp/ords.3.0.11.180.12.34.zip /home/tomcat/ords
mkdir -p /home/tomcat/ords/conf
Edit the "/u01/ords/params/ords_params.properties
-------------------------------------------------------------------------------
db.hostname=oracle.test.com
db.port=1521
db.servicename=ords
#db.sid=
db.username=APEX_PUBLIC_USER
db.password=manager#123
migrate.apex.rest=false
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=APEX_DATA
schema.tablespace.temp=TEMP
standalone.mode=false
#standalone.use.https=true
#standalone.http.port=8080
#standalone.static.images=/home/oracle/apex/images
user.apex.listener.password=manager#123
user.apex.restpublic.password=manager#123
user.public.password=manager#123
user.tablespace.default=APEX_DATA
user.tablespace.temp=TEMP
sys.user=SYS
sys.password=manager#123
-------------------------------------------------------------------------------
$ $JAVA_HOME/bin/java -jar ords.war configdir /home/tomcat/ords/conf
$JAVA_HOME/bin/java -jar ords.war configdir /u01/ords/ conf
Jun 15, 2018 5:21:32 PM
INFO: Set config.dir to /u01/ords/conf in: /u01/ords/ords.war
$ $JAVA_HOME/bin/java -jar ords.war
$ $JAVA_HOME/bin/java -jar ords.war
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must en ter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Jun 15, 2018 5:23:24 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Installing Oracle REST Data Services version 3.0.12.263.15.32
... Log file written to /u01/ords/logs/ords_install_core_2018-06-15_172324_00763.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /u01/ords/logs/ords_install_datamodel_2018-06-15_172341_00566.log
Completed installation for Oracle REST Data Services version 3.0.12.263.15.32. Elapsed time: 00:00:18.614
7. Deploy on Tomcat using following steps.
Copy the APEX images to the Tomcat "webapps" directory.
$ mkdir $CATALINA_HOME/webapps/i/
$ cp -R /home/oraapex/apex/images/* $CATALINA_HOME/webapps/i/
Copy the "ords.war" file to the Tomcat "webapps" directory.
$ cd /u01/ords
$ cp ords.war $CATALINA_HOME/webapps/
8. ORDS should now be accessible using the following type of URL.
http://<server-name>:<port>/ords/
1. Install Oracle Database
2. Create a tablespace.
CREATE TABLESPACE APEX_DATA DATAFILE '/u01/APEX/db/data/apex_001.dbf' SIZE 500M AUTOEXTEND ON NEXT 1M;
3. Download Oracle appex and unzip ( Also ORACLE_HOME/apex directory can be used )
sqlplus / as sysda
SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX_DATA APEX_DATA TEMP /i/
SQL> @apxchpwd.sql
SQL> @apex_rest_config.sql
SQL> @apex_epg_config.sql /u01/APEX/db/11.2.0
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Check the port setting for XML DB Protocol Server.
SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
0
1 row selected.
SQL>
If it is set to "0", you will need to set it to a non-zero value to enable it.
SQL> EXEC DBMS_XDB.sethttpport(8080);
PL/SQL procedure successfully completed.
4. Check the APEX URL is working fine. http://<server-name>:<port>/apex
5. Download and unzip Apache Tomcat
# su - tomcat
export JAVA_HOME=/home/tomcat/jdk1.8.0_77
export CATALINA_HOME=/home/tomcat/apache-tomcat-7.0.68
export CATALINA_BASE=$CATALINA_HOME
Start and stop Tomcat using the following scripts.
$ $CATALINA_HOME/bin/startup.sh
$ $CATALINA_HOME/bin/shutdown.sh
6. Configure ORDS using following steps.
ALTER USER APEX_LISTENER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
-- The next one will fail if you've never installed ORDS before. Ignore errors.
ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
# su - tomcat
$ mkdir /home/tomcat/ords
$ cd /home/tomcat/ords
$ unzip /tmp/ords.3.0.11.180.12.34.zip /home/tomcat/ords
mkdir -p /home/tomcat/ords/conf
Edit the "/u01/ords/params/ords_params.properties
-------------------------------------------------------------------------------
db.hostname=oracle.test.com
db.port=1521
db.servicename=ords
#db.sid=
db.username=APEX_PUBLIC_USER
db.password=manager#123
migrate.apex.rest=false
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=APEX_DATA
schema.tablespace.temp=TEMP
standalone.mode=false
#standalone.use.https=true
#standalone.http.port=8080
#standalone.static.images=/home/oracle/apex/images
user.apex.listener.password=manager#123
user.apex.restpublic.password=manager#123
user.public.password=manager#123
user.tablespace.default=APEX_DATA
user.tablespace.temp=TEMP
sys.user=SYS
sys.password=manager#123
-------------------------------------------------------------------------------
$ $JAVA_HOME/bin/java -jar ords.war configdir /home/tomcat/ords/conf
$JAVA_HOME/bin/java -jar ords.war configdir /u01/ords/ conf
Jun 15, 2018 5:21:32 PM
INFO: Set config.dir to /u01/ords/conf in: /u01/ords/ords.war
$ $JAVA_HOME/bin/java -jar ords.war
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must en ter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Jun 15, 2018 5:23:24 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Installing Oracle REST Data Services version 3.0.12.263.15.32
... Log file written to /u01/ords/logs/ords_install_core_2018-06-15_172324_00763.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /u01/ords/logs/ords_install_datamodel_2018-06-15_172341_00566.log
Completed installation for Oracle REST Data Services version 3.0.12.263.15.32. Elapsed time: 00:00:18.614
7. Deploy on Tomcat using following steps.
Copy the APEX images to the Tomcat "webapps" directory.
$ mkdir $CATALINA_HOME/webapps/i/
$ cp -R /home/oraapex/apex/images/* $CATALINA_HOME/webapps/i/
Copy the "ords.war" file to the Tomcat "webapps" directory.
$ cd /u01/ords
$ cp ords.war $CATALINA_HOME/webapps/
8. ORDS should now be accessible using the following type of URL.
http://<server-name>:<port>/ords/
Thursday, April 19, 2018
ERP Cloud On-Site Printing Documents
How To Configure Printers In Fusion Applications (Doc ID 1447191.1)
Setup Instructions for Printing from Oracle Cloud (Doc ID 1964157.1)
How to Set Up Printer Configuration For Cloud/SaaS and Customer On-Site For Fusion Applications (Doc ID 1554333.1)
Oracle Fusion BI: How to Add the BI Administrator Role to a user in Release 12. (Doc ID 2238277.1)
Troubleshooting Guide For Cloud Printer (Doc ID 2140116.1)
How To Install End Point URL SSL Certificates In Default Fusion Truststore (Doc ID 2120300.1)
Setup Instructions for Printing from Oracle Cloud (Doc ID 1964157.1)
How to Set Up Printer Configuration For Cloud/SaaS and Customer On-Site For Fusion Applications (Doc ID 1554333.1)
Oracle Fusion BI: How to Add the BI Administrator Role to a user in Release 12. (Doc ID 2238277.1)
Troubleshooting Guide For Cloud Printer (Doc ID 2140116.1)
How To Install End Point URL SSL Certificates In Default Fusion Truststore (Doc ID 2120300.1)
Saturday, April 7, 2018
Configure Oracle Database Backup Cloud Service
Download opc_installer.zip from OTN and unzip.
[oracle@db-cld-inst-001 opc]$ unzip opc_installer.zip
[oracle@db-cld-inst-001 opc]$ ls
opc_installer.zip opc_install.jar opc_readme.txt
[oracle@db-cld-inst-001 opc]$ mkdir lib
[oracle@db-cld-inst-001 opc]$ mkdir wallet
[oracle@db-cld-inst-001 opc]$ ls
lib opc_installer.zip opc_install.jar opc_readme.txt wallet
[oracle@db-cld-inst-001 opc]$ java -jar opc_install.jar -serviceName Storage -identityDomain gse00112591 -opcId 'your account id' -opcPass 'unFair@5FOrd' -walletDir /u01/app/oracle/opc/wallet -libDir /u01/app/oracle/opc/lib
Oracle Database Cloud Backup Module Install Tool, build 12.2.0.1.0DBBKPCSBP_2017-11-28
Oracle Database Cloud Backup Module credentials are valid.
Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/opc/wallet.
Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora created.
Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip.
Download complete.
[oracle@db-cld-inst-001 lib]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Fri Apr 6 17:31:44 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: KTSDB02 (DBID=2214310033)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name KTSDB02 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_KTSDB02.f'; # default
RMAN> configure default device type to sbt;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored
RMAN> configure device type sbt parallelism 4;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
RMAN> configure channel device type sbt parms='SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
new RMAN configuration parameters are successfully stored
RMAN> configure compression algorithm 'MEDIUM';
new RMAN configuration parameters:
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
new RMAN configuration parameters are successfully stored
RMAN> set encryption on identified by "Manager#123" only;
executing command: SET encryption
RMAN> show all;
RMAN configuration parameters for database with db_unique_name KTSDB02 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_KTSDB02.f'; # default
RMAN> backup database plus archivelog;
Starting backup at 07-APR-18
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=40 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=252 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=31 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=49 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Database Backup Service Library VER=12.2.0.1
skipping archived logs of thread 1 from sequence 1 to 50; already backed up
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=51 RECID=51 STAMP=972812031
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4hsvnrp0_1_1 tag=TAG20180407T093424 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
Finished backup at 07-APR-18
Starting backup at 07-APR-18
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
skipping datafile 5; already backed up 1 time(s)
skipping datafile 6; already backed up 1 time(s)
skipping datafile 8; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/app/oracle/oradata/KTSDB02/system01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00013 name=/u02/app/oracle/oradata/KTSDB02/PDB1/sysaux01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_3: starting full datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=/u02/app/oracle/oradata/KTSDB02/sysaux01.dbf
channel ORA_SBT_TAPE_3: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: starting full datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00012 name=/u02/app/oracle/oradata/KTSDB02/PDB1/system01.dbf
input datafile file number=00015 name=/u02/app/oracle/oradata/KTSDB02/PDB1/PDB1_users01.dbf
input datafile file number=00019 name=/u02/app/oracle/oradata/SP390751824_svctbl.dbf
channel ORA_SBT_TAPE_4: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: finished piece 1 at 07-APR-18
piece handle=4lsvnrq5_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_4: starting full datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00014 name=/u02/app/oracle/oradata/KTSDB02/PDB1/undotbs01.dbf
input datafile file number=00018 name=/u02/app/oracle/oradata/SP390751824_wlsservices.dbf
input datafile file number=00020 name=/u02/app/oracle/oradata/SP390751824_ias_opss.dbf
channel ORA_SBT_TAPE_4: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_2: finished piece 1 at 07-APR-18
piece handle=4jsvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:12
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00004 name=/u02/app/oracle/oradata/KTSDB02/undotbs01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_3: finished piece 1 at 07-APR-18
piece handle=4ksvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:11
channel ORA_SBT_TAPE_3: starting full datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00016 name=/u02/app/oracle/oradata/SP390751824_mds.dbf
input datafile file number=00021 name=/u02/app/oracle/oradata/SP390751824_UMS.dbf
input datafile file number=00017 name=/u02/app/oracle/oradata/SP390751824_iau.dbf
channel ORA_SBT_TAPE_3: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4isvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u02/app/oracle/oradata/KTSDB02/users01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: finished piece 1 at 07-APR-18
piece handle=4msvnrrt_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4psvnrsf_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_2: finished piece 1 at 07-APR-18
piece handle=4nsvnrsc_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:28
channel ORA_SBT_TAPE_3: finished piece 1 at 07-APR-18
piece handle=4osvnrsc_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:28
Finished backup at 07-APR-18
Starting backup at 07-APR-18
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=52 RECID=52 STAMP=972812201
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4qsvnrt9_1_1 tag=TAG20180407T093641 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
Finished backup at 07-APR-18
Starting Control File and SPFILE Autobackup at 07-APR-18
piece handle=c-2214310033-20180407-18 comment=API Version 2.0,MMS Version 12.2.0.1
Finished Control File and SPFILE Autobackup at 07-APR-18
[oracle@db-cld-inst-001 opc]$ unzip opc_installer.zip
[oracle@db-cld-inst-001 opc]$ ls
opc_installer.zip opc_install.jar opc_readme.txt
[oracle@db-cld-inst-001 opc]$ mkdir lib
[oracle@db-cld-inst-001 opc]$ mkdir wallet
[oracle@db-cld-inst-001 opc]$ ls
lib opc_installer.zip opc_install.jar opc_readme.txt wallet
[oracle@db-cld-inst-001 opc]$ java -jar opc_install.jar -serviceName Storage -identityDomain gse00112591 -opcId 'your account id' -opcPass 'unFair@5FOrd' -walletDir /u01/app/oracle/opc/wallet -libDir /u01/app/oracle/opc/lib
Oracle Database Cloud Backup Module Install Tool, build 12.2.0.1.0DBBKPCSBP_2017-11-28
Oracle Database Cloud Backup Module credentials are valid.
Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/opc/wallet.
Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora created.
Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip.
Download complete.
[oracle@db-cld-inst-001 lib]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Fri Apr 6 17:31:44 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: KTSDB02 (DBID=2214310033)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name KTSDB02 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_KTSDB02.f'; # default
RMAN> configure default device type to sbt;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored
RMAN> configure device type sbt parallelism 4;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
RMAN> configure channel device type sbt parms='SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G PARMS 'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
new RMAN configuration parameters are successfully stored
RMAN> configure compression algorithm 'MEDIUM';
new RMAN configuration parameters:
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
new RMAN configuration parameters are successfully stored
RMAN> set encryption on identified by "Manager#123" only;
executing command: SET encryption
RMAN> show all;
RMAN configuration parameters for database with db_unique_name KTSDB02 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_KTSDB02.f'; # default
RMAN> backup database plus archivelog;
Starting backup at 07-APR-18
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=40 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=252 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=31 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=49 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Database Backup Service Library VER=12.2.0.1
skipping archived logs of thread 1 from sequence 1 to 50; already backed up
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=51 RECID=51 STAMP=972812031
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4hsvnrp0_1_1 tag=TAG20180407T093424 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
Finished backup at 07-APR-18
Starting backup at 07-APR-18
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
skipping datafile 5; already backed up 1 time(s)
skipping datafile 6; already backed up 1 time(s)
skipping datafile 8; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/app/oracle/oradata/KTSDB02/system01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00013 name=/u02/app/oracle/oradata/KTSDB02/PDB1/sysaux01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_3: starting full datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=/u02/app/oracle/oradata/KTSDB02/sysaux01.dbf
channel ORA_SBT_TAPE_3: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: starting full datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00012 name=/u02/app/oracle/oradata/KTSDB02/PDB1/system01.dbf
input datafile file number=00015 name=/u02/app/oracle/oradata/KTSDB02/PDB1/PDB1_users01.dbf
input datafile file number=00019 name=/u02/app/oracle/oradata/SP390751824_svctbl.dbf
channel ORA_SBT_TAPE_4: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: finished piece 1 at 07-APR-18
piece handle=4lsvnrq5_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_4: starting full datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00014 name=/u02/app/oracle/oradata/KTSDB02/PDB1/undotbs01.dbf
input datafile file number=00018 name=/u02/app/oracle/oradata/SP390751824_wlsservices.dbf
input datafile file number=00020 name=/u02/app/oracle/oradata/SP390751824_ias_opss.dbf
channel ORA_SBT_TAPE_4: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_2: finished piece 1 at 07-APR-18
piece handle=4jsvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:12
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00004 name=/u02/app/oracle/oradata/KTSDB02/undotbs01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_3: finished piece 1 at 07-APR-18
piece handle=4ksvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:11
channel ORA_SBT_TAPE_3: starting full datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00016 name=/u02/app/oracle/oradata/SP390751824_mds.dbf
input datafile file number=00021 name=/u02/app/oracle/oradata/SP390751824_UMS.dbf
input datafile file number=00017 name=/u02/app/oracle/oradata/SP390751824_iau.dbf
channel ORA_SBT_TAPE_3: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4isvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u02/app/oracle/oradata/KTSDB02/users01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: finished piece 1 at 07-APR-18
piece handle=4msvnrrt_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4psvnrsf_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_2: finished piece 1 at 07-APR-18
piece handle=4nsvnrsc_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:28
channel ORA_SBT_TAPE_3: finished piece 1 at 07-APR-18
piece handle=4osvnrsc_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:28
Finished backup at 07-APR-18
Starting backup at 07-APR-18
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=52 RECID=52 STAMP=972812201
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4qsvnrt9_1_1 tag=TAG20180407T093641 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
Finished backup at 07-APR-18
Starting Control File and SPFILE Autobackup at 07-APR-18
piece handle=c-2214310033-20180407-18 comment=API Version 2.0,MMS Version 12.2.0.1
Finished Control File and SPFILE Autobackup at 07-APR-18
Thursday, March 22, 2018
Can't Connect to PDB User in Oracle Database 12c RAC Instance
Error :
SQL> alter session set container=DEV1;
Session altered.
SQL> conn DEV1_ADMIN@DEV1
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
Analysis
Database Node 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Database Node 2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 MOUNTED NO
Resolution
Restart the DEV1 PDB on both database nodes.
Database Node 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Database Node 2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Then DEV1_ADMIN user could be connected and issue resolved.
SQL> alter session set container=DEV1;
Session altered.
SQL> conn DEV1_ADMIN@DEV1
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
Analysis
Database Node 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Database Node 2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 MOUNTED NO
Resolution
Restart the DEV1 PDB on both database nodes.
Database Node 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Database Node 2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Then DEV1_ADMIN user could be connected and issue resolved.
Monday, February 26, 2018
Error in Oracle EBS 12.2.5 Application Tier Cloning in Oracle Compute Cloud Server
Application Tier Cloning Errors
Configuring: Run file system....
LogFile located at /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/RCloneApplyAppstier_02250759.log
ERROR: Failed to configure the target system,
please check the logfile in : /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone
-------------------------------------------------------------------------------
START: Creating new WLS domain.
Running /u01/TEST/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u01/TEST/fs2/EBSapps/comn/util/jdk64 -al /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u01/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST -tmw /u01/TEST/fs2/FMW_Home -mpl /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/wlsT2PApply -silent true -debug true -domainAdminPassword /u01/TEST/fs2/EBSapps/comn/clone/FMW/tempinfo.txt
Script Executed in 2102 milliseconds, returning status 255
ERROR: Script failed, exit code 255
--------------------------------------------------------------------------------
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20372 Server port validation failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20372 Possible causes were :Ports of following servers - AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821) - were not available.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20372 Provide valid free ports or if those servers are targeted to non admin host, then use temporary port range mechanism.
java.lang.Exception: Error in validating "SERVER_CONFIG" parameters in "moveplan".
at oracle.as.clone.cloner.component.j2ee.util.J2EEGenericValidationUtil.validateServerConfig(J2EEGenericValidationUtil.java:218)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.getServerConfig(GenericPasteConfigSteps.java:922)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.executeGenericPasteConfig(GenericPasteConfigSteps.java:385)
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:259)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct.
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:314)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
SEVERE : Feb 23, 2018 11:32:19 - SEVERE - CLONE-20937 "pasteConfig" operation of J2EE domain failed. Check clone log and error files for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20237 Restoring the sourceid "J2EECOMPONENT@EBS_domain_PROD" has failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20237 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20237 Check the clone log for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20218 Cloning is not successful.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20218 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20218 Provide the clone log and error file for investigation.
Relevance to the Issue
Script failed because the following ports weren't available:
AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821)
Cause
Clone was configured with a public ip address in /etc/hosts.
Solution
Generally, a public ip address is not bindable in cloud setup.
Only private ip addresses are bindable.
1. Ensure a valid backup exists of the /etc/hosts file.
2. Configure /etc/hosts with PRIVATE ip addresse and redo the application tier cloning.
Reference
12.2 E-Business Suite Cloud Administration Task Running 'perl adcfgclone.pl appsTier dualfs' on Oracle Cloud Reports Ports were not Available (Doc ID 2278401.1)
Configuring: Run file system....
LogFile located at /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/RCloneApplyAppstier_02250759.log
ERROR: Failed to configure the target system,
please check the logfile in : /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone
-------------------------------------------------------------------------------
START: Creating new WLS domain.
Running /u01/TEST/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u01/TEST/fs2/EBSapps/comn/util/jdk64 -al /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u01/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST -tmw /u01/TEST/fs2/FMW_Home -mpl /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/wlsT2PApply -silent true -debug true -domainAdminPassword /u01/TEST/fs2/EBSapps/comn/clone/FMW/tempinfo.txt
Script Executed in 2102 milliseconds, returning status 255
ERROR: Script failed, exit code 255
--------------------------------------------------------------------------------
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20372 Server port validation failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20372 Possible causes were :Ports of following servers - AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821) - were not available.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20372 Provide valid free ports or if those servers are targeted to non admin host, then use temporary port range mechanism.
java.lang.Exception: Error in validating "SERVER_CONFIG" parameters in "moveplan".
at oracle.as.clone.cloner.component.j2ee.util.J2EEGenericValidationUtil.validateServerConfig(J2EEGenericValidationUtil.java:218)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.getServerConfig(GenericPasteConfigSteps.java:922)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.executeGenericPasteConfig(GenericPasteConfigSteps.java:385)
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:259)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct.
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:314)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
SEVERE : Feb 23, 2018 11:32:19 - SEVERE - CLONE-20937 "pasteConfig" operation of J2EE domain failed. Check clone log and error files for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20237 Restoring the sourceid "J2EECOMPONENT@EBS_domain_PROD" has failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20237 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20237 Check the clone log for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20218 Cloning is not successful.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20218 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20218 Provide the clone log and error file for investigation.
Relevance to the Issue
Script failed because the following ports weren't available:
AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821)
Cause
Clone was configured with a public ip address in /etc/hosts.
Solution
Generally, a public ip address is not bindable in cloud setup.
Only private ip addresses are bindable.
1. Ensure a valid backup exists of the /etc/hosts file.
2. Configure /etc/hosts with PRIVATE ip addresse and redo the application tier cloning.
Reference
12.2 E-Business Suite Cloud Administration Task Running 'perl adcfgclone.pl appsTier dualfs' on Oracle Cloud Reports Ports were not Available (Doc ID 2278401.1)
Saturday, February 24, 2018
Important Docs of Oracle Compute Cloud Service
Creating an Oracle E-Business Suite Development Environment in Oracle Cloud Infrastructure Compute Classic
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/creating_ebs_dev/03devinstall.html
Creating an SSH-Enabled User on an Oracle Compute Cloud Service Instance
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute/creating_an_ssh_enabled_user/creating_an_ssh_enabled_user.html#section1
Managing Oracle E-Business Suite on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/creating_ebs_dev/03devinstall.html
Creating an SSH-Enabled User on an Oracle Compute Cloud Service Instance
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute/creating_an_ssh_enabled_user/creating_an_ssh_enabled_user.html#section1
Managing Oracle E-Business Suite on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/managing_ebs_on_cloud_using_cloud_admin_tool/14manage_env/14manage_env.html
Cloning Oracle E-Business Suite From On-Premises to Oracle Cloud Infrastructure Classic Using EBS Cloud Tools
http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/cloning_ebs_from_on-prem_to_oracle_cloud/10cloning/10cloning.html#section1
Friday, February 23, 2018
Oracle EBS 12.2 Cloning Document
Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)
Wednesday, February 21, 2018
Oracle Database 18c
Release Schedule of Current Database Releases (Doc ID 742060.1)
Release Update Introduction and FAQ (Doc ID 2285040.1)
Oracle 18c New Feature: “Read Only Oracle Home”.. !!
Release Update Introduction and FAQ (Doc ID 2285040.1)
Oracle 18c New Feature: “Read Only Oracle Home”.. !!
Thursday, January 25, 2018
Oracle Standby Database Issue - ORA-16191: Primary log shipping client not logged on standby
Error : ORA-16191: Primary log shipping client not logged on standby
Resolution:
Issue can be resolved after creating password files in both primary and standby databases.
orapwd file=orapwPROD password=oracle entries=10 ignorecase=Y
Then start the synchronization again with below.
SQL> alter database recover managed standby database disconnect from session;
Subscribe to:
Posts (Atom)