[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

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

I am a sysadmin.

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

0
TIMFOX123
Asked:
TIMFOX123
  • 2
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
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
 
slightwv (䄆 Netminder) Commented:
On mobile. Sorry for misread:

Unix look for pmon process.

Windows look at oracle services.
0
 
wilcoxonCommented:
In Sybase, you can do:

select db_name()
go
0
 
wilcoxonCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now