ORA-01504: Control File

[harrygulls]

I am able to connect to database.
I bring the database to NOMOUNT and then try to do the following thing.
I am trying to create the control file, but it's pointing towards AAAA. I have already made the change to init.ora file db_name = "BBBB".

Still I am getting this error.

HELP HELP

SQL> CREATE CONTROLFILE REUSE SET DATABASE BBBB RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 32
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 254
5 MAXINSTANCES 1
6 MAXLOGHISTORY 1809
7 LOGFILE
8 GROUP 1 'C:\ORACLE\ORADATA\BBBB\REDO01.LOG' SIZE 1M,
9 GROUP 2 'C:\ORACLE\ORADATA\BBBB\REDO02.LOG' SIZE 1M,
10 GROUP 3 'C:\ORACLE\ORADATA\BBBB\REDO03.LOG' SIZE 1M,
11 GROUP 4 'C:\ORACLE\ORADATA\BBBB\REDO04.LOG' SIZE 1M
12 DATAFILE
13 'C:\ORACLE\ORADATA\BBBB\SYSTEM01.DBF',
14 'C:\ORACLE\ORADATA\BBBB\RBS01.DBF',
15 'C:\ORACLE\ORADATA\BBBB\USERS01.DBF',
16 'C:\ORACLE\ORADATA\BBBB\TEMP01.DBF',
17 'C:\ORACLE\ORADATA\BBBB\TOOLS01.DBF',
18 'C:\ORACLE\ORADATA\BBBB\INDX01.DBF',
19 'C:\ORACLE\ORADATA\BBBB\DR01.DBF'
20 CHARACTER SET WE8ISO8859P1;
CREATE CONTROLFILE REUSE SET DATABASE BBBB RESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01504: database name 'BBBB' does not match parameter db_name 'AAAA'

Thanks
Harry

[pando]

check ORACLE_SID
check initSID.ora filename
check your startup syntax and pfile specified

[harrygulls]

(1)How to check Oracle_sid..?

Now I am getting this error.

SQL> startup nomount pfile='c:\oracle\ora81\initBBBB.ora';
LRM-00109: could not open parameter file 'c:\oracle\ora81\initBBBB.ora'
ORA-01078: failure in processing system parameters

Thanks
Harry

[pando]

ORACLE_SID is set in registry or windows enviroment variables

the error says there is no such file

if file exists then check new parameters you have added

[mselvarajan]

SQL> CREATE DATABASE dbpro
DATAFILE '/opt/app/dbpro/oradata/oracle/system01.dbf' SIZE 100M REUSE AUTOEXTEND ON
UNDO TABLESPACE undotbs1 DATAFILE '/opt/app/dbpro/oradata/oracle/undotbs1.dbf' SIZE 50M REUSE AUTOEXTEND ON
default temporary tablespace temp tempfile '/opt/app/dbpro/oradata/oracle/temp01.dbf' size 10m reuse autoextend on
LOGFILE GROUP 1 '/opt/app/dbpro/oradata/oracle/redo01.log' SIZE 10M,
GROUP 2 '/opt/app/dbpro/oradata/oracle/redo02.log' SIZE 10M;

CREATE DATABASE dbpro
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'DBPRO' does not match parameter db_name 'oracle'

pls help me

[davey23uk]

the db_name parameter you have set in the parameter file 'oracle' does not match what you are actually trying to create 'dbpro' fix one or the other

[reydp]

set env ORACLE_SID in O.S. level like:
SET ORACLE_SID=BBBB

before recreating controlfile.

[davey23uk]

set env ORACLE_SID in O.S. level like:
SET ORACLE_SID=BBBB

before recreating controlfile.

the first post is 5 years old - id imagine he has fixed that. The guy who has re-opened this thread has a new problem - and what you posted there wont have helped either

[ams-jamali]

set as db_name=dbpro in pfile;
then redo the same process.