LinuxOracle9i maintenance personnel reflect that the database cannot be connected. The phenomenon is: tnsping can be connected, but sqlplus cannot be connected. If no error is reported, it is always on there.
Linux Oracle 9i maintenance personnel reflect that the database cannot be connected. The phenomenon is: tnsping can be connected, but sqlplus cannot be connected. If no error is reported, it is always there.
Linux Oracle 9i
The maintenance personnel reported that the database could not be connected. The phenomenon was: tnsping could be connected, but sqlplus could not be connected. If no error was reported, it was always there. The foreground application cannot log on.
Processing Process:
Log on to the database to view logs. Use sqlplus "/as sysdba" to log on. The show parameter session query is 330. Check whether the listening log exceeds 2 GB (NO ). If the listener is abnormal, restart the listener. The same result is found.
Check netstat-na and find that there is a very high port 1521. Check whether the system kernel parameter settings are insufficient.
After you manually kill an oracle connection process, you can log on through the process client. The cause of the fault is clear.
Set
Kernel. sem = 300 38400 300 128
Add the preceding parameter to increase the value. Root Password: sysctl-p
Get it done, and close the job.