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

Configure oracle snooping files

Direct copy and use

If the listening file you configure always goes wrong, you can copy the following information into your configuration file to change the host information.

TNS file tnsnames.ora

/ # tnsnames.ora Network Configuration File: / oracle/oracle/11g/network/admin/tnsnames.ora

/ # Generated by Oracle configuration tools.

/

/ ORCL =

/ (DESCRIPTION =

/ (ADDRESS = (PROTOCOL = TCP) (HOST = 10.1.1.10) (PORT = 1521)

/ (CONNECT_DATA =

/ (SERVER = DEDICATED)

/ (SERVICE_NAME = orcl)

/)

/)

Listen to the file listener.ora

# listener.ora Network Configuration File: / oracle/oracle/11g/network/admin/listener.ora

# Generated by Oracle configuration tools.

# remove the / number after pasting

/ # listener.ora Network Configuration File: / oracle/oracle/11g/network/admin/listener.ora

/ # Generated by Oracle configuration tools.

/

/ LISTENER =

/ (DESCRIPTION_LIST =

/ (DESCRIPTION =

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

/ (ADDRESS = (PROTOCOL = TCP) (HOST = master.example.com) (PORT = 1521)

/)

/)

/

/ ADR_BASE_LISTENER = / oracle/oracle

/

/ SID_LIST_LISTENER =

/ (SID_LIST =

/ (SID_DESC =

/ (GLOBAL_DBNAME = orcl)

/ (ORACLE_HOME = / oracle/oracle/11g)

/ (SID_NAME = orcl)

/)

/)

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.