ORATAB

"oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when installing database software. Originally ORATAB was used for SQL*Net V1, but lately is's being used to list the databases and software versions installed on a server.




This file may contain comments staring with a pound signs (#) in column one, and data lines consisting of entries in the following format:



database_sid:oracle_home_dir:Y|N



- database_sid is the system id (SID) of an Oracle instances on the server.



- Oracle_home_dir is the ORACLE_HOME directory associated with this instance.



- The Y|N flags indicate if the instance should automatically start at boot time (Y=yes, N=no).



Besides acting as a registry for what databases and software versions are installed on the server, ORATAB is also used for the following purposes:



◦Oracle's "dbstart" and "dbshut" scripts use this file to figure out which instances are to be start up or shut down (using the third field, Y or N).



◦The "oraenv" utility uses ORATAB to set the correct environment variables.





◦One can also write Unix shell scripts that cycle through multiple instances using the information in the oratab file.

Comments

Post a Comment

Popular posts from this blog

Application Express 3.2 Upgrade Missing Image And Javascript Error Solution

The cause for missing image and JavaScript error regarding Oracle Application Express Missing Images And JavaScript Error was the wrong image prefix.   The correct installation should have "/i/" instead of "/apex/TEMP". C:\\oraclexe\\apex\\utilities>sqlplus /nolog SQL> connect / as sysdba Connected. SQL> @reset_image_prefix.sql   It will prompt for Enter the Application Express image prefix [/i/]   Just enter and go forward... Ur problem is solved..   The reser_image_prefix.sql is available in the apex_home/apex/utilities folder After using reset_image_prefix.sql to update the image prefix the images that are missing now shows. Trying to login the administrator or developer page also now works. If you still experience some problem maybe the cause is different one
Read more

PRKH-1010 : Unable to communicate with CRS services

OS : AIX 5L Oracle 10g RAC Error message on one of the nodes PRKH - 1010 : Unable to communicate with CRS services I faced a typical issue.     The localconfig command has been used for a single instance RDBMS. There is absolutely no requirement to run localconfig on RAC system and it should never be used on RAC system as it will destroy the CRS configuration When the localconfig reset was run on only one system the following things happened. Ocr.loc was created at /etc/oracle/ora.loc. Cat /etc/oracle/ocr.loc is like : Ocrconfig_loc=<$ORACLE_HOME>/cdata/localhost/local.ocr Local_only=true   Cat /etc/inittab is like H1:35:respaw:/etc/init.d/init.evmd run >/dev/null 2>&1</dev/null H3:35:respawn:/etc/init.d/init.crsd run >/dev/null 2>&2 </dev/null H1:35:respawn:/etcc/init.d/init.dcssd run >/dev/null 2>&1 </dev/null<<< this one   As root Run the following scripts $ORA_CRS_HOME/install/rootdelete.sh $ORA_CRS_HOME/install/rootdeinstall...
Read more

Oracle Validated Configuration RPM

About the Oracle Validated Configuration RPM If your Linux distribution is Oracle Linux, or Red Hat Enterprise Linux, and you are an Unbreakable Linux customer, then you can complete most preinstallation configuration tasks by using the Oracle Validated Configurations Setup RPM, available from the Unbreakable Linux Network, or available on the Oracle Linux DVD disks. When it is installed, the Oracle Validated Configuration RPM does the following: • Automatically installs any additional packages needed for installing Oracle Grid Infrastructure and Oracle Database • Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user • Sets and verifies sysctl.conf settings, system startup parameters, user limits, and driver parameters to values based on recommendations from the Oracle Validated Configurations program To become an Unbreakable Linux Network customer, contact your sales representative, or purchase a license from the Unbreakable ...
Read more