Modify and test the listening configuration of Oracle11g in OracleEnterpriseLinux64-bit

Test environment: Oracle Enterprise Linux 64-bit (version 5.8) + Oracle 11g 64-bit

Related Description: the installation location of the Oracle11g64-bit software is/u01/app/oracle/product/11.2.0/dbhome_1, the database name is the default orcl, And the IP address of the Linux virtual machine is set to 192.168.1.121.

1. modify the content of the listener. ora File

Command: [oracle @ gpdb ~] $ Vi/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener. ora

LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.121) (PORT = 1521 )))

Command: [oracle @ gpdb ~] $ Vi/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames. ora

Command: [oracle @ gpdb ~] $ Lsnrctl start

Copyright (c) 1991,200 9, Oracle. All rights reserved.

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

TNSLSNR for Linux: Version 11.2.0.1.0-Production

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.121) (PORT = 1521 )))

Command: [oracle @ gpdb ~] $ Sqlplus/as sysdba

Copyright (c) 1991,200 9, Oracle. All rights reserved.

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.121) (PORT = 1521 )))

Iv. Test Procedure in Windows

Command: C: \ Documents ents and Settings \ Administrator> tnsping 192.168.1.121

Copyright (c) 1997,200 8, Oracle. All rights reserved.

Used parameter files:

Used EZCONNECT adapter to resolve the alias

C: \ Documents ents and Settings \ Administrator>

2> Use plsqldev.exe to test and modify the C: \ Program Files \ Oracle \ Instant Client \ bin \ tnsnames. ora file to add the connection content to the Virtual Machine Oracle.

GPDB =