Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to connect to Oracle database in SQL

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report