Home » SQL & PL/SQL » SQL & PL/SQL » How to get Oracle sid?
How to get Oracle sid? [message #232954] Tue, 24 April 2007 04:31 Go to next message
dumdum
Messages: 25
Registered: April 2007
Junior Member
I installed oracle database 10g express. How to get Oracle sid?
Re: How to get Oracle sid? [message #232959 is a reply to message #232954] Tue, 24 April 2007 04:47 Go to previous messageGo to next message
virjil
Messages: 8
Registered: April 2007
Junior Member
Use the v$instance view to find it out
Re: How to get Oracle sid? [message #232963 is a reply to message #232959] Tue, 24 April 2007 05:04 Go to previous messageGo to next message
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
Re: How to get Oracle sid? [message #232964 is a reply to message #232963] Tue, 24 April 2007 05:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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
Re: How to get Oracle sid? [message #232966 is a reply to message #232964] Tue, 24 April 2007 05:10 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: How to get Oracle sid? [message #232967 is a reply to message #232966] Tue, 24 April 2007 05:21 Go to previous messageGo to next message
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
Re: How to get Oracle sid? [message #232997 is a reply to message #232967] Tue, 24 April 2007 06:43 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: How to get Oracle sid? [message #233047 is a reply to message #233035] Tue, 24 April 2007 08:00 Go to previous messageGo to next message
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
Re: How to get Oracle sid? [message #233057 is a reply to message #233047] Tue, 24 April 2007 08:47 Go to previous messageGo to next message
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?


Re: How to get Oracle sid? [message #233065 is a reply to message #233057] Tue, 24 April 2007 09:05 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

you came close

Quote:
Is it in C:\oraclexe\app\oracle\product\10.2.0\server?


just two more folders Cool


D:\oraclexe\app\oracle\product\10.2.0\server\config\scripts

regards,
shanth
Re: How to get Oracle sid? [message #233067 is a reply to message #233065] Tue, 24 April 2007 09:10 Go to previous messageGo to next message
dumdum
Messages: 25
Registered: April 2007
Junior Member
shanthkumaar wrote on Tue, 24 April 2007 22:05
hi,

you came close

Quote:
Is it in C:\oraclexe\app\oracle\product\10.2.0\server?


just two more folders Cool


D:\oraclexe\app\oracle\product\10.2.0\server\config\scripts

regards,
shanth

Finally, got it!Thank you so much!
Re: How to get Oracle sid? [message #233069 is a reply to message #233067] Tue, 24 April 2007 09:12 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

Razz
Previous Topic: function call another function?
Next Topic: ORA-01861: literal does not match format string
Goto Forum:
  


Current Time: Fri Dec 09 07:31:17 CST 2016

Total time taken to generate the page: 0.04825 seconds