移动-AIX营账数据库安装报告oracleracv40-internal

广东移动BOSS1.5项目工程文档

? 选择是归档模式及快速恢复区：非归档模式，不设定恢复区

? 设定数据库基本属性： 字符集：ZHS16GBK 国家字符集：AL16UTF16 数据块大小：8K

连接模式：专用服务器 参数文件类型：文本类型

49

广东移动BOSS1.5项目工程文档

? 开始数据库建立

50

广东移动BOSS1.5项目工程文档

7.2 建立必要的用户表空间

创建脚本见《营账测试数据库表空间创建脚本》。

8 状态检测

8.1 版本信息

SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS ---------------------------------------- -------------- Oracle Workspace Manager 10.2.0.1.0 VALID Oracle Enterprise Manager 10.2.0.2.0 VALID Oracle Database Catalog Views 10.2.0.2.0 VALID Oracle Database Packages and Types 10.2.0.2.0 VALID Oracle Real Application Clusters 10.2.0.2.0 VALID

8.2 CRS进程状态

$ bin/crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy

51

广东移动BOSS1.5项目工程文档

8.3 服务状态

8.4 $ bin/crs_stat -t

Name Type Target State Host ------------------------------------------------------------ ora....B1.inst application ONLINE ONLINE s3_c...zsjk ora....B2.inst application ONLINE ONLINE s4_c...zsjk ora.SZDB.db application ONLINE ONLINE s3_c...zsjk ora....JK.lsnr application ONLINE ONLINE s3_c...zsjk ora....sjk.gsd application ONLINE OFFLINE ora....sjk.ons application ONLINE ONLINE s3_c...zsjk ora....sjk.vip application ONLINE ONLINE s3_c...zsjk ora....JK.lsnr application ONLINE ONLINE s4_c...zsjk ora....sjk.gsd application ONLINE OFFLINE ora....sjk.ons application ONLINE ONLINE s4_c...zsjk ora....sjk.vip application ONLINE ONLINE s4_c...zsjk

实例运行状态

$ srvctl status database -d SZDB

Instance SZDB1 is running on node s3_c_yz_yzsjk Instance SZDB2 is not running on node s4_c_yz_yzsjk

SQL> SELECT inst_id, instance_number inst_no,instance_name inst_name, 2 Parallel status, database_status db_status, active_state

3 host_name host FROM gv$instance ORDER BY inst_id; INST_ID INST_NO INST_NAME STA DB_STATUS STATE HOST ---------- ---------- ----------- --- ---------- ---------

1 1 SZDB1 YES ACTIVE NORMAL S3_C_YZ_YZSJK 2 2 SZDB2 YES ACTIVE NORMAL S4_C_YZ_YZSJK

SQL> select

NAME,LOG_MODE,OPEN_MODE,DATABASE_ROLE,FORCE_LOGGING,FLASHBACK_ON from v$database;

NAME LOG_MODE OPEN_MODE DATABASE_ROLE FOR FLASHBACK_ON --------- ------------ ---------- ---------------- --- SZDB NOARCHIVELOG READ WRITE PRIMARY NO NO

52