Oracle client cannot connect to server-side solutions and steps

The client cannot connect to the server-side database for reasons such as network, configuration, file access, whether the database service has been started, and so on, the following are the general troubleshooting steps:
1. Check whether the operating system level network is unobstructed

Ping 192.168.10.1

2. Check whether the database layer network is unobstructed

Tnsping Myserverdb

3. Check that the listening status is normal

LSNRCTL Status Listener

4. If the second step is not available, check that the server monitor configuration is correct

The listening file configuration is generally as follows

# Listener Name

Listener=

(discription =

(address= (PROTOCOL = TCP) (host=192.168.4.80) (port=1521))

)

# Listen to the list of services

Sid_list_listener =

(

Sid_list =

(Sid_desc =

(Global_dbname = ORCL)

(Oracle_home = F:\app\Administrator\product\11.2.0\dbhome_1)

(Sid_name = ORCL)

)

(Sid_desc =

)

...

)

5. Check that the client Tnsnames.ora is configured correctly

Where the protocol, hostname, port, database instance name should be consistent with the server

6. Check the listening log listener.log file to find the corresponding log

7. Check file permissions

Check that the/var/tmp/.oracle file belongs to a group that must be a Oinstall group for the client to connect

This article is from the "8016776" blog, please be sure to keep this source http://8026776.blog.51cto.com/8016776/1695683

Oracle client cannot connect to server-side solutions and steps