NBU测试记录.docxVIP

1、修改oraparam.ini文件到install目录中找到oraparam.ini文件，添加如下内容：[Certified Versions] #You can customise error message shown for failure, provide value forCERTIFIED_VERSION_FAILURE_MESSAGE #Windows=5.0,5.1,5.2,6.0 #这里前面部分内容有的，只添加6.02、$ORACLE_BASE\admin\orcl\bdump\alter_实例名；排错日志；$ORACLE_HOME: C:\oracle\product\10.2.0\db_1$ORACLE_BASE:C:\oracle\product\10.2.0C:\Users\AdministratorsqlplusC:\Users\AdministratornetcaOracle Net Services 配置:正在配置监听程序:LISTENER默认本地命名配置完成。监听程序配置完成。Oracle Net 监听程序启动:正在运行监听程序控制: C:\oracle\product\10.2.0\db_1\bin\lsnrctl start LISTENER监听程序控制完成。监听程序已成功启动。正在设置监听程序服务以便自动启动。成功完成 Oracle Net Services 配置。退出代码是0C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\监听的配置文件：listener.ora监听端口：默认1521tnsnames.oratnspingC:\Users\Administratorsqlplus sys/oracle@orcl as sysdba网络方式登录；SQL*Plus: Release .0 - Production on Fri May 10 09:39:28 2013Copyright (c) 1982, 2007, Oracle. All Rights Reserved.ERROR:ORA-12154: TNS:could not resolve the connect identifier specifiedEnter user-name:C:\Users\Administratornetca //dbca配置数据库Oracle Net Services 配置:默认本地命名配置完成。已创建的 Net 服务名: orcl成功完成 Oracle Net Services 配置。退出代码是0C:\Users\Administratortnsping orclTNS Ping Utility for 64-bit Windows: Version .0 - Production on 10-MAY-2013 09:40:53Copyright (c) 1997, 2007, Oracle. All rights reserved.Used parameter files:C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 23)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))OK (0 msec)C:\Users\Administratorsqlplus sys/oracle@orcl as sysdbaSQL*Plus: Release .0 - Production on Fri May 10 09:41:31 2013Copyright (c) 1982, 2007, Oracle. All Rights Reserved.???:Oracle Database 10g Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL select status from v$instance;STATUS------------OPENSQL select open_mode from v$database;OPEN_MODE----------REA