![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 87
qq_42048263
逆水行舟不进则退
展开
-
Oracle手工创建数据库方法和步骤
1、设置ORACLE_SID2、设置ORACL_HOME等环境变量信息3、创建初始化参数文件[oracle@test dbs]$ cat initmydb.oraDB_NAME=mydbDB_BLOCK_SIZE=8192CONTROL_FILES=/opt/oradata/mydb/control01.ora,/opt/oradata/mydb/control02.oraUNDO_TABLESPACE=undotbsUNDO_MANAGEMENT=AUTOSGA_TARGET=1G原创 2021-04-21 17:22:43 · 565 阅读 · 0 评论 -
使用命令脚本创建ORACLE数据库报dba相关表不存在
使用参数文件内容如下:~~~~~~~~~~~~~~~~~~~~~initprod.ora内容如下~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~############################################################################### Copyright (c) 1991, 2001, 2002 by Oracle Corporation##############################原创 2021-04-21 15:02:34 · 1296 阅读 · 1 评论 -
RAC添加修改SCAN
查看scan的配置信息[root@racnode1 ~]# srvctl config scanSCAN name: racscan, Network: 1/192.168.100.0/255.255.255.0/ens192SCAN VIP name: scan1, IP: /racscan/192.168.100.163查看scan的状态及scanip所处的节点[root@...原创 2019-12-16 22:30:30 · 277 阅读 · 0 评论 -
RAC 集群的启动关闭及检查
关闭集群所有节点[root@racnode1 ~]# crsctl stop cluster -allCRS-2673: Attempting to stop 'ora.crsd' on 'racnode2'CRS-2673: Attempting to stop 'ora.crsd' on 'racnode1'CRS-2790: Starting shutdown of Cluster...原创 2019-12-16 21:42:08 · 255 阅读 · 0 评论 -
停止所有CRS集群资源
[root@racnode1 ~]# crsctl stop resource -allCRS-2500: Cannot stop resource 'ora.gsd' as it is not runningCRS-2673: Attempting to stop 'ora.DATA.dg' on 'racnode1'CRS-2673: Attempting to stop 'ora...原创 2019-12-14 21:29:04 · 1000 阅读 · 0 评论 -
执行rootcrs.pl重新配置GI报错
[root@racnode2 ~]# /u01/app/11.2.0.4/grid_home/crs/install/rootcrs.pl -verbose -deconfig -forceCan't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/per...原创 2019-12-13 13:24:59 · 1017 阅读 · 0 评论 -
搭建Oracle RAC并且使用ASM报diskgroup cannot be created
[root@racnode1 ~]# /u01/app/11.2.0.4/grid_home/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/...原创 2019-12-12 20:14:29 · 801 阅读 · 0 评论 -
RAC安装预检查
[grid@racnode1 grid]$ ./runcluvfy.sh stage -pre crsinst -n racnode1,racnode2 -verbosePerforming pre-checks for cluster services setupChecking node reachability...Check: Node reachability from no...原创 2019-12-12 08:13:26 · 934 阅读 · 1 评论