note id 373303.1
find the runnung process’s environment
Author: Admin
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)” »
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…
tar and untar a dolder with all its subfolder.
Following command will be used for Tarring/copying local files and untarring/extracting at target folder. $ tar cf – * | ( cd /target; tar xfp -)
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.” »
FRA Information.
Applies to: Enterprise Manager for RDBMS – Version: 10.1.0.0 to 11.1 Oracle Server – Enterprise Edition – Version: 10.1.0.0 to 11.1 Information in this document applies to any platform. Purpose This article contains FAQ for Flash Recovery Area ( FRA ) Questions and Answers 1. What is a Flash Recovery Area and how to configure…
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…
secure crt settings
Copy on Select The Copy on select feature allows you to speed up the process of copying text from the terminal screen to the Clipboard. If this feature is enabled, text is copied to the Clipboard as soon as it is selected. To enable/disable the Copy on select feature: 1. Select the Terminal category in…
scp with ssh2
scp -p -o ‘protocol 2’ SOURCE_FILE TARGET_HOST:TARGET_FILE
Ports used by Oracle Software
files are $ORACLE_HOME/install/setupinfo.txt $ORACLE_HOME/install/portlist.ini