1. pl/SQL cannot connect to the local oracle (ORA 12154: TNS: the specified connection identifier cannot be resolved)
Solution: pl/SQL cannot be installed in the Program Files (x86) folder, and must be installed in the Program Files folder.
2. pl/SQL cannot connect to remote oracle (ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection descriptor)
Solution: ① in linux, locate listener. ora in the oracle directory and use vi to edit
② The following red is the add part. GLOBAL_DBNAME must be consistent with the oracle network name configured by the client, and SID_NAME must be consistent with the local database instance name.
Copy codeThe Code is as follows:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Lxorcl)
(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
3. Start and close oracle listeners
Copy codeThe Code is as follows:
Start: lsnrctl start
Disable: lsnrctl stop
Status: lsnrctl status