Solved

how to verify the instance logged in sqlplus

Posted on 2008-10-20
1
581 Views
Last Modified: 2013-12-18
hi
i have 2 oracle instances with the same name(one is on the old server and the other is on new server.)
when i login for both and i run this
select instance_name from v$instance
i see both the instances with the same name...off course the tns has diff host...

i want to know how can i know what hostname i m on ...from sql plus so that i know on which instance i am working on...
0
Comment
Question by:samir25
1 Comment
 
LVL 4

Accepted Solution

by:
hqassap earned 500 total points
ID: 22766196

SELECT instance_name, host_name
  FROM v$instance

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

837 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