改实例名:
步骤
1.改环境 ORACLE_SID=s254
2.mv 参数文件 密码文件
windows改环境的方法(原名ora9i 新名s9i9i)
注册表 HKEY_LOCAL_MACHINE=>SOFTWARE=>ORACLE=>HOME0=>oracle_sid
命令行里修改windows服务名称
C:\>oradim -delete -sid ora9i
C:\>oradim -new -sid s9i9i
C:\>sqlplus /nolog
SQL*Plus: Release 9.0.1.0.1 - Production on 星期四 4月 14 11:17:26 2011
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\ORACLE\ORA90\DATABASE\INITS9I9I.ORA'
SQL>
9I使用IFILE 去除IFILE 把instance_name值注释
D:\>cd D:\oracle\ora90\database\
D:\>ren initora9i.ora inits9i9i.ora
D:\oracle\ora90\database>ls
OraDim.Log PWDora9i.ora SPFILEORA9I.ORA archive inits9i9i.ora oradba.exe
D:\oracle\ora90\database>ren PWDora9i.ora PWDs9i9i.ora
D:\oracle\ora90\database>rm SPFILEORA9I.ORA
linux
改 ORACLE_SID 变量
改名参数文件和密码文件
修改数据库名 db_name
1.修改pfile中的db_name=ora10g 改为db_name=beijing
2.重新启动数据库 出错
idle> startup
ORACLE instance started.
Total System Global Area 230686720 bytes
Fixed Size 1218676 bytes
Variable Size 75499404 bytes
Database Buffers 150994944 bytes
Redo Buffers 2973696 bytes
ORA-01103: database name 'ORA10G' in control file is not 'BEIJING'
idle> select status from v$instance;
STATUS
----------
STARTED
idle> 说明数据库名不仅仅在参数文件里 控制文件也包含 所以要重建控制文件 因为是二进制的 不能编辑
3.正常关闭数据库 重建控制文件 创建前先把原来的控制文件删除 已存在不能创建
idle> create controlfile reuse database ora10g set database beijing resetlogs
maxinstances 8
maxloghistory 1
maxlogfiles 16
maxlogmembers 3
maxdatafiles 100
datafile
'/u01/oracle/oradata/ora10g/system01.dbf',
'/u01/oracle/oradata/ora10g/undotbs01.dbf',
'/u01/oracle/oradata/ora10g/sysaux01.dbf'
logfile
group 1 '/u01/oracle/oradata/ora10g/redo01.log' size 50M,
group 2 '/u01/oracle/oradata/ora10g/redo02.log' size 50M,
group 3 '/u01/oracle/oradata/ora10g/redo03.log' size 50M
character set AL32UTF8
/
Control file created.
idle> select status from v$instance;
STATUS
----------
MOUNTED
4. 启动数据库 需要使用resetlogs模式重置联机日志文件
idle> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
idle> alter database open resetlogs;
Database altered.
idle> select status from v$instance;
STATUS
----------
OPEN
idle> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string beijing
db_unique_name string beijing
global_names boolean FALSE
instance_name string ora10g
lock_name_space string
log_file_name_convert string
service_names string beijing
idle>
修改实例名 instance_name
1.先正常停掉原来的库 使数据库是一致的
idle> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
idle>
2.修改操作系统和实例关联的信息 ORACLE_SID
以及根据ORACLE_SID参数去寻找的参数文件名和口令文件名
[oracle@seker ~]$ mv $ORACLE_HOME/dbs/orapwora10g $ORACLE_HOME/dbs/orapwbeijing
[oracle@seker ~]$ mv $ORACLE_HOME/dbs/initora10g.ora $ORACLE_HOME/dbs/initbeijing.ora
[oracle@seker ~]$ export ORACLE_SID=beijing
[oracle@seker ~]$ sql /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 22 01:15:22 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
idle> conn / as sysdba
Connected to an idle instance.
idle> startup
ORACLE instance started.
Total System Global Area 230686720 bytes
Fixed Size 1218676 bytes
Variable Size 75499404 bytes
Database Buffers 150994944 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
idle> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string beijing
db_unique_name string beijing
global_names boolean FALSE
instance_name string beijing
lock_name_space string
log_file_name_convert string
service_names string beijing
idle>
修改 /etc/oratab 中的数据库名
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756465/viewspace-717776/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756465/viewspace-717776/