On Linux Clone a 12c $ORACLE_HOME + patches, $ORACLE_BASE, and a database to a new server

Without running runInstaller, dbca, opatch, or rman, pick up an existing DB and the Oracle binaries and move them to another server, here is one way (without all the screen shots): Assumption are: You only have one home and database under your $ORACLE_BASE – this example only does one DB – but you could modify…

Can’t get your oracle database to shutdown clean with immediate – do this

start another sqlplus session if need be: shutdown abort; startup restrict; shutdown immediate; startup;

Oracle – how to connect as to a database as another user

CONN / AS SYSDBA CREATE USER user2 IDENTIFIED BY user2; ALTER USER user1 GRANT CONNECT THROUGH user2; We can now connect to the user1 user, using the credentials of the proxy user. SQL> CONN user2[user1]/user2 SQL> SHOW USER USER is “user1” SQL> Proxy users can be identified using the PROXY_USERS view. SELECT * FROM proxy_users;…

Oracle – How to find the max seqeunce # for a clone with open resetlogs using rman backup log file

If you have the rman log file produced with a rman full backup and you want to know what the max sequence number in backup / archivelogs is for a rman duplicate database or recover until.  This command assumes there are archivelog backups included in your rman log. Here is a little unix command to…