Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

in oracle or sybase is there an ez way to determine the database instance name

Posted on 2010-08-17
4
Medium Priority
?
363 Views
Last Modified: 2013-12-19
I am a sysadmin.

Do I have to call the dba to get his information ?  

0
Comment
Question by:TIMFOX123
  • 2
  • 2
4 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33459683
In oracle a few ways to get database name.  This might be different from instance name.

Select * from global_name;

There are a few v$ vieww to get it from as well like V$instance.
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 33459693
On mobile. Sorry for misread:

Unix look for pmon process.

Windows look at oracle services.
0
 
LVL 27

Expert Comment

by:wilcoxon
ID: 33459719
In Sybase, you can do:

select db_name()
go
0
 
LVL 27

Assisted Solution

by:wilcoxon
wilcoxon earned 1000 total points
ID: 33459732
If you mean the process name, you can do "ps -ef | grep dataserver" on Unix.  I'm not sure what the executable name is on Windows.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question