Solved

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

Posted on 2010-08-17
4
349 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

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 77

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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.

752 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