OracleORA-12514 Solution

Oracle ORA-12514 Solution

When Oracle uses exp to export table data, a ORA-12514 occurs and the findings share error: ORA-12514: TNS: The Listener currently cannot identify the service reason requested in the connection descriptor: SID configuration error, SID is not in the listener list. Change ORACLE_SID configuration inconsistent with that in tns. Solution: Set SID to orcl 1. change the environment ORACLE_SID = orcl 2. modify $ ORACLE_HOME/network/admin/listener. ora, (insert if not) the following configuration: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = orcl) (ORACLE_HOME =/oracle/app/oracle/product/db_1 ))) ORACLE_HOME depends on the actual situation. 3. modify $ ORACLE_HOME/network/admin/tnsnames. ora, (insert if not) the following configuration: ORCL = (DESCRIPTION = ............ (CONNECT_DATA = ............. (SERVICE_NAME = orcl) 4. lsnrctl stop; lsnrctl start
PS: the cause of this error may not be the same. If the problem cannot be solved, don't blame the author. If the problem is solved, Please applaud. The above is for reference only.