Title: How to get Oracle environment information from UNIX
Date: June 2007
NV Version: NA
OS Version: UNIX/LINUX
Application version:
Plugin version: NA
Description: Instructions for extracting Oracle environment information for UNIX or LINUX.
Symptoms:
Log into a UNIX/LINUX shell as the user "oracle".
>ps -ef |grep ora - shows oracle processes running
>echo $ORACLE_HOME - shows oracle home
>echo $ORACLE_SID - shows default SID, not that this may not be the only ORACLE_SID
Log into oracle using a sqlplus session
> sqlplus /nolog
SQL> connect / as sysdba
SQL> select user from dual; - shows which user we logged in as
SQL> select * from v$instance; - shows various information including oracle version, SID and HOSTNAME
SQL> select * from dba_data_files; - shows us the physical location of the data files
SQL> archive log list; - shows us the archive log config and location
SQL> show parameter log_archive_format;
Manual:
we also need the location of the spfile or the pfile. On linux these are usually in $ORACLE_HOME/dbs, if there is an spfile it is used and the naming convention is SPFILE<SID>.ORA, if thereis no SPFILE the the pfile is used, its naming convention is init<SID>.ora
English version available ID: 2312
Version française disponible ID
Deutsche Version verfügbar ID
