怎么感覺oracle和sql server是一個(gè)貨色。裝個(gè)服務(wù)得裝半天，還是mysql好，一下子就好了！下面有一個(gè)在centos7上面安裝oracle11g的詳細(xì)步驟，感覺找不到比這個(gè)更詳細(xì)的了吧！

centos7安裝詳細(xì)步?? ：https://www.cnblogs.com/VoiceOfDreams/p/8308601.html

navicat連接oracle

安裝數(shù)據(jù)庫(kù)之后在使用客戶端連接數(shù)據(jù)庫(kù)的時(shí)候總是報(bào)如下錯(cuò)誤：

ORA-12514: TNS:listener does not currently know of service requested in connect

然后百度+谷歌，解決辦法說是修改listener.ora文件，在文件中添加如下內(nèi)容：【下面文件中標(biāo)紅的表示添加的內(nèi)容】

[oracle@oracle ~]$ cd /data/oracle/product/11.2.0/db_1/network/admin/ [oracle@oracle admin]$ cat listener.ora # listener.ora Network Configuration File: /data/oracle/product/11.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 = 10.9.8.201)(PORT = 1521))) (SID_DESC =(GLOBAL_DBNAME = orcl)(ORACLE_HOME = /data/oracle/product/11.2.0/db_1)(SID_NAME = orcl)))ADR_BASE_LISTENER = /data/oracle

添加完之后重新啟動(dòng)監(jiān)聽器，連接的時(shí)候報(bào)如下錯(cuò)誤：

ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

又去百度+谷歌，大部分答案都是說tnsnames.ora中service_name寫成了server_name等，可是tnsnames.ora這個(gè)文件是oracle服務(wù)器自己生成的啊。

這時(shí)候查看監(jiān)聽器狀態(tài)會(huì)有如下提示：

[oracle@oracle ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-MAY-2019 21:35:17Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 14-MAY-2019 19:16:38 Uptime 0 days 2 hr. 18 min. 39 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/oracle/listener/alert/log.xml Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.8.201)(PORT=1521))) The listener supports no services #這里提示沒有服務(wù) The command completed successfully

最后的解決辦法，重啟監(jiān)聽器，重啟服務(wù)器。

[oracle@oracle admin]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Tue May 14 21:57:46 2019Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> connect sys / as sysdba Enter password: Connected. SQL> shutdown immediate #關(guān)閉oracle服務(wù)器 Database closed. Database dismounted. ORACLE instance shut down. SQL> startup #啟動(dòng)oracle服務(wù)器 ORACLE instance started.Total System Global Area 759943168 bytes Fixed Size 2217224 bytes Variable Size 507513592 bytes Database Buffers 247463936 bytes Redo Buffers 2748416 bytes Database mounted. Database opened. SQL>

查看監(jiān)聽器狀態(tài)：

[oracle@oracle admin]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 14-MAY-2019 22:18:47Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 14-MAY-2019 19:16:38 Uptime 0 days 3 hr. 2 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/oracle/listener/alert/log.xml Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.8.201)(PORT=1521))) Services Summary... Service "orcl" has 1 instance(s).Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s).Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully

使用客戶端連接oracle數(shù)據(jù)庫(kù)：

[oracle@oracle admin]$ sqlplus scott/tiger@10.9.8.201/orclSQL*Plus: Release 11.2.0.1.0 Production on Tue May 14 22:19:21 2019Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>

客戶端連接成功：

?

更改oracle監(jiān)聽端口

oracle安裝之后監(jiān)聽的本地的127.0.0.1這個(gè)ip，但是在window系統(tǒng)連接很顯然不行的，更改上面提到的哪兩個(gè)文件中的localhost為服務(wù)器的ip即可，然后重啟監(jiān)聽器。

[oracle@oracle admin]$ cat listener.ora # listener.ora Network Configuration File: /data/oracle/product/11.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 = 10.9.8.201)(PORT = 1521)))(SID_DESC =(GLOBAL_DBNAME = orcl)(ORACLE_HOME = /data/oracle/product/11.2.0/db_1)(SID_NAME = orcl)))ADR_BASE_LISTENER = /data/oracle[oracle@oracle admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /data/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.LISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.8.201)(PORT = 1521))ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.8.201)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))

?oracle的sys用戶遠(yuǎn)程登錄

SQL> show parameter passNAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ remote_login_passwordfile string EXCLUSIVE SQL>


remote_login_passwordfile有3個(gè)取值，取值如下：

none：不允許sysdba用戶組成員遠(yuǎn)程登錄訪問數(shù)據(jù)庫(kù)

exclusive: 只允許口令文件用于本數(shù)據(jù)庫(kù)，允許sysdba用戶組成員遠(yuǎn)程登錄訪問數(shù)據(jù)庫(kù)

shared： 允許其他數(shù)據(jù)庫(kù)使用該口令文件，允許sysdba用戶組成員遠(yuǎn)程登錄訪問數(shù)據(jù)庫(kù)。

這個(gè)值設(shè)置若是none，則需要通過以下語(yǔ)句設(shè)置為exclusive.

SQL> alter system set remote_login_passwordfile=exclusive scope=spfile; System altered.

然后需要重新啟動(dòng)數(shù)據(jù)庫(kù)。

以上完成之后，設(shè)置sys用戶的密碼：

SQL> alter user sys identified by 123456;User altered.

在navicat中填入對(duì)應(yīng)的連接字段，點(diǎn)擊測(cè)試，報(bào)如下錯(cuò)誤：

這時(shí)候點(diǎn)擊，高級(jí)選項(xiàng)，把角色選為sysdba,連接即可！

?

轉(zhuǎn)載于:https://www.cnblogs.com/wxzhe/p/10861986.html

總結(jié)

以上是生活随笔為你收集整理的navicat连接客户端报错的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。