Shulou(Shulou.com)05/31 Report--

This article introduces you how to connect to the Oracle database in SQL, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1. ORA-12514:TNS: the listener currently does not recognize the service requested in the connection descriptor.

Cd $ORACLE_HOME

Cd network/admin

The listener.ora file in the directory is not configured correctly.

Listener.ora should be configured as follows:

# listener.ora Network Configuration File: / u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.108) (PORT = 1521))

)

)

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_DBANAME = ORCL)

(ORACLE_HOME = / u01/app/oracle/product/10.2.0/db_1)

(SID_NAME = ORCL)

)

)

II. ORA-01034:ORACLE not available

ORA-27101:shared memory realm does not exist

The setting for ORACLE_HOME or ORACLE_SID set in 1.listener.ora is incorrect.

Check ORACLE_HOME and ORACLES_SID and pay attention to case.

two。 Or the Oracle instance is not started.

Sqlplus "/ as sysdba"

Startup starts the Oracle instance

About how to connect to the Oracle database in SQL can be shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.