How To Transfer Passwords Between Databases (ref note: 199582.1)

Posted on By Admin No Comments on How To Transfer Passwords Between Databases (ref note: 199582.1)

fix: 1) Log on as SYSDBA 2) Create database link between source and target database 3) Create procedure which selects usernames,passwords from DBA_USERS in source database and inserts usernames,passwords into target database Sample SQL-statements source database: SQL> select password from dba_users where username=’SCOTT’; USERNAME PASSWORD —————————— —————— SCOTT F894844C34402B67 target database: Sqlplus> Create user SCOTT…

Read More “How To Transfer Passwords Between Databases (ref note: 199582.1)” »

Oracle, SQL scripts

Which environment is used by currently running process ( Very good)

Posted on By Admin No Comments on Which environment is used by currently running process ( Very good)

Goal After a process has been started, in order to find out the environment that was used to start it, the following methods can be used, depending on the OS platform: Solution 1. Determine the pid of the process at OS level, eg for the smon process: ps -ef | grep smon 2. Get the…

Read More “Which environment is used by currently running process ( Very good)” »

Linux/Unix, shell

Recovering lost SYS password

Posted on By Admin No Comments on Recovering lost SYS password

Recovering from lost sys password using OS authentication on Unix. #1. make sure that the OS user that is logged on is member of the dba group. If the dba group is not known, check the file: $ORACLE_HOME/rdbms/lib/config.c (or config.s) #2. make sure that the sqlnet.ora file does not contain the: sqlnet.authentication_services parameter. If this…

Read More “Recovering lost SYS password” »

Oracle, SQL scripts

longtx.sql with the flag whether session is blocking any DML locks or not.

Posted on By Admin No Comments on longtx.sql with the flag whether session is blocking any DML locks or not.

col machine format a30 col sid format 99999 col serial# format 99999 col sid_info format a14 col Transaction_id format a20 col username format a8 col days format 99.99 col hours1 format 999999 col TX_HRS format 999 col USER_HRS format 999 col LOCK format a2 set lines 120 pages 200 select a.sid || ‘,’ || a.serial#…

Read More “longtx.sql with the flag whether session is blocking any DML locks or not.” »

Oracle, SQL scripts

Oracle Connections expire_time and firewall

Posted on By Admin No Comments on Oracle Connections expire_time and firewall

When the client or server closes the communication it sends TCP FIN type packet, this is a normal socket closure. However, it is not uncommon that the client server communication abruptly ending without closing the end points properly by sending FIN packet, for example, when the client or server crashed, power down or a network…

Read More “Oracle Connections expire_time and firewall” »

Oracle, SQL scripts