Dicas ORACLE DBA

begin ORASSO.WWSSO_OID_INTEGRATION.reset_passwd('orcladmin',null,'welcome01'); end; / OR $cd $ORACLE_HOME/bin $./oidpasswd connect=yourDBconn unlock_su_acct=true

patchset 10.1.2.3 there are still issues in the 10.1.0.5 DB client causing the crashes. Apply patch: 7047034 https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=7047034 Metalink note: 1306651.1

Check current open cursor in database: select max(a.value) as highest_open_cur, p.value as max_open_cur from gv$sesstat a, gv$statname b, gv$parameter p where a.statistic# = b.statistic# and b.name = 'opened cursors current' and p.name = 'open_cursors' group by p.value; Opened cursor by session: select a.value, s.username, s.sid, s.serial# from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid = a.sid and b.name = 'opened cursors current' and s.username is not null;

Edit the oraInst.loc file: vi /etc/oraInst.loc Change the inventory_loc to a new location: inventory_loc=/prod/oraInventory_new Create the new directory: mkdir /prod/oraInventory_new Give permissions to the new directory: chmod -R 777 /prod/oraInventory_new -- Add the 10.1.3 Oracle Home to the new created oraInventory: cd $INST_TOP/ora/10.1.3 . ./APP .env Go to the $ORACLE_HOME: cd $ORACLE_HOME Edit the oraInst.loc and point it to the same location ad done in step 1: inventory_loc=/prod/oraInventory_new Add the 10.1.3 Oracle Home to the new oraInventory location: cd $ORACLE_HOME/appsutil/clone ./ouicli.pl Verify if the 10.1.3 is added to the new oraInventory directory: cd /prod/oraInventory_new/ContentsXML cat inventory.xml If it's not added, check the /prod/oraInventory_new/logs file. Verify the oraInventory has the information about the 10.1.3 Oracle Home: export PATH=$ORACLE_HOME/OPatch:$PATH opatch lsinventory -detail -- Add the 10.1.2 Oracle Home to the new created oraInvento

To force Reboot : $echo 1 > /proc/sys/kernel/sysrq $echo b > /proc/sysrq-trigger To force Shutdown: $echo 1 > /proc/sys/kernel/sysrq $echo o > /proc/sysrq-trigger