linux6.x+oracle11g测试配置ipv6

em2 Link encap:Ethernet HWaddr C8:1F:66:E3:DC:17
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
Interrupt:38

em3 Link encap:Ethernet HWaddr C8:1F:66:E3:DC:18
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
Interrupt:34

em4 Link encap:Ethernet HWaddr C8:1F:66:E3:DC:19
inet6 addr: fe80::ca1f:66ff:fee3:dc19/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:3 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:270 (270.0 b)
Interrupt:36

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536 Metric:1
RX packets:1799265 errors:0 dropped:0 overruns:0 frame:0
TX packets:1799265 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:384973715 (367.1 MiB) TX bytes:384973715 (367.1 MiB)

vmnet1 Link encap:Ethernet HWaddr 00:50:56:C0:00:01
inet addr:172.16.56.1 Bcast:172.16.56.255 Mask:255.255.255.0
inet6 addr: fe80::250:56ff:fec0:1/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:6 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

vmnet8 Link encap:Ethernet HWaddr 00:50:56:C0:00:08
inet addr:192.168.181.1 Bcast:192.168.181.255 Mask:255.255.255.0
inet6 addr: fe80::250:56ff:fec0:8/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
测试ipv6联通性：
[root@lnkf ~]# ping6 2024::57 -c3
PING 2024::57(2024::57) 56 data bytes
64 bytes from 2024::57: icmp_seq=1 ttl=64 time=0.056 ms
64 bytes from 2024::57: icmp_seq=2 ttl=64 time=0.044 ms
^C
--- 2024::57 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1704ms
rtt min/avg/max/mdev = 0.044/0.050/0.056/0.006 ms
[root@lnkf ~]# ping6 fe80::ca1f:66ff:fee3:dc16%em1 -c3
PING fe80::ca1f:66ff:fee3:dc16%em1(fe80::ca1f:66ff:fee3:dc16) 56 data bytes
64 bytes from fe80::ca1f:66ff:fee3:dc16: icmp_seq=1 ttl=64 time=0.066 ms
64 bytes from fe80::ca1f:66ff:fee3:dc16: icmp_seq=2 ttl=64 time=0.087 ms
^C
--- fe80::ca1f:66ff:fee3:dc16%em1 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1488ms
rtt min/avg/max/mdev = 0.066/0.076/0.087/0.013 ms

配置监听ipv6:
[root@lnkf ~]# su - oracle
[oracle@lnkf ~]$ pwd
/home/oracle
[oracle@lnkf ~]$ cd $ORACLE_HOME/network/admin
[oracle@lnkf admin]$ vi listener.ora
# listener.ora Network Configuration File: /oracle/app/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 = 192.168.205.57)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 2024::57)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /oracle/app

~
"listener.ora" 14L, 432C written
[oracle@lnkf admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-MAY-2024 14:01:58

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.205.57)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=2024::57)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@lnkf admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-MAY-2024 14:02:00

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /oracle/app/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /oracle/app/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/diag/tnslsnr/lnkf/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.205.57)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2024::57)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 20-MAY-2024 14:02:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/diag/tnslsnr/lnkf/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.205.57)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2024::57)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@lnkf admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-MAY-2024 14:02:04

Copyright (c) 1991, 2013, 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.4.0 - Production
Start Date 20-MAY-2024 14:02:00
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/diag/tnslsnr/lnkf/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.205.57)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2024::57)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@lnkf admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 20 14:02:08 2024

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system register;

System altered.

SQL> /

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lnkf admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-MAY-2024 14:02:21

Copyright (c) 1991, 2013, 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.4.0 - Production
Start Date 20-MAY-2024 14:02:00
Uptime 0 days 0 hr. 0 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/app/diag/tnslsnr/lnkf/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.205.57)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2024::57)(PORT=1521)))
Services Summary...
Service "lndb" has 1 instance(s).
Instance "lndb", status READY, has 1 handler(s) for this service...
Service "lndbXDB" has 1 instance(s).
Instance "lndb", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@lnkf admin]$ ll
total 24
-rw-r--r-- 1 oracle oinstall 432 May 20 14:01 listener.ora
-rw-r--r-- 1 oracle oinstall 357 May 20 13:53 listener.ora20240520
drwxr-xr-x 2 oracle oinstall 4096 Feb 22 2019 samples
-rw-r--r-- 1 oracle oinstall 381 Dec 17 2012 shrept.lst
-rw-r--r-- 1 oracle oinstall 284 Jan 25 2021 sqlnet.ora
-rw-r----- 1 oracle oinstall 497 Apr 10 2019 tnsnames.ora
[oracle@lnkf admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/app/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LNDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnkf)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lndb)
)
)

LNDB58 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.205.58)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lndb)
)
)

[oracle@lnkf admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/app/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LNDB57 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2024::57)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lndb)
)
)
~
~
"tnsnames.ora" 30L, 671C written
[oracle@lnkf admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/app/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LNDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnkf)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lndb)
)
)

LNDB58 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.205.58)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lndb)
)
)

LNDB57 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2024::57)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = lndb)
)
)
测试ipv6连接：正常
[oracle@lnkf admin]$ sqlplus jyc/jyc@lndb57

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 20 14:07:58 2024

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected
[oracle@lnkf admin]$ sqlplus jyc/jyc@[2024::57]:1521/lndb

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 20 14:03:40 2024

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
J1
J2
T
T1
T2

SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

测试ipv4连接同样可以：
[oracle@lnkf admin]$ sqlplus jyc/jyc@192.168.205.57:1521/lndb

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 20 14:07:13 2024

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lnkf admin]$

[root@lnkf ~]# netstat -ano|grep LISTEN|grep 1521
tcp 0 0 192.168.205.57:1521 0.0.0.0:* LISTEN off (0.00/0/0)
tcp 0 0 2024::57:1521 :::* LISTEN off (0.00/0/0)