Shulou(Shulou.com)06/01 Report--

Monitoring Services and Access Connection Principles

Port number range: 1025~6500

[oracle@oracle3 ~]$ lsnrctl --Enter Monitoring Management Tool

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 11:13:20

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status --View listener status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 05-JUN-2014 09:38:27

Uptime 0 days 1 hr. 34 min. 54 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)) --The default port number is 1521, which is the port number that provides external services.

Services Summary...

Service "ORCL" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCL_XPT" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

SQL> conn system/orcl@ORCL33 --accessed via listener

Connected.

ORCL33 is called Network Service Name (Connection Descriptor), configuration file on client, not required on server.

F:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora --path to client. Network Service Name Profile

In the document:

ORCL33 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.3)(PORT = 1521)) --oracle server IP, port number, database name

)

(CONNECT_DATA =

(SERVICE_NAME = ORCL)

)

)

Add connection string two ways: 1, through the graphical interface 2, directly modify the file

Local direct access, do not need to go through the listener, host access is must go through the listener.

Connect with xmanager:

SQL> conn system/orcl --native access

Connected.

SQL> conn system/orcl@ORCL --natively accessed via listener

Connected.

Stop the listener

[oracle@oracle3 admin]$ lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 11:28:28

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

The command completed successfully

SQL> conn system/orcl --native access is not affected

Connected.

SQL> conn system/orcl@ORCL --Cannot connect via listener access

ERROR:

ORA-12541: TNS:no listener

Warning: You are no longer connected to ORACLE.

SQL> conn system/orcl@ORCL2567

ERROR:

ORA-12541: TNS: No listening program

Warning: You are no longer connected to ORACLE.

View status after starting listening:

[oracle@oracle3 admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 11:31:39

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 05-JUN-2014 11:30:50

Uptime 0 days 0 hr. 0 min. 49 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command successfully completed--At this point, it is still not remotely accessible because the database has not heard it yet.

At this time, connect:

SQL> conn system/orcl@ORCL2567

ERROR:

ORA-12541: TNS: No listening program

Warning: You are no longer connected to ORACLE.

[oracle@oracle3 admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 11:31:46

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 05-JUN-2014 11:30:50

Uptime 0 days 0 hr. 0 min. 55 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)))

Services Summary...

Service "ORCL" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service... --Database monitored.

Service "ORCLXDB" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "ORCL_XPT" has 1 instance(s).

Instance "ORCL", status READY, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

SQL> conn system/orcl@ORCL2567 --Remote access is normal at this time

Connected.

Simple test methods:

C:\Users\Administrator>tnsping ORCL2567 --ping Is the network descriptor accessible

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-June-

2014 11:38:41

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Parameter files used:

F:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

The TNSNAMES adapter has been used to resolve aliases

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)

(HOST = 10.1.3.3)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))

OK (30 ms)

[oracle@oracle3 admin]$ tnsping ORCL1

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 05-JUN-2014 11:41:09

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/u01/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name --ping的PERFORMANCE

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.