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

Environment: oracle 11.2.0.4

Two database instances: orcl test

Hostname resolution: 192.168.1.30 orcl.lineqi.com orcl

[oracle@orcladmin] $ifconfig

Eth0 Link encap:Ethernet HWaddr 00:0C:29:40:07:9A

Inetaddr:192.168.1.30 Bcast:192.168.1.255 Mask:255.255.255.0

Inet6 addr:fe80::20c:29ff:fe40:79a/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:2548 errors:0 dropped:0overruns:0 frame:0

TX packets:1875 errors:0 dropped:0overruns:0 carrier:0

Collisions:0 txqueuelen:1000

RX bytes:262084 (255.9 KiB) TX bytes:263913 (257.7 KiB)

Eth2 Link encap:Ethernet HWaddr 00:0C:29:40:07:A4

Inet addr:192.168.1.31 Bcast:192.168.1.255 Mask:255.255.255.0

Inet6 addr:fe80::20c:29ff:fe40:7a4/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:297 errors:0 dropped:0overruns:0 frame:0

TX packets:11 errors:0 dropped:0overruns:0 carrier:0

Collisions:0 txqueuelen:1000

RX bytes:21490 (20.9KiB) TX bytes:746 (746.0 b)

1. Listen to an instance on different ports of two network interfaces. 1. Configure listener

[oracle@orcl admin] $cat listener.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LIST4 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.31) (PORT = 1524))

)

)

LIST3 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1523))

)

)

LIST2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1522))

)

)

LIST1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1521))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

2. Then configure tnsname.ora

Add the following to / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsname.ora.

ALL_LISTENER =

(

DESCRIPTION=

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1522))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1523))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.31) (PORT = 1524))

)

(

CONNECT_DATA=

(SERVICE_NAME = orcl)

)

)

3. Start and view the monitoring status

[oracle@orcladmin] $lsnrctl start list1

[oracle@orcladmin] $lsnrctl start list2

[oracle@orcladmin] $lsnrctl start list3

[oracle@orcladmin] $lsnrctl start list4

[oracle@orcladmin] $lsnrctl status list1

[oracle@orcladmin] $lsnrctl status list2

[oracle@orcladmin] $lsnrctl status list3

[oracle@orcladmin] $lsnrctl status list4

Note: under normal circumstances, orcl instances are registered to list1, and there are no services or instances on the rest of the listeners.

Do the following

SQL > alter system set local_listener=' ALL_LISTENER'

SQL > alter system register

View the status of each listener again

[oracle@orcl admin] $lsnrctl status list2

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 19:35:57

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.30) (PORT=1522)

STATUSof the LISTENER

-

Alias list2

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 17:02:56

Uptime 0 days 2 hr. 33 min. 1 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1522))

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...

Thecommand completed successfully

[oracle@orcl admin] $lsnrctl status list3

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 19:35:55

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.30) (PORT=1523)

STATUSof the LISTENER

-

Alias list3

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 19:16:16

Uptime 0 days 0 hr. 19 min. 38 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list3/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.30) (PORT=1523))

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...

Thecommand completed successfully

[oracle@orcl admin] $lsnrctl status list4

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 19:35:59

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.31) (PORT=1524)

STATUSof the LISTENER

-

Alias list4

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 19:16:14

Uptime 0 days 0 hr. 19 min. 45 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list4/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.31) (PORT=1524))

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...

Thecommand completed successfully

4. Pass the client test

C:\ Users\ Administrator > sqlpluslineqi/lineqi@192.168.1.30:1521/orcl

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 19:38:38 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Orcl

C:\ Users\ Administrator > sqlpluslineqi/lineqi@192.168.1.30:1522/orcl

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 19:38:55 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Orcl

C:\ Users\ Administrator > sqlpluslineqi/lineqi@192.168.1.30:1523/orcl

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 19:39:08 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Orcl

C:\ Users\ Administrator > sqlpluslineqi/lineqi@192.168.1.31:1524/orcl

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 19:41:11 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Orcl

The above is tested by EZCONNECT, or you can test it in the client configuration by adding the following in tnsname.ora.

Orcl=

(DESCRIPTION =

(ADDRESS_LIST =

(LOAD_BALANCE=ON)

(FAILOVER=ON)

(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1521))

(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1522))

(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1523))

(ADDRESS= (PROTOCOL = TCP) (HOST = 192.168.1.31) (PORT = 1524))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

Listen to multiple instances on different ports of a network interface

Description: 192.168.1.30 1521 listens to orcl instance

192.168.1.30,1522 listening on test instance

Currently, the port 1521 is listening to two instances.

[oracle@orcl admin] $lsnrctl status list1

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 17:00:27

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=orcl.lineqi.com) (PORT=1521)

STATUSof the LISTENER

-

Alias list1

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 15:45:52

Uptime 0 days 1 hr. 14 min. 35 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list1/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1521))

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

ServicesSummary...

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 "test" has 1 instance (s).

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

Service "testXDB" has 1 instance (s).

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

Thecommand completed successfully

1. Configure listener

You can configure list2 snooping here. You can use the netca tool or edit the listener.ora file directly.

[oracle@orcl admin] $cat listener.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LIST2 =

(DESCRIPTION_LIST =

(DESCRIPTION=

(ADDRESS = (PROTOCOL = TCP) (HOST = orcl.lineqi.com) (PORT = 1522))

)

)

LIST1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = orcl.lineqi.com) (PORT = 1521))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

ADR_BASE_LIST2 = / u01/app/oracle

ADR_BASE_LIST1= / u01/app/oracle

[oracle@orcl admin] $lsnrctl start list2

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 17:02:56

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Starting/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNRfor Linux: Version 11.2.0.4.0-Production

Systemparameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Logmessages written to / u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml

Listeningon: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1522)

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=orcl.lineqi.com) (PORT=1522)

STATUSof the LISTENER

-

Alias list2

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 17:02:56

Uptime 0 days 0 hr. 0 min. 0 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1522))

Thelistener supports no services

Thecommand completed successfully

No service or instance is being monitored at this time

2. Then configure tnsname.ora

[oracle@orcl admin] $cat tnsnames.ora

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

Test =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1522))

)

(CONNECT_DATA =

(SERVICE_NAME = test)

)

)

Do the following

SQL > alter system set local_listener='test'

SQL > alter system register

Then check the list2 status and find that the instance has been registered successfully.

[oracle@orcladmin] $lsnrctl status list2

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 17:06:04

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=orcl.lineqi.com) (PORT=1522)

STATUSof the LISTENER

-

Alias list2

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 17:02:56

Uptime 0 days 0 hr. 3 min. 7 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1522))

ServicesSummary...

Service "test" has 1 instance (s).

Instance "test", status READY, has1 handler (s) for this service...

Service "testXDB" has 1 instance (s).

Instance "test", status READY, has1 handler (s) for this service...

Thecommand completed successfully

Now check list1 and find that 1521 of this product only listens to orcl instances.

[oracle@orcladmin] $lsnrctl status list1

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 17:06:47

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=orcl.lineqi.com) (PORT=1521)

STATUSof the LISTENER

-

Alias list1

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 15:45:52

Uptime 0 days 1 hr. 20 min. 54 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1521))

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

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...

The command completed successfully

3. Pass the client test

C:\ Users\ Administrator > sqlplussystem/test@192.168.1.30:1522/test

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 17:09:52 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Test

C:\ Users\ Administrator > sqlpluslineqi/lineqi@192.168.1.30:1521/orcl

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 17:09:34 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Orcl

Configure listeners to listen to two instances on two network interfaces

Description: 192.168.1.30 1521 listens to orcl instance

192.168.1.31 1522 listens on the test instance

Instance orcl has already been listening after creating list1 listener. You can configure list2 listener directly here.

[oracle@orcl admin] $lsnrctl status list1

LSNRCTL for Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 16:41:25

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

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=orcl.lineqi.com) (PORT=1521)

STATUS of the LISTENER

-

Alias list1

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

Start Date 17-MAY-2015 15:45:52

Uptime 0 days 0 hr. 55 min. 32 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File / u01/app/oracle/diag/tnslsnr/orcl/list1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1521))

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

Services Summary...

Service "orcl" has 1 instance (s).

Instance "orcl", status READY, has1 handler (s) for this service...

Service "orclXDB" has 1 instance (s).

Instance "orcl", status READY, has1 handler (s) for this service...

Thecommand completed successfully

1. Configure listener

You can configure list2 snooping here. You can use the netca tool or edit the listener.ora file directly.

[oracle@orcl admin] $cat listener.ora

# listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LIST2 =

(DESCRIPTION_LIST =

(DESCRIPTION=

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.31) (PORT = 1522))

)

)

LIST1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = orcl.lineqi.com) (PORT = 1521))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

)

ADR_BASE_LIST2 = / u01/app/oracle

ADR_BASE_LIST1= / u01/app/oracle

2. Then configure tnsname.ora

[oracle@orcl admin] $cat tnsnames.ora

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.30) (PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

Test =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.31) (PORT = 1522))

)

(CONNECT_DATA =

(SERVICE_NAME = test)

)

)

3. Start list2 and check the status

[oracle@orcl admin] $lsnrctl startlist2

[oracle@orcl admin] $lsnrctl status list2

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 16:06:55

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.31) (PORT=1522)

STATUSof the LISTENER

-

Alias LIST2

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 15:57:56

Uptime 0 days 0 hr. 8 min. 58 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1522))

Thelistener supports no services

Thecommand completed successfully

No service or instance is found to be monitored here.

Do the following

SQL > alter system set local_listener='test'

SQL > alter system register

Then check the list2 status and find that the instance has been registered successfully.

[oracle@orcl admin] $lsnrctl status list2

LSNRCTLfor Linux: Version 11.2.0.4.0-Production on 17-MAY-2015 16:08:03

Copyright (c) 1991, 2013, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.1.31) (PORT=1522)

STATUSof the LISTENER

-

Alias LIST2

Version TNSLSNR for Linux: Version11.2.0.4.0-Production

StartDate 17-MAY-2015 15:57:56

Uptime 0 days 0 hr. 10 min. 7 sec

TraceLevel off

Security ON: Local OSAuthentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=orcl.lineqi.com) (PORT=1522))

ServicesSummary...

Service "test" has 1 instance (s).

Instance "test", status READY, has1 handler (s) for this service...

Service "testXDB" has 1 instance (s).

Instance "test", status READY, has1 handler (s) for this service...

Thecommand completed successfully

4. Pass the client test

C:\ Users\ Administrator > sqlplussystem/test@192.168.1.31:1522/test

SQL*Plus:Release 11.2.0.1.0 Production on Sunday May 17 16:21:09 2015

Copyright (c) 1982, 2010, Oracle. All rightsreserved.

Connect to:

OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With thePartitioning, OLAP, Data Mining and Real Application Testing options

SQL > select instance_name from v$instance

INSTANCE_NAME

-

Test

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.