How to quickly view the database connected by the Oracle service name

Quick View of the database connected by the Oracle service name:

The specific operation command and result information are as follows:

------------------------------------------------------------------

C: \ Documents ents and Settings \ Administrator> tnsping lsxy

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0-Production on 2012 16:11:54

Copyright (c) 1997,201 0, Oracle. All rights reserved.

Used parameter files:

D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ sqlnet. ora

-- Check the general location of the local Oracle configuration file

Alias resolved using TNSNAMES Adapter

Try to connect (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = xxx. x. x. xx) (PORT = 2261) (CONNECT_DATA = (SERVICE_NAME = lsxy )))

-- Check whether the service name is correct and the configured IP address and port number.

OK (10 ms)

C: \ Documents ents and Settings \ Administrator>

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12