Oracle rac 修改SCAN IP

简介: Oracle rac 修改SCAN IP

修改SCAN主机名、端口号、增加scan ip的个数

在集群正常运行的情况下,首先修改所有节点/etc/hosts文件后,再执行如下命令,其中raclhr-scan是修改后的SCAN主机名:

srvctl config scan
srvctl stop scan_listener
srvctl stop scan
srvctl modify scan -n raclhr-scan
srvctl config scan
srvctl start scan
srvctl start scan_listener

如果SCAN IP的个数改变了,那么还需要执行如下命令进行更新:

srvctl modify scan_listener -u

需要注意的是,以上步骤也适用于修改SCAN的IP地址或增加SCAN IP的个数。

修改SCAN的端口号的命令如下所示:

srvctl modify scan_listener -p 1522

示例:增加scan ip个数

对新配置的oracle RAC环境增配2个SCAN IP地址,192.168.59.175以及192.168.59.176。

配置前信息

默认情况下配置RA 只有1个scan IP,1个 scan listener。

查看scan的配置信息

[root@raclhr-11gR2-N1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
#Public IP
192.168.59.170            raclhr-11gR2-N1
192.168.59.171            raclhr-11gR2-N2
#Private IP
192.168.2.110             raclhr-11gR2-N1-priv
192.168.2.111             raclhr-11gR2-N2-priv
#Virtual IP
192.168.59.172            raclhr-11gR2-N1-vip
192.168.59.173            raclhr-11gR2-N2-vip
#Scan IP
192.168.59.174            raclhr-11gR2-scan

[root@raclhr-11gR2-N1 ~]# srvctl config scan
SCAN name: raclhr-11gR2-scan, Network: 1/192.168.59.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /raclhr-11gR2-scan/192.168.59.174

查看scan的状态以及scan ip所处节点

[root@raclhr-11gR2-N1 ~]# srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node raclhr-11gr2-n2

[root@raclhr-11gR2-N1 ~]#

查看scan listener

[root@raclhr-11gR2-N1 ~]# srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

[root@raclhr-11gR2-N1 ~]#

修改rac所有节点的/etc/hosts信息

[root@raclhr-11gR2-N1 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
#Public IP
192.168.59.170            raclhr-11gR2-N1
192.168.59.171            raclhr-11gR2-N2
#Private IP
192.168.2.110             raclhr-11gR2-N1-priv
192.168.2.111             raclhr-11gR2-N2-priv
#Virtual IP
192.168.59.172            raclhr-11gR2-N1-vip
192.168.59.173            raclhr-11gR2-N2-vip
#Scan IP
192.168.59.174            raclhr-11gR2-scan 
192.168.59.175            raclhr-11gR2-scan ----->>>>新增的SCAN IP
192.168.59.176            raclhr-11gR2-scan ----->>>>新增的SCAN IP

停止scan 监听,注意先停监听才能停scan


srvctl stop scan_listener

srvctl stop scan

srvctl status scan_listener

srvctl status scan

配置scan,注意需要用root权限执行

修改scan信息,-n 后面接 hosts中的san ip 网络名:

[root@raclhr-11gR2-N1 ~]# srvctl modify scan -h

 

Modifies the SCAN name.

 

Usage: srvctl modify scan -n

    -n            Domain name qualified SCAN name

    -h                       Print usage

[root@raclhr-11gR2-N1 ~]#

[root@raclhr-11gR2-N1 ~]# srvctl modify scan -n raclhr-11gR2-scan

添加scanIP的监听,若不执行该命令srvctl modify scan_listener -u,将只有一个listener_scan1监听,执行后将根据scan ip数自动增加listener_scan2,listener_scan3.

[root@raclhr-11gR2-N1 ~]# srvctl modify scan_listener -h
Modifies the SCAN listeners so that the number of SCAN listeners is the same as the number of SCAN VIPs or modifies the SCAN listener endpoints.
Usage: srvctl modify scan_listener {-u|-p [TCP:][/IPC:][/NMP:][/TCPS:] [/SDP:]}
    -u                       Update SCAN listeners to match the number of SCAN VIPs
    -p [TCP:][/IPC:][/NMP:][/TCPS:] [/SDP:]           SCAN Listener endpoints
    -h                       Print usage
[root@raclhr-11gR2-N1 ~]# srvctl modify scan_listener -u
[root@raclhr-11gR2-N1 ~]#
[root@raclhr-11gR2-N1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
........
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        OFFLINE OFFLINE                                                   
ora.LISTENER_SCAN2.lsnr
      1        OFFLINE OFFLINE                                                  
ora.LISTENER_SCAN3.lsnr
      1        OFFLINE OFFLINE                                                  
ora.cvu
      1        ONLINE  ONLINE       raclhr-11gr2-n1                             
ora.lhrrac1.db
      1        ONLINE  ONLINE       raclhr-11gr2-n1          Open               
      2        ONLINE  ONLINE       raclhr-11gr2-n2          Open                
ora.oc4j
      1        ONLINE  ONLINE       raclhr-11gr2-n1                             
ora.raclhr-11gr2-n1.vip
      1        ONLINE  ONLINE       raclhr-11gr2-n1                             
ora.raclhr-11gr2-n2.vip
      1        ONLINE  ONLINE       raclhr-11gr2-n2                             
ora.scan1.vip
      1        OFFLINE OFFLINE                                                  
ora.scan2.vip
      1        OFFLINE OFFLINE                                                  
ora.scan3.vip
      1        OFFLINE OFFLINE       

启动scan

srvctl start scan
srvctl start scan_listener
srvctl status scan
srvctl status scan_listener
srvctl config scan

示例:

[root@raclhr-11gR2-N1 ~]# srvctl start scan
[root@raclhr-11gR2-N1 ~]# srvctl start scan_listener
[root@raclhr-11gR2-N1 ~]# srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node raclhr-11gr2-n2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node raclhr-11gr2-n1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node raclhr-11gr2-n1
[root@raclhr-11gR2-N1 ~]# srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node raclhr-11gr2-n2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node raclhr-11gr2-n1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node raclhr-11gr2-n1
[root@raclhr-11gR2-N1 ~]#
[root@raclhr-11gR2-N1 ~]# srvctl config scan
SCAN name: raclhr-11gR2-scan, Network: 1/192.168.59.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /raclhr-11gR2-scan/192.168.59.174
SCAN VIP name: scan2, IP: /raclhr-11gR2-scan/192.168.59.175
SCAN VIP name: scan3, IP: /raclhr-11gR2-scan/192.168.59.176
[root@raclhr-11gR2-N1 ~]#

查看SCAN1和SCAN2的内容

重启集群环境后,可以看到如下内容:

[root@raclhr-11gR2-N1 admin]# lsnrctl status listener_scan3
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-JUN-2018 15:24:13
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN3
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                05-JUN-2018 15:18:55
Uptime                    0 days 0 hr. 5 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/raclhr-11gR2-N1/listener_scan3/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN3)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.176)(PORT=1521)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "lhrrac1" has 2 instance(s).
  Instance "lhrrac11", status READY, has 1 handler(s) for this service...
  Instance "lhrrac12", status READY, has 1 handler(s) for this service...
Service "lhrrac1XDB" has 2 instance(s).
  Instance "lhrrac11", status READY, has 1 handler(s) for this service...
  Instance "lhrrac12", status READY, has 1 handler(s) for this service...
Service "lhrxxt" has 2 instance(s).
  Instance "lhrrac11", status READY, has 1 handler(s) for this service...
  Instance "lhrrac12", status READY, has 1 handler(s) for this service...
The command completed successfully
[root@raclhr-11gR2-N1 admin]# lsnrctl status listener_scan2
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 05-JUN-2018 15:24:16
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SCAN2
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                05-JUN-2018 15:18:55
Uptime                    0 days 0 hr. 5 min. 21 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/raclhr-11gR2-N1/listener_scan2/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.175)(PORT=1521)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "lhrrac1" has 2 instance(s).
  Instance "lhrrac11", status READY, has 1 handler(s) for this service...
  Instance "lhrrac12", status READY, has 1 handler(s) for this service...
Service "lhrrac1XDB" has 2 instance(s).
  Instance "lhrrac11", status READY, has 1 handler(s) for this service...
  Instance "lhrrac12", status READY, has 1 handler(s) for this service...
Service "lhrxxt" has 2 instance(s).
  Instance "lhrrac11", status READY, has 1 handler(s) for this service...
  Instance "lhrrac12", status READY, has 1 handler(s) for this service...
The command completed successfully
[root@raclhr-11gR2-N1 admin]#

修改rac的默认端口号为1522

srvctl config listener
srvctl modify listener -p 1522
srvctl stop listener
srvctl start listener

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.7.83)(PORT=1522)))' sid='rac1';
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.7.84)(PORT=1522)))' sid='rac2';
alter system set remote_listener='rac-scan:1522' sid='*';
alter system register;

检查

ps -ef|grep tns
netstat -tulnp | grep 152
crsctl stat res -t

lsnrctl status 
lsnrctl status listener_scan

How to Update the IP Address of the SCAN VIP Resources (ora.scan{n}.vip) (文档 ID 952903.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

GOAL

The purpose of this document is to explain how to change the IP addresses associated with the VIPs in a 11gR2 Grid (CRS) environment.

The IP addresses associated with the SCAN VIP resources are initially set when the SCAN resources are created.
Any changes to the DNS entry for the SCAN are not automatically propagated to the clusterware and need to be done manually.

This applies only to installations that are not using .

The information in this note can also be helpful in cases where SCAN was originally configured with just one address and is now being expanded to accommodate three IP addresses.

SOLUTION

  1. Before the SCAN VIPs can be changed, the entry for the SCAN name on the Domain Name Server (DNS) needs to be updated with the new IP addresses. This usually will be done by a network administrator. To check the current setting, the following command can be used:

    nslookup *<scan_name>*

  2. To check the current IP address(es) of the SCAN VIPs, run the following commands as the root user:

    $GRID_HOME/bin/srvctl config scan

  3. Stop the SCAN listeners and SCAN

    $GRID_HOME/bin/srvctl stop scan_listener
    $GRID_HOME/bin/srvctl stop scan

  4. Next refresh the SCAN VIPs with the new IP addresses from the DNS entry:

    $GRID_HOME/bin/srvctl modify scan -n *<scan_name*

  5. To check if the SCAN VIPs have been changed, run the following command, it should now show the new IP addresses.

    $GRID_HOME/bin/srvctl config scan

  6. Restart SCAN & SCAN listener:

    $GRID_HOME/bin/srvctl start scan
    $GRID_HOME/bin/srvctl start scan_listener

  7. If the number of SCAN VIPs has changed, the SCAN listener needs to be updated:

    $GRID_HOME/bin/srvctl modify scan_listener -u

Below is an example using the following configuration:

  • The name of the SCAN is sales-scan.example.com
  • subnet of the public network is 10.100.10.0
  • netmask for the public network is 255.255.255.0
  • name of the public interface is eth1
  • old IP addresses: 10.100.10.81, 10.100.10.82 & 10.100.10.83
  • new IP addresses: 10.100.10.121, 10.100.10.122 & 10.100.10.123

Stopping & starting the SCAN VIPs/listeners can be done by the grid user, however the 'srvctl modify scan' command must be executed by root user, so it's practical to execute all steps as the root user.

A lookup of the SCAN on the DNS server shows that the entry has already been updated with the new IP addresses:

$ nslookup sales-scan.example.com
Server: dns1.example.com
Address: 10.100.10.70#53

Name: sales-scan.example.com
Address: 10.100.10.123
Name: sales-scan.example.com
Address: 10.100.10.122
Name: sales-scan.example.com
Address: 10.100.10.121

Stop the SCAN listener and the SCAN VIP resources:

\# $GRID_HOME/bin/srvctl stop scan_listener
\# $GRID_HOME/bin/srvctl stop scan
\# $GRID_HOME/bin/srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
SCAN VIP scan2 is enabled
SCAN VIP scan2 is not running
SCAN VIP scan3 is enabled
SCAN VIP scan3 is not running
\# $GRID_HOME/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is not running
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is not running

The SCAN VIP resources still show the old IP addresses:

\# $GRID_HOME/bin/srvctl config scan
SCAN name: sales-scan, Network: 1/10.100.10.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /sales-scan.example.com/10.100.10.81
SCAN VIP name: scan2, IP: /sales-scan.example.com/10.100.10.82
SCAN VIP name: scan3, IP: /sales-scan.example.com/10.100.10.83

Now tell CRS to update the SCAN VIP resources:

\# $GRID_HOME/bin/srvctl modify scan -n sales-scan.example.com

To verify that the change was successful, check the SCAN configuration again:

\# $GRID_HOME/bin/srvctl config scan
SCAN name: sales-scan, Network: 1/10.100.10.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /sales-scan.example.com/10.100.10.121
SCAN VIP name: scan2, IP: /sales-scan.example.com/10.100.10.122
SCAN VIP name: scan3, IP: /sales-scan.example.com/10.100.10.123

Start SCAN and the SCAN listener:

\# $GRID_HOME/bin/srvctl start scan
\# $GRID_HOME/bin/srvctl start scan_listener

Please note that if the SCAN VIPs are being changed because of a change of the subnet of the public network additional changes may be required , e.g. the node VIPs and the network resource For more information please refer to Document 276434.1 and the 11.2 documentation.



How to Modify SCAN Setting or SCAN Listener Port after Installation (文档 ID 972500.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

GOAL

This note provides steps to update 11gR2 Grid Infrastructure (CRS) Single Client Access Name (SCAN) setting or SCAN listener port setting if it's not setup properly or if it's changed after setup.

Note:

  1. This procedure does not apply when GNS is being used
  2. Even though clustername and SCAN name is set to the same during 'typical' installation, changing SCAN name will not affect clustername as change of clustername requires deconfigure and reconfigure of the entire cluster.

SOLUTION

A. To update SCAN setting

  1. As per documentation "Oracle Grid Infrastructure Installation Guide", Oracle strongly recommend to configure SCAN name in either DNS or GNS as /etc/hosts file can only resolve to one IP address.

SCAN IP must be in same subnet as public and VIP. If the new SCAN IP will be in different subnet, refer to note 276434.1 to change nodeapps/network resource first.

1a. If you intend to use /etc/hosts for SCAN name resolution, the same and only entry for SCAN name must exist on all nodes.

1b. If you intend to use DNS for SCAN name resolution, remove entries for SCAN name from /etc/hosts on all nodes, and make sure nslookup returns good result on all nodes, for example:

$ nslookup pay-scan.us.oracle.com
..
Name: pay-scan.us.oracle.com
Address: 10.4.0.201
Name: pay-scan.us.oracle.com
Address: 10.4.0.202
Name: pay-scan.us.oracle.com
Address: 10.4.0.203

\2. Once #1a or #1b is configured properly, execute the following to modify:

If name resolution for SCAN is being switched from local hosts file to DNS, be sure to remove SCAN name in local hosts file on all nodes prior to execute below commands.

2.1. To modify SCAN name or SCAN VIP addresses:

2.1.1. As grid user stop resources:

$ $GRID_HOME/bin/srvctl stop scan_listener
$ $GRID_HOME/bin/srvctl stop scan

2.1.2. As root user modify SCAN:

\# $GRID_HOME/bin/srvctl modify scan -n pay-scan.us.oracle.com

\### For 11.2.0.1 only, if you intend to change SCAN name, due to bug 9603829, execute the following:

\# $GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE="

\### Example:
\# $GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE=pay-scan.us.oracle.com"

Once SCAN name is changed, update database init.ora/spfile parameter remote_listener to the new one.

2.1.3. As grid user modify and start resources:

$ $GRID_HOME/bin/srvctl modify scan_listener -u
$ $GRID_HOME/bin/srvctl start scan_listener

2.1.4. To confirm the change

$ $GRID_HOME/bin/srvctl config scan
SCAN name: pay-scan.us.oracle.com, Network: 1/10.4.0.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /10.4.0.201/120.0.0.201
SCAN VIP name: scan2, IP: /10.4.0.202/120.0.0.202
SCAN VIP name: scan3, IP: /10.4.0.203/120.0.0.203

$ $GRID_HOME/bin/srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521

2.2. To change SCAN to be on second network:

By default, SCAN will be configured on first public network (ora.net1.network), however in multiple public network environment, SCAN can run on second or other network.

There's no option to modify SCAN to use non-first network, to change to second or other network, scan_listener and scan resources need to be removed and added back.

In this example, we'll move SCAN from net1 to net2

$ $GRID_HOME/bin/srvctl config network
Network exists: 1/10.1.0.0/255.255.255.128/eth3, type static
Network exists: 2/10.1.1.0/255.255.255.128/eth4, type static

2.2.1. As grid user stop resources and remove scan_listener:

$ $GRID_HOME/bin/srvctl stop scan_listener$ $GRID_HOME/bin/srvctl stop scan
$ $GRID_HOME/bin/srvctl remove scan_listener -f

2.2.2. As root user remove and add SCAN:

\# $GRID_HOME/bin/srvctl remove scan -f
\#$GRID_HOME/bin/srvctl add scan -n -k 2

Once SCAN name is changed, update database init.ora/spfile parameter remote_listener to the new one.

2.2.3. As grid user add scan_listener and start resources:

$ $GRID_HOME/bin/srvctl add scan_listener-p
$ $GRID_HOME/bin/srvctl start scan_listener

B. To modify SCAN listener port

As grid user:

  1. Modify SCAN listener port:

$GRID_HOME/bin/srvctl modify scan_listener -p

Update 11gR2 database init.ora parameter: alter system set remote_listener=':' scope=both;

  1. Restart SCAN listener so the new port will be effective:

$GRID_HOME/bin/srvctl stop scan_listener
$GRID_HOME/bin/srvctl start scan_listener

  1. Confirm the change:

$GRID_HOME/bin/srvctl config scan_listener

REFERENCES

NOTE:975457.1 - How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name
NOTE:276434.1 - How to Modify Public Network Information including VIP in Oracle Clusterware
NOTE:887471.1 - PRVF-4664 PRVF-4657: Found inconsistent name resolution entries for SCAN name
NOTE:887522.1 - Grid Infrastructure Single Client Access Name (SCAN) Explained

NOTE:359277.1 - Changing Default Listener Port Number

总结

1、修改完rac的端口号后,一定记得要修改local_listener和remote_listener的值,且必须使用sid参数

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.7.83)(PORT=1522)))' sid='rac1';
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.7.84)(PORT=1522)))' sid='rac2';
alter system set remote_listener='rac-scan:1522' sid='*';
alter system register;
目录
相关文章
|
6月前
|
Oracle 关系型数据库 Java
云服务器安装oracle修改IP地址监听器报错问题
当在云服务器中安装oracle时,按照一般的安装步骤安装后,需要修改两个文件的iIP地址才可以在本机进行访问,修改注意点: 监听器部分不要改成服务器的公网IP,要改成服务器的计算机名字才可以,两个配置文件夹均要修改
58 0
|
5天前
|
Oracle 关系型数据库
oracle Hanganalyze no RAC
oracle Hanganalyze no RAC
11 0
|
13天前
|
Oracle 关系型数据库
Oracle查询优化-分解IP地址
【2月更文挑战第5天】【2月更文挑战第12篇】分解IP地址
19 8
|
28天前
|
Oracle 关系型数据库
oracle rac 手工安装补丁,不适用auto
oracle rac 手工安装补丁,不适用auto
16 3
|
5月前
|
Oracle 关系型数据库 Java
分享一个 Oracle RAC 模式下客户端建立JDBC初始连接时因ONS造成应用启动时卡顿30秒问题的排查分析案例
分享一个 Oracle RAC 模式下客户端建立JDBC初始连接时因ONS造成应用启动时卡顿30秒问题的排查分析案例
|
10月前
|
存储 Oracle 关系型数据库
|
存储 Oracle 关系型数据库
MySQL数据库: 添加列、修改列、删除列、修改列属性、修改表名(包括MySQL、SQLServer、Oracle)
MySQL数据库: 添加列、修改列、删除列、修改列属性、修改表名(包括MySQL、SQLServer、Oracle)
387 0
MySQL数据库: 添加列、修改列、删除列、修改列属性、修改表名(包括MySQL、SQLServer、Oracle)
|
文字识别 Oracle 关系型数据库
Oracle rac重新执行root.sh脚本
Oracle rac重新执行root.sh脚本
643 0
|
Oracle 关系型数据库 数据库管理
|
Oracle 关系型数据库 数据库管理