OraFAQ Forum: Server Administration » Find information about oracle server on linux OS.

Home » RDBMS Server » Server Administration » Find information about oracle server on linux OS.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Find information about oracle server on linux OS. [message #146665]

Fri, 11 November 2005 20:16

jxh461
Messages: 185
Registered: March 2005

Senior Member

Hi all,

I know that I have an oracle server on my machine that I had someone build for me a while back for futur learning purposes. I lost information about the oracle server that was written on a peace of paper. I am a beginer oracle user and I would like to find out information such as:

what is the server name ?
what users are setup on the server besides sysdba ?

The operating system is redhat linux.

Thanks in advance.

Report message to a moderator

Re: Find information about oracle server on linux OS. [message #146679 is a reply to message #146665]

Sat, 12 November 2005 02:52

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

--> what is the server name ?

See the value of environment variable ORACLE_SID

 #echo $ORACLE_SID

or if you are able to log into Oracle as sys then

 select name from v$database;

--> what users are setup on the server besides sysdba ?

i hope you are talking about Oracle users and for that you have to log into Oracle as sys and then

 select username from dba_users;

regards,
tarun

Report message to a moderator

Previous Topic:	Need Oracle 8i on my Server with 9i and 10g
Next Topic:	Oracle DBMS_JOB ignore failures

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 09:40:39 CST 2025