修改Oracle 10G数据库名和DBID - 数据库编程

cel;

ORA-00279: change 9094358 generated at 07/15/2011 15:32:20 needed for thread 1

ORA-00289: suggestion :

/u01/app/flash_recovery_area/ORCL/archivelog/2011_07_15/o1_mf_1_3_%u_.arc

ORA-00280: change 9094358 for thread 1 is in sequence #3

Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log

'/u01/app/flash_recovery_area/ORCL/archivelog/2011_07_15/o1_mf_1_3_%u_.arc'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 9094358 generated at 07/15/2011 15:32:20 needed for thread 1

ORA-00289: suggestion :

/u01/app/flash_recovery_area/ORCL/archivelog/2011_07_15/o1_mf_1_3_%u_.arc

ORA-00280: change 9094358 for thread 1 is in sequence #3

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

Media recovery cancelled.

SQL> alter database open resetlogs;

Database altered.

SQL> select dbid,name from v$database;

DBID NAME

---------- ---------------------------

4061806388 ORCL

1.5 修改ORACLE_SID,tnsnames.ora和dbconsole配置

[oracle@rhel6 ~]$ source .bash_profile

[oracle@rhel6 ~]$ env |grep ORACLE_SID

ORACLE_SID=orcl

[oracle@rhel6 ~]$ vi /u01/app/oracle/network/admin/tnsnames.ora

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.4)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.766.com)

)

重新配置dbconsole，需要借助DBCA工具

[root@rhel6 ~]# tail -n 1 /etc/oratab

orcl:/u01/app/oracle:N:

[oracle@rhel6 ~]$ emctl status dbconsole

TZ set to PRC

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

http://rhel6.766.com:5500/em/console/aboutApplication

Oracle Enterprise Manager 10g is running.

------------------------------------------------------------------

Logs are generated in directory /u01/app/oracle/rhel6.766.com_orcl/sysman/log

[oracle@rhel6 ~]$ netstat -ntpl |grep :5500

(Not all processes could be identified, non-owned process info

will not be shown, you would have to be root to see it all.)

tcp 0 0 0.0.0.0:5500 0.0.0.0:* LISTEN 13819/ java

修改Oracle 10G数据库名和DBID(二)