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

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

vi Commands

What is vi? The default editor that comes with the UNIX operating system is called vi (visual editor). The UNIX vi editor is a full screen editor and has two modes of operation: Command mode commands which cause action to be taken on the file, and Insert mode in which entered text is inserted into the file. In the command mode, every character typed is a command that does something to the text file being edited; a character typed in the command mode may even cause the vi editor to enter the insert mode. In the insert mode, every character typed is added to the text in the file; pressing the (Escape) key turns off the Insert mode. While there are a number of vi commands, just a handful of these is usually sufficient for beginning vi users. To assist such users, this Web page contains a sampling of basic vi commands. The most basic and useful commands are marked with an asterisk (* or star) in the tables below. With practice, these commands should become automatic. NO...
Read more

Dr. Walter Semkiw

I met Dr. Walter Semkiw on Jun 24, 2009. "Yes, reincarnating souls have same facial features", says Walter Semkiw, MD, author of the popular international bestseller BORN AGAIN, which became an instant hit with celebrity cases of Amitabh Bachchan, Shah Rukh Khan, former President Abdul Kalam, Indira Gandhi and a host of other Indian political legends and film stars. I met Mr.Walter Semkiw on his visit to India to promote his new book ORIGIN OF THE SOUL AND THE PURPOSE OF REINCARNATION published by Ritana Books. Walter Semkiw, MD, is a partner and practices medicine at Kaiser Permanente in San Francisco,USA, the largest medical group in the United States. In addition, he is the author of books on objective evidence of reincarnation which have been published in India, Indonesian, Serbia and the United States. In his presentations and book signings at Landmark Bookshops in Gurgaon [24 th June] , Dr Semkiw reviewed independently researched cases that demonstrate objective evide...
Read more