Plsql cannot connect to the oracle server in linux

Plsql cannot connect to the oracle server in linux. Recently, when the company was down, it was found that after oracle data and listening programs in linux started normally, plsql on the client still could not connect to the server, ORA-12514 error reported, www.2cto.com found in general, oracle server installed, listening to the configuration file listener. you do not need to specify the service name of the listener in ora (by default, the service name of the listener is not specified). However, once your database service and listener service are disabled, then restart the Database Service and listening service, use plsql to connect to the database, there will be a ORA-12514 problem, then we must in listener. configure the corresponding service in the ora file. Then restart the database and listening service. When the listener registers the service specified in listener to the Process Monitor (pmon), plsql can connect to the database normally. Script command: linux environment: www.2cto.com 1. modify listener. by default, a ora file contains the following content: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = your server ip address) (PORT = 1521 )) (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) www.2cto.com when there is a ORA-12514 problem, we need to add the service configuration: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora11g) (ORACLE_HOME =/home/oracle/app/oracle/product/11.1.0/db_1) (SID_NAME = ora11g) 2. start the relevant database and listener services and log on to the database as oracle: su-oracle www.2cto.com to enter the sqlplus Console: sqlplus/nolog log on to the system administrator: connect/as sysdba to close the database: shutdown immediate exit sqlplus Console: exit enter listener Console: lsnrctl close listener: stop start listener: start www.2cto.com exit listener Console: exit