Oracle Learning FAQs

Transferred from: http://blog.csdn.net/liusong0605/article/details/16349121

After completing the installation of Oracle and starting the service, you cannot log on by Sqlplus and the following error occurs:

SP2-1503: Unable to initialize Oracle call interface

Sp2-0152:oracle not working properly

Cause: Current user permissions issue

Solution:

Scenario one, run cmd as Administrator

Scenario two, locate Sqlplusw.exe in the Oracle installation path, properties--compatibility--privilege level--run this program as an administrator.

After modifying the permissions above, you can log in to Oracle via Sqlplus. However, there is still a problem signing in to Oracle via the Plsql client, and a blank bullet box appears after you enter your account password to log in.

Solution: Run Plsql as an administrator.

Here are a few common Oracle errors that were previously accumulated and are now summarized as follows:

One, Ora-12560:tns: Protocol Adapter error

Solution: Because the database instance is not up. Open the Services panel and start the ORACLESERVICEXXXX service. (xxxx is your ora-sid.)

Second, Ora-12514:tns: The listener is currently unable to identify the service requested in the connection descriptor

Solution: Speaking of Oracle service startup, after restarting the computer, if the resource manager can find the Oracle process, the database can be connected properly.

Third, Ora-12541:tns: no listening program

Solution: The reason is that there is no boot listener or the listener is corrupted. 1. Check if the monitoring service is turned on 2. If the listener service is turned on and there is still an error, create a new listener. Details: http://www.2cto.com/database/201204/126121.html

Iv. ora-01033:oracle initialization or shutdown in progress

Solution: One of the reasons may be caused by the accidental deletion of an Oracle tablespace file. Reference: http://blog.csdn.net/liusong0605/article/details/7650505

Oracle Learning FAQs