Re: [OT] Get the database name in Oracle

if you're on unix, go to $ORACLE_HOME directory, then into dbs directory. there'll be a file there for each SID (database) with a file name initTHE_SPECIFIC_SID_NAME.ora
there'll be one entry for each SID/database (if it's not specified as * = ALL) in /etc/oratab.
On windows, go to oracle insallation directory, then database directory...there'll be a initSID_NAME.ora for each SID/database. There'll be a windows service for each SID, with a name like oracleserviceSID_NAME.

the hardest line to type correctly is: stty erase ^H

Comment on Re: [OT] Get the database name in Oracle

Replies are listed 'Best First'.
Re^2: [OT] Get the database name in Oracle by kulls (Hermit) on Jan 02, 2006 at 12:13 UTC
Thank you for your information. Can you show me in a sql query format to get the database name ?. I got your points which is relevent to the physical image, whereas i need to get the details like a query. Can you please ? -kulls	[reply]