Oracle error ORA-12514 Solution

After the connection to the database is successful, check the listener status: lsnrctlstatusstatusREADY status, which must be switched from non-archive to archive mode. The operation is as follows: 1. Disable

After the connection to the database is successful, check the listener status: lsnrctl status READY status, which must be switched from non-archive to archive mode. The operation is as follows: 1. Close

Oracle error ORA-12514 Solution

[Date: 2013-02-18] Source: Linux Author: qixin [Font:]

After successfully connecting to the database, check the listener status: lsnrctl status

Status READY status, which must be switched from non-archive to archive. The operation is as follows:

1. Shut down the database shutdown immediate and shut down normally;

2. Start the database to the mount status and start up mount. An error occurs:

3. Check the listener status at this time: lsnrctl status

Status BLOCKED status, online search solution

4. Rewrite the listener. ora file (Red is the added part)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)

(Oracle_HOME = f: \ oracle \ product \ 10.1.0 \ Db_1)
(PROGRAM = extproc)

)

(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = f: \ oracle \ product \ 10.1.0 \ Db_1)
(SID_NAME = orcl)
)
)

5. Restart the listener: lsnrctl start; check the status of lsnrctl:

Status UNKNOWN.