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

Quickly view the information of the database connected to the Oracle service name: the specific operation command and result information are as follows :--------------------------------------------------

Quickly view the information of the database connected to the Oracle service name: the specific operation command and result information are as follows :--------------------------------------------------

Homepage → Database Technology

Background:

Read News

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

[Date: 2012-05-23] Source: Linux community Author: lsxy117 [Font:]

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 the Oracle topic page? Tid = 12

0

Oracle synonym learning

Oracle job learning

Oracle tutorials

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118