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…

Oracle – what is filling up my diag directory and sub-directories

Oracle – what is filling up my diag directory and sub-directories sqlplus / as sysdba SQL> show parameter diag NAME                     TYPE     VALUE ———————————— ———– —————————— diagnostic_dest              string     /oracle/SILVER [oracle@silver ~]$ cd /oracle/SILVER/diag [oracle@silver diag]$ ls asm  clients  crs  diagtool  lsnrctl  netcman  ofm  rdbms  tnslsnr Ok, so…