20160718数据库迁移10g rac 迁移到11g rac
10g 字符集ZHS32GB18030
11g dbca建库没有该字符集选项
是用dbca设置创建脚本更改CreateDB.sql 的字符集AL32UTF8 改为ZHS32GB18030 在1节点执行脚本
oracle:testmach1:/tmp/script:>ls -l
total 152
-rw-r----- 1 oracle oinstall 189 Jul 18 14:25 CreateClustDBViews.sql
-rw-r----- 1 oracle oinstall 1062 Jul 18 14:29 CreateDB.sql
-rw-r----- 1 oracle oinstall 712 Jul 18 14:25 CreateDBCatalog.sql
-rw-r----- 1 oracle oinstall 433 Jul 18 14:25 CreateDBFiles.sql
-rw-r----- 1 oracle oinstall 421 Jul 18 14:25 JServer.sql
-rw-r----- 1 oracle oinstall 212 Jul 18 14:25 apex.sql
-rw-r----- 1 oracle oinstall 325 Jul 18 14:25 context.sql
-rw-r----- 1 oracle oinstall 185 Jul 18 14:25 cwmlite.sql
-rw-r----- 1 oracle oinstall 280 Jul 18 14:25 emRepository.sql
-rw-r----- 1 oracle oinstall 1750 Jul 18 14:25 init.ora
-rw-r----- 1 oracle oinstall 180 Jul 18 14:25 interMedia.sql
-rw-r----- 1 oracle oinstall 485 Jul 18 14:25 lockAccount.sql
-rw-r----- 1 oracle oinstall 189 Jul 18 14:25 ordinst.sql
-rw-r----- 1 oracle oinstall 190 Jul 18 14:25 owb.sql
-rw-r----- 1 oracle oinstall 1040 Jul 18 14:25 postDBCreation.sql
-rw-r----- 1 oracle oinstall 173 Jul 18 14:25 spatial.sql
-rwxr-xr-x 1 oracle oinstall 525 Jul 18 14:25 test1.sh
-rwxr-xr-x 1 oracle oinstall 1352 Jul 18 14:25 test1.sql
-rw-r----- 1 oracle oinstall 377 Jul 18 14:25 xdb_protocol.sql
oracle:testmach1:/tmp/script:>sh test1.sh
###脚本完成后2节点启动报错
[root@testmach2 /]#crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE testmach1
ONLINE ONLINE testmach2
ora.LISTENER.lsnr
ONLINE ONLINE testmach1
ONLINE ONLINE testmach2
ora.OCR.dg
ONLINE ONLINE testmach1
ONLINE ONLINE testmach2
ora.asm
ONLINE ONLINE testmach1 Started
ONLINE ONLINE testmach2 Started
ora.net1.network
ONLINE ONLINE testmach1
ONLINE ONLINE testmach2
ora.ons
ONLINE ONLINE testmach1
ONLINE ONLINE testmach2
ora.registry.acfs
ONLINE ONLINE testmach1
ONLINE ONLINE testmach2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE testmach1
ora.cvu
1 ONLINE ONLINE testmach1
ora.oc4j
1 ONLINE ONLINE testmach1
ora.scan1.vip
1 ONLINE ONLINE testmach1
ora.test.db
1 ONLINE ONLINE testmach1 Open
2 ONLINE INTERMEDIATE testmach2 Dismounted
ora.testmach1.vip
1 ONLINE ONLINE testmach1
ora.testmach2.vip
1 ONLINE ONLINE testmach2
[root@testmach2 /]#su - oracle
[YOU HAVE NEW MAIL]
oracle:testmach2:/home/oracle:>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 19 06:35:49 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
Enter user-name:
###对照1节点审计目录创建节点2的审计目录
#!/bin/sh
OLD_UMASK=`umask`
umask 0027
mkdir -p /u01/app/oracle/admin/test/adump
mkdir -p /u01/app/oracle/admin/test/dpdump
mkdir -p /u01/app/oracle/admin/test/hdump
mkdir -p /u01/app/oracle/admin/test/pfile
mkdir -p /u01/app/oracle/cfgtoollogs/dbca/test
umask ${OLD_UMASK}
###启动2节点数据库
总结:此方法可以作为裸设备创建数据库的参考
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26179376/viewspace-2122173/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26179376/viewspace-2122173/