Solved

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

Posted on 2010-08-17
4
343 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 76

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 76

Accepted Solution

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

Unix look for pmon process.

Windows look at oracle services.
0
 
LVL 26

Expert Comment

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

select db_name()
go
0
 
LVL 26

Assisted Solution

by:wilcoxon
wilcoxon earned 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now