One can try this:
set lin 700 col action_time format a30 col action format a20 col namespace format a20 col version format a10 col id format 999999999 col bundle_series format a15 col comments format a30 select * from dba_registry_history order by action_time;
This is the approach I’m usually taking to clone the Oracle Software from one server to another.
[oracle@PROD product]$ zip -r 11204_clone.zip 11.2.0.4/ adding: 11.2.0.4/ (stored 0%) adding: 11.2.0.4/owm/ (stored 0%) adding: 11.2.0.4/owm/jlib/ (stored 0%) adding: 11.2.0.4/owm/jlib/owm-images.jar (deflated 2%) .......... adding: 11.2.0.4/bin/okinit0 (stored 0%) adding: 11.2.0.4/bin/okinit0 (stored 0%) adding: 11.2.0.4/bin/nmozip warning: Permission denied zip warning: could not open for reading: 11.2.0.4/bin/nmo adding: 11.2.0.4/bin/agtctlO (stored 0%) adding: 11.2.0.4/bin/nmcbufp (deflated 65%) adding: 11.2.0.4/bin/impdpO (stored 0%) ........... adding: 11.2.0.4/odbc/mesg/oraodbcus.msb (deflated 68%) adding: 11.2.0.4/odbc/mesg/oraodbcja.msb (deflated 68%) zip warning: Not all files were readable files/entries read: 40416 (4.9G bytes) skipped: 3 (144K bytes) [oracle@PROD product]$ exit
Now send the zip file to the target server:
[oracle@PROD software]$ scp /u01/app/oracle/product/11204_clone.zip DEV:/tmp
Create the same oracle path for the ORACLE_HOME
mkdir -p /u01/app/oracle/product
Unzip the archive to previously created folder:
unzip 11204_clone.zip -d /u01/app/oracle/product/
Navigate to this clone folder within the unzipped oracle software:
cd /u01/app/oracle/product/11.2.0.4/clone/bin
[oracle@DEV bin]$ pwd
/u01/app/oracle/product/11.2.0.4/clone/bin
[oracle@DEV bin]$ perl clone.pl ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.4 ORACLE_HOME_NAME=OH_11204
./runInstaller -clone -waitForCompletion "ORACLE_BASE=/u01/app/oracle" "ORACLE_HOME=/u01/app/oracle/product/11.2.0.4" "ORACLE_HOME_NAME=OH_11204" -silent -noConfig -nowait
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 20479 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-10-11_03-40-32PM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production
Copyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/u01/app/oraInventory/logs/cloneActions2017-10-11_03-40-32PM.log
.................................................................................................... 100% Done.
Installation in progress (Wednesday, October 11, 2017 3:40:39 PM UTC)
.............................................................................. 78% Done.
Install successful
Linking in progress (Wednesday, October 11, 2017 3:40:42 PM UTC)
Link successful
Setup in progress (Wednesday, October 11, 2017 3:41:02 PM UTC)
Setup successful
End of install phases.(Wednesday, October 11, 2017 3:41:24 PM UTC)
WARNING:A new inventory has been created in this session. However, it has not yet been registered as the central inventory of this system.
To register the new inventory please run the script '/u01/app/oraInventory/orainstRoot.sh' with root privileges.
If you do not register the inventory, you may not be able to update or patch the products you installed.
The following configuration scripts need to be executed as the "root" user.
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0.4/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The cloning of OH_11204 was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2017-10-11_03-40-32PM.log' for more details.
[oracle@DEV bin]$ /u01/app/oracle/product/11.2.0.4/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2017-10-11_15-43-56PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2017-10-11_15-43-56PM.txt
Execute the 2 scripts as root and you’re done:
/u01/app/oraInventory/orainstRoot.sh /u01/app/oracle/product/11.2.0.4/root.sh
End of story.
Found a nice script to be used for rolling upgrades on Oracle Support. Please check it out here Oracle11g Data Guard: Database Rolling Upgrade Shell Script
On short, after upgrading one of my databases from 11203 to 11204, I’ve noticed that the standby database was in a DISABLED state:
DGMGRL> show configuration Configuration - DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI- Primary database DB_STANDBY - Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS
I tried to set it to ENABLED state like this:
DGMGRL> enable database 'DB_STANDBY' Error: ORA-16631: operation requires shutdown of database or instance "" Failed. DGMGRL> exit
To fix this, I’ve found the following document on Metalink:
DGMGRL> show configuration Configuration - DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI - Primary database DB_STANDBY - Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL> edit database 'DB_STANDBY' set state='ONLINE'; Error: ORA-16635: network connection failed during transmission Failed. DGMGRL> show configuration Configuration - DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI - Primary database DB_STANDBY - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL>
All of a sudden, deploying a new version of the apps, I got this error. The fix is simple. The error is related to the block size of the tablespace where you want to deploy your object. In my case it was about the creation of an index an the key was exceeding the size of the default block size of the default tablespace. All I had to do is to enable the 16K block size and to create a new tablespace using the 16k block size.
SQL> ALTER TABLE "USER"."TABLE1" ADD CONSTRAINT "CONSTR_UK" UNIQUE ("COL") USING INDEX TABLESPACE "TBS_DEFAULT";
ALTER TABLE "USER"."TABLE1" ADD CONSTRAINT "CONSTR_UK" UNIQUE ("COL") USING INDEX TABLESPACE "TBS_DEFAULT"
*
ERROR at line 1:
ORA-01450: maximum key length (3118) exceeded
SQL> show parameter db_16
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
SQL> alter system set db_16k_cache_size=500M;
System altered.
SQL> CREATE TABLESPACE "NEW_TBS" DATAFILE ...... SIZE 100M BLOCKSIZE 16K;
Tablespace created.
SQL> ALTER TABLE "USER"."TABLE1" ADD CONSTRAINT "CONSTR_UK" UNIQUE ("COL") USING INDEX TABLESPACE "NEW_TBS";
Table altered.
SQL>
I got this issue while using ADRCI tool to maintain the logs. This is how I fixed it:
[oracle@dbserver ~]$ adrci ADRCI: Release 11.2.0.3.0 - Production on Wed May 31 09:43:29 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = "/u01/app/oracle" adrci> show homes ADR Homes: diag/diagtool/user_oracle/host_3933716914_11 diag/clients/user_oracle/host_3933716914_11 diag/rdbms/dbinst/DBINST diag/tnslsnr/dbserver/listener adrci> set home diag/diagtool/user_oracle/host_3933716914_11 adrci> purge DIA-48322: Relation [INCIDENT] of ADR V[2] incompatible with V[2] tool DIA-48210: Relation Not Found DIA-48166: error with opening ADR block file because file does not exist [/u01/app/oracle/diag/diagtool/user_oracle/host_3933716914_11/metadata/INCIDENT.ams] [0] adrci> migrate schema Schema migrated. adrci> purge adrci> quit
To find that, I did the following:
[oracle@dbserver marius]$ ps aux | sort -nrk 3,3 | head -n 10 oracle 28986 75.8 1.6 10739264 1602896 ? Rs Jan24 137897:06 ora_q002_DBINST oracle 23660 63.1 1.2 10730424 1221500 ? Rs Feb12 97718:28 ora_q003_DBINST oracle 8360 15.7 6.0 10734592 5970484 ? Ss May28 377:34 oracleDBINST (LOCAL=NO) oracle 2264 15.5 5.8 10736632 5832076 ? Rs May28 352:31 oracleDBINST (LOCAL=NO) oracle 8356 15.1 5.5 10736640 5491732 ? Rs May28 364:28 oracleDBINST (LOCAL=NO) oracle 5592 15.0 0.1 10731024 152936 ? Ss 13:22 0:00 ora_j000_DBINST oracle 8358 14.9 5.6 10736632 5635028 ? Rs May28 358:14 oracleDBINST (LOCAL=NO) oracle 8350 14.8 6.1 10736644 6055308 ? Rs May28 355:42 oracleDBINST (LOCAL=NO) oracle 2266 13.5 5.8 10736632 5779248 ? Rs May28 306:35 oracleDBINST (LOCAL=NO) oracle 8342 13.3 5.9 10736636 5858864 ? Rs May28 319:50 oracleDBINST (LOCAL=NO)
And then on the sqlplus:
SYS @ DBINST > select s.sid, s.serial#, s.username,
to_char(s.logon_time,'DD-MON HH24:MI:SS') logon_time,
p.pid oraclepid, p.spid "ServerPID", s.process "ClientPID",
s.program clientprogram, s.module, s.machine, s.osuser,
s.status, s.last_call_et
from gv$session s, gv$process p
where p.spid=nvl('&unix_process',' ')
and s.paddr=p.addr
order by s.sid 2 3 4 5 6 7 8 9
10 ;
Enter value for unix_process: 28986
SID SERIAL# USERNAME LOGON_TIME ORACLEPID ServerPID ClientPID
------------ ------------ ------------------------------ ------------------------ ------------ ------------------------ ------------------------
CLIENTPROGRAM MODULE MACHINE
------------------------------------------------ ---------------------------------------------------------------- ----------------------------------------------------------------
OSUSER STATUS LAST_CALL_ET
------------------------------ -------- ------------
3027 1 24-JAN 08:54:00 40 28986 28986
oracle@dbserver (Q002) Streams dbserver
oracle ACTIVE 10902893
Elapsed: 00:00:00.01
SYS @ DBINST >
So it seems that the STREAMS are very busy 🙂
