السلام عليكم اخواني الأعزاء

قمت بتغيير اسم DATABASE فقط بالشكل الاتي :

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\a.nagah>cd\

C:\>
C:\>
C:\>SQLPLUS / AS SYSDBA

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 13 12:30:15 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>
SQL>
SQL>
SQL> SELECT NAME FROM V$DATABASE;

NAME
---------
ORCL

SQL>
SQL>
SQL>
SQL> SHOW PARAMETER USER_DUMP_DEST

NAME								 TYPE		VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest					   string	  D:\ORACLE\PRODUCT\10.2.0\ADMIN
											 \ORCL\UDUMP
SQL>
SQL>
SQL>
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Database altered.

SQL>
SQL>
SQL>
SQL> CREATE PFILE='C:\NAGAHPFILE.TXT' FROM SPFILE;

File created.

SQL>
SQL>
SQL>
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL> -- EDIT THE GENERATED PFILE ( C:\NAGAHPFILE.TXT )
SQL>
SQL> -- CHANGE THE DB_NAME PARAMETER TO POINT TO THE NEW NAME ( NAGAHDB )
SQL>
SQL>
SQL>
SQL> STARTUP PFILE='C:\NAGAHPFILE.TXT' NOMOUNT;
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size				  1250428 bytes
Variable Size			 176163716 bytes
Database Buffers		  427819008 bytes
Redo Buffers				7135232 bytes
SQL>
SQL>
SQL>
SQL> -- REMOVE OLD CONTROL FILES & ONLINE REDO LOG FILES
SQL>
SQL> -- FROM THE GENERATED TRACE FILE
SQL>
SQL> -- EXTRACT THE CREATE CONTROLFILE STATEMENT
SQL>
SQL> --------------------------------------------------------------
SQL> -- CHANGE
SQL>
SQL> -- FROM : ( CREATE CONTROLFILE REUSE DATABASE "ORCL"  NORESETLOGS  NOARCHIVELOG )
SQL>
SQL> -- TO   : ( CREATE CONTROLFILE SET DATABASE "NAGAHDB"   RESETLOGS  NOARCHIVELOG )
SQL>
SQL> --------------------------------------------------------------
SQL>
SQL> -- EXECUTE THE EDITED STATEMENT
SQL>
SQL>
SQL>
SQL> CREATE CONTROLFILE SET DATABASE "NAGAHDB" RESETLOGS  NOARCHIVELOG
 2	  MAXLOGFILES 16
 3	  MAXLOGMEMBERS 3
 4	  MAXDATAFILES 100
 5	  MAXINSTANCES 8
 6	  MAXLOGHISTORY 292
 7  LOGFILE
 8	GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'  SIZE 50M,
 9	GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'  SIZE 50M,
10	GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'  SIZE 50M
11  -- STANDBY LOGFILE
12  DATAFILE
13	'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF',
14	'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF',
15	'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF',
16	'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF',
17	'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF'
18  CHARACTER SET AL32UTF8
19 ;

Control file created.

SQL>
SQL>
SQL>
SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>
SQL>
SQL>
SQL> SELECT NAME FROM V$DATABASE;

NAME
---------
NAGAHDB

SQL>
SQL>
SQL>
SQL> EXIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

C:\>
C:\>
C:\>
C:\>

و لعمل SERVER PARAMETER FILE تتم منه عملية الإقلاع اوتوماتيكيا :

SQL>
SQL>
SQL> CREATE SPFILE FROM PFILE='C:\NAGAHPFILE.TXT';

File created.

SQL>
SQL>

الف شكر على المعلومات الرائعه...

موضوع جميل جداً ومسرد بطريقه رائعه
شكراً لك يا اخي

السلام عليكم ورحمة الله وبركاته

جزاك الله ألف خير موضوع رائع بس حبيت أضيف على الموضوع هناك طريقه أخرى في أوركل 9.2 عن طريق DBNEWID utility

http://www.oracle.com/technology/obe/paa/o..._db_name.htm#b2