接上一篇：plsql連接 oracle instantclient_11_2 本地機(jī)器不安裝oracle_02
https://gblfy.blog.csdn.net/article/details/118115893

文章目錄

• • • • • • 1. 啟動(dòng)虛擬機(jī)
          • 2. 登錄虛擬機(jī)
          • 3. 開(kāi)啟網(wǎng)絡(luò)
          • 4. 獲取ip地址
          • 5. ssh工具連接
          • 6. 查看Oracle監(jiān)聽(tīng)運(yùn)行狀態(tài)
          • 7. 本地監(jiān)聽(tīng)添加連接串
          • 8. plsq連接遠(yuǎn)程oracle

1. 啟動(dòng)虛擬機(jī)

2. 登錄虛擬機(jī)

用戶(hù)密碼

oracle	oracle
bea	s開(kāi)頭 soft結(jié)尾

3. 開(kāi)啟網(wǎng)絡(luò)

4. 獲取ip地址

ifconfig

5. ssh工具連接

6. 查看Oracle監(jiān)聽(tīng)運(yùn)行狀態(tài)

[oracle@amadeus-oratest ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-JUN-2021 20:43:08Copyright (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 22-JUN-2021 20:31:44 Uptime 0 days 0 hr. 11 min. 23 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Listener Log File /app/oracle/diag/tnslsnr/amadeus-oratest/listener/alert/log.xml Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amadeus-oratest)(PORT=1521))) Services Summary... Service "lisdb" has 1 instance(s).Instance "lisdb", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@amadeus-oratest ~]$

7. 本地監(jiān)聽(tīng)添加連接串

找到本地tnsnames.ora監(jiān)聽(tīng)文件位置
我的位置J:\SOFTWARE\plsql\instantclient_11_2\network\ADMIN\tnsnames.ora

101 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = lisdb)))

8. plsq連接遠(yuǎn)程oracle

用戶(hù)密碼備注

lis	lis	lis屬于dba用戶(hù)

select * from dual;

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來(lái)咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的本地psql连接远程Oracle虚拟机_03的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

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