OraFAQ Forum: SQL & PL/SQL » How to get Oracle sid?

Home » SQL & PL/SQL » SQL & PL/SQL » How to get Oracle sid?

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

How to get Oracle sid? [message #232954]

Tue, 24 April 2007 04:31

dumdum
Messages: 25
Registered: April 2007

Junior Member

I installed oracle database 10g express. How to get Oracle sid?

Report message to a moderator

Re: How to get Oracle sid? [message #232959 is a reply to message #232954]

Tue, 24 April 2007 04:47

virjil
Messages: 8
Registered: April 2007

Junior Member

Use the v$instance view to find it out

Report message to a moderator

Re: How to get Oracle sid? [message #232963 is a reply to message #232959]

Tue, 24 April 2007 05:04

dumdum
Messages: 25
Registered: April 2007

Junior Member

What is V$ view?I googled it but can't find out how to use V$ view. Sad

Report message to a moderator

Re: How to get Oracle sid? [message #232964 is a reply to message #232963]

Tue, 24 April 2007 05:08

virjil
Messages: 8
Registered: April 2007

Junior Member

V$ views are views of DBA users.

Connect as '/ as sysdba' to your instance and select the view searching for instance_name column.

Look at this for other v$ views
http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html

[Updated on: Tue, 24 April 2007 05:09]

Report message to a moderator

Re: How to get Oracle sid? [message #232965 is a reply to message #232963]

Tue, 24 April 2007 05:09

Frank
Messages: 7901
Registered: March 2000

Senior Member

your sid is most probably XE (I believe it is the default for 10g Express Edition).

v$ views are views owned by SYS, and are used to see all kinds of stuff about the database, metadata, etcetera.
If you don't know what a view is, don't worry. Chapter n of your book will tell Wink

Report message to a moderator

Re: How to get Oracle sid? [message #232966 is a reply to message #232964]

Tue, 24 April 2007 05:10

Frank
Messages: 7901
Registered: March 2000

Senior Member

virjil wrote on Tue, 24 April 2007 12:08

Connect as '/ as sysdba' to your instance and select the view searching for instance_name column.

Do NOT connect as sysdba if you don't know what you are doing.

Report message to a moderator

Re: How to get Oracle sid? [message #232967 is a reply to message #232966]

Tue, 24 April 2007 05:21

virjil
Messages: 8
Registered: April 2007

Junior Member

I suppose he knows... Laughing

If he don't knows maybe he'll be not able to do it.

Or not? Cool

Report message to a moderator

Re: How to get Oracle sid? [message #232997 is a reply to message #232967]

Tue, 24 April 2007 06:43

shivakumarag
Messages: 6
Registered: April 2007
Location: india

Junior Member

hi
go the oracle floder where init.ora is placed open it with notepad or wordpad see for sid
if oracle express its XE

[Updated on: Tue, 24 April 2007 06:46]

Report message to a moderator

Re: How to get Oracle sid? [message #233035 is a reply to message #232997]

Tue, 24 April 2007 07:46

dumdum
Messages: 25
Registered: April 2007

Junior Member

shivakumarag wrote on Tue, 24 April 2007 19:43

hi
go the oracle floder where init.ora is placed open it with notepad or wordpad see for sid
if oracle express its XE

Thank you all of you.
shivakumarag, Is it in C:\oraclexe? Where is the folder? I didn't see any folder or file called init.ora.

Report message to a moderator

Re: How to get Oracle sid? [message #233047 is a reply to message #233035]

Tue, 24 April 2007 08:00

shivakumarag
Messages: 6
Registered: April 2007
Location: india

Junior Member

hi
if ur using any other then oracle express edtion
like 9i or 10g so on

c:\......\oracle\product\10.1.0\admin\ora10g\pfile
db_name=ora10g

Report message to a moderator

Re: How to get Oracle sid? [message #233057 is a reply to message #233047]

Tue, 24 April 2007 08:47

dumdum
Messages: 25
Registered: April 2007

Junior Member

Thank you.

The path in my system is different from yours.There are so many folders. It takes so much time to search. So far, I get nothing.
Is it in C:\oraclexe\app\oracle\product\10.2.0\server?

Anyone use oracle database express 10.2.0?

Report message to a moderator