1、Oracle数据库移植1. 安装oracle9.2(具体见图)2. 更改oracle数据库文件夹中的def_ORACLE.ora文件,路径指向orcl的路径3. 停止orcl服务,shutdown数据库orcl4. sqlplus下由def_ORACLE.ora文件生成D:oracleora92databaseSPFILEORCL.ORA文件5. cmd下重新创建口令文件6. 重新启动orcl服务C:Documents and Settingsyqxsqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:19
2、:02 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL conn sys/sysmv9i as sysdba;已连接。SQL shutdown immediateORA-01109: ?已经卸载数据库。ORACLE 例程已经关闭。SQL startupORACLE 例程已经启动。Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 2
3、5165824 bytesRedo Buffers 667648 bytesORA-01991: ?D:oracleora92DATABASEPWDmv9i.ORASQL exit从Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production中断开C:Documents and Settingsyqxorapwd /?Usage: orapwd fi
4、le= password= entries= where file - name of password file (mand), password - password for SYS (mand), entries - maximum number of distinct DBA and OPERs (opt), There are no spaces around the equal-to (=) character.C:Documents and Settingsyqxorapwd file=d:oracleoradatamv9imv9i.ora password=sys entrie
5、s=10C:Documents and Settingsyqxsqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on 星期五 4月 23 18:21:28 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL startupORA-01031: insufficient privilegesSQL conn sys/sysmv9i as sysdba;已连接。SQL startupORA-01081: ? ORACLE - ?SQL shut
6、down immediateORA-01109: ?已经卸载数据库。ORACLE 例程已经关闭。SQL startupORACLE 例程已经启动。Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytesORA-01991: ?D:oracleora92DATABASEPWDmv9i.ORASQL exit从Oracle9i Enterprise Editio
7、n Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production中断开停止服务 口令修改C:Documents and Settingsyqxorapwd file=d:oracleora92databasepwdorcl8j.ora password=sys entries=10C:Documents and Settingsyqxsqlplus /nologSQL*Plus: Release 9.2.
8、0.1.0 - Production on 星期五 4月 23 18:23:24 2010Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL conn sys/sysmv9i as sysdba;已连接。SQL startupORA-01081: ? ORACLE - ?SQL shutdown immediateORA-01109: ?已经卸载数据库。ORACLE 例程已经关闭。SQL startupORACLE 例程已经启动。Total System Global Area 135338868 bytesFixed Size 453492 bytesVariable Size 109051904 bytesDatabase Buffers 25165824 bytesRedo Buffers 667648 bytes数据库装载完毕。数据库已经打开。SQL A两处修改字符集HKEY_LOCAL_MACHINESOFTWAREORACLENLS_LANG=AMERICAN_AMERICA.US7ASCIIHKEY_LOCAL_MACHINESOFTWAREORACLEHOME0NLS_LANG=AMERICAN_AMERICA.US7ASCIIAMERICAN_AMERICA.US7ASCII