When you connect to Oracle, localhost can have an IP address.

1. With Oracle installed on this machine, when using Sqlplus and Plsqldev connections, Tnsname.ora in the host write is localhost, at this time to connect Oracle no problem, but the external machine connected to the machine, and Tnsname.ora in the host write IP address (192.168.1.110) is, error ora-12547, no monitoring, etc.

2. Solve the problem, Oracle's own management tools, program-"oracle-oracle...-" configuration and porting Tools-"Net Manager Find local, LISTENER, add a listening service address, and then restart the Oracle monitoring service, Oracle can then be accessed using localhost and IP addresses.

3. LISTENER. Ora file

LISTENER =

(Description_list =

(DESCRIPTION =

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

)

(DESCRIPTION =

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

)

(DESCRIPTION =

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

)

）

Tnsname. Ora file

ORCL =

(DESCRIPTION =

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

(Connect_data =

(SERVER = dedicated)

(service_name = ORCL)

)

)

Orclip =

(DESCRIPTION =

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

(Connect_data =

(SERVER = dedicated)

(service_name = ORCL)

)

)

This article is from the "bad-kbase" blog, make sure to keep this source http://bad51men.blog.51cto.com/3141086/1660466

When you connect to Oracle, localhost can have an IP address.