I believe that many beginners after installing oracle software, login to the database will encounter the following error: Ora-12514: TNS: listeners are currently unable to identify the request in the Link descriptor service. Check that the listener is enabled. There are two solutions: 1. Use sqlplusassysdba to connect and then use the conn command to establish a connection.
I believe that many beginners after installing oracle software, login to the database will encounter the following error: Ora-12514: TNS: listeners are currently unable to identify the request in the Link descriptor service. Check that the listener is enabled. There are two solutions: 1. Use sqlplus/as sysdba to connect and then use the conn command to establish a connection.
I believe that many beginners will encounter the following errors when logging on to the database after installing the oracle software:
Ora-12514: TNS: The Listener currently cannot identify the Service requested in the Link descriptor.
Check that the listener is enabled. There are two solutions:
1. Use "sqlplus/as sysdba" to connect and then use the "conn" command to establish a connection
But this method does not cure the root cause, so you need to log on like this every time.
2. Configure the listener. ora file in the path "% ORACLE_HOME/network/admin". If this file does not exist
You can copy a "samples" file under this directory to this directory, and then open the listener. ora file.
Remove comments from the following parts: (remove)
# LISTENER =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = tcp) (HOST = localhost) (PORT = 1521 ))
# (ADDRESS = (PROTOCOL = ipc) (KEY = PNPKEY )))
# SID_LIST_LISTENER =
# (SID_LIST =
# (SID_DESC =
# BEQUEATH CONFIG
# (GLOBAL_DBNAME = salesdb. mycompany)
# (SID_NAME = sid1)
# (ORACLE_HOME =/private/app/oracle/product/8.0.3)
# PRESPAWN CONFIG
# (PRESPAWN_MAX = 20)
# (PRESPAWN_LIST =
# (PRESPAWN_DESC = (PROTOCOL = tcp) (POOL_SIZE = 2) (TIMEOUT = 1 ))
#)
#)
#)
Then, modify the settings as follows:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
# BEQUEATH CONFIG
(GLOBAL_DBNAME = your own global database name)
(SID_NAME = Instance name)
(ORACLE_HOME = main directory path name)
# PRESPAWN CONFIG
(PRESPAWN_MAX = 20)
(PRESPAWN_LIST =
(PRESPAWN_DESC = (PROTOCOL = tcp) (POOL_SIZE = 2) (TIMEOUT = 1 ))
)
)
)
Then, each time you open the terminal, you can directly use the sqlplus command to connect to the database.