Oracle Database Backup export, error: ORA-12514 resolved connection Oracle 10g error: ORA-12514: TNS: Listeners currently unable to recognize requests in the connection Descriptor
Solution: 1. open <OracleHome>/network/admin/listener. ora file, find: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1) (PROGRAM = extproc ))) 2. add: (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1) (SID_NAME = ORACLE) 3. last changed to: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1) (PROGRAM = extproc )) (SID_DESC = (GLOBAL_DBNAME = ORACLE) (ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1) (SID_NAME = ORACLE )))
Note: cannot add (PROGRAM = extproc) 4. Save the file, restart TNSListener in the service, OK!