Home » RDBMS Server » Server Administration » SIDs and ORATAB doubts !
SIDs and ORATAB doubts ! [message #63758] Fri, 05 November 2004 01:20 Go to next message
Vasco Saavedra
Messages: 3
Registered: October 2004
Junior Member
1- If there isn’t any tnsnames.ora, how can I get all the DB SIDs ?



 



 2 – Does /etc/oratab file contains ALL the instance names? Can I assume that all the BD Instances names are in this file?



  


Thanks in advance !

Report message to a moderator

Re: SIDs and ORATAB doubts ! [message #63763 is a reply to message #63758] Fri, 05 November 2004 03:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
tnsnames.ora is to identify the connectstrings for the clients.

Ideally, in $ORACLE_BASE/admin you can see one directory for every sid.
THERE no readymade_list that contains all SID.

oratab entries will show all the SID's.
But , SOMEONE can remove the entries at their will.

>>Can I assume that all the BD Instances
what is a BD instance here?

Report message to a moderator

Re: SIDs and ORATAB doubts ! [message #63774 is a reply to message #63758] Fri, 05 November 2004 05:39 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
1. tnsnames.ora has nothing to do with loca database servers.

2. NO. that file can be modified anytime and won't affect any db.

Best luck.
Remote DBA looking for remote job.

Report message to a moderator

Previous Topic: Location of Oracle alert log in diferent versions
Next Topic: ORA-27101
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:19:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.