OraFAQ Forum: Server Administration » Problem with ORACLE

Home » RDBMS Server » Server Administration » Problem with ORACLE_SID

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with ORACLE_SID [message #221811]

Wed, 28 February 2007 09:32

roopla
Messages: 52
Registered: May 2006

Member

I am not able startup a database in nomount state for particular ORACLE_SID. It seems it doesn't like the ORACLE_SID I set to.
It's throwing following error
ORA-07345: The datafile name must not contain the string '..'.

Steps I did like follows
1) export ORACLE_SID=ABC
2) I have init.ora, which has DB_NAME=ABC
3) startup nomount pfile='/export/home/oracle/init.ora'

It works great and puts db in nomount state

But, when I change ORACLE_SID=XYZ and edited init.ora with
DB_NAME=XYZ, then did
startup nomount pfile=''/export/home/oracle/init.ora', then it throws following error

ORA-07345: The datafile name must not contain the string '..'.

It really puzzels why it doesn't like ORACLE_SID ABC.

Any clue?

Report message to a moderator

Re: Problem with ORACLE_SID [message #221814 is a reply to message #221811]

Wed, 28 February 2007 09:40

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,
It really puzzels why it doesn't like ORACLE_SID ABC.
It is expected behaviour.

It is not very easy that you think if you want to change DB_NAME then you have to use NID utility.

just edit DB_NAME parameter you cann't change your database name.

regards
Taj

Report message to a moderator

Re: Problem with ORACLE_SID [message #221816 is a reply to message #221811]

Wed, 28 February 2007 09:45

roopla
Messages: 52
Registered: May 2006

Member

Taj

I am sorry, I didn't understand your response. I was trying to create a database XYZ, but ran into the problems. But When I change database name to ABC, it works great. What's wrong with a particular ORACLE_SID.

Thanks

Report message to a moderator

Re: Problem with ORACLE_SID [message #221817 is a reply to message #221811]

Wed, 28 February 2007 09:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

We have been insisting this too many times Smile

Post what you did and errors you got EXACTLY within CODE tags. Do not retype/describe what you did. It helps very little.
To start with, syntax you posted is wrong. There is an unwanted quote here.
>>startup nomount pfile=''/export/home/oracle/init.ora',

Moreover, you just changed DB_NAME=ABC. But still, the controlfiles know the database as XYZ only.
So when you try to mount the database, you are supposed to get an
ora-01103 error(something like database name 'XYZ' in controlfile is not 'ABC').

Report message to a moderator

Re: Problem with ORACLE_SID [message #221818 is a reply to message #221811]

Wed, 28 February 2007 09:49

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

Hi Taj,

I am fine with your respose. I have a doubt here. Why does Oracle throw an error with respect to the datafile rather than the database name itself.

Please clarify.

Report message to a moderator

Re: Problem with ORACLE_SID [message #221826 is a reply to message #221818]

Wed, 28 February 2007 10:23

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

ORA-07345 The datafile name must not contain the string '..'.

Cause: The specified datafile name contains '..'.

Action: Correct the datafile name and retry the operation

Go through below link hope this helps.

http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d61435f4611d75409f80a5a0b00196bb16.e34QbhuKaxmMai0MaNeMb3eKb390?messageID=1385261&#1385261

Why does Oracle throw an error with respect to the datafile rather than the database name itself.
It is throw database name error. but here is case is different.
Read "Mahesh" response it will clear you doubt.

OP want to create new database with name is XYZ. but we don't know what he did actually before startup nomount new database.

regards
Taj

Report message to a moderator

Re: Problem with ORACLE_SID [message #221845 is a reply to message #221811]

Wed, 28 February 2007 12:21

roopla
Messages: 52
Registered: May 2006

Member

Mahesh

All I was trying to create a database manually then ran into these issues with ORACLE_SID

There is no database exist on my server. All I did is follows.

$export ORALCE_SID=XYZ

I have a init.ora file contains just follows
db_name='XYZ'

$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 28 13:08:01 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/export/home/oracle/init.ora'
ORACLE instance started.

Total System Global Area 171966464 bytes
Fixed Size 2027472 bytes
Variable Size 113250352 bytes
Database Buffers 50331648 bytes
Redo Buffers 6356992 bytes

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.

That's it.

---------------------------------------------------------
Now I am back to my UNIX prompt to change my ORACLE_SID

$export ORACLE_SID=ABC

I edited my init.ora file as follows ( it just only one statement)
db_name='ABC'

$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 28 13:13:08 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/export/home/oracle/init.ora'
ORA-07345: The datafile name must not contain the string '..'.

I just don't understand why it doesn't like 'ABC' as ORACLE_SID.

I hope it helps

Report message to a moderator

Re: Problem with ORACLE_SID [message #221852 is a reply to message #221845]

Wed, 28 February 2007 12:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I just don't understand why it doesn't like 'ABC' as ORACLE_SID.
cannot reproduce your case.
>>I have a init.ora file contains just follows
>>db_name='XYZ'
Did the same with a single entry. cannot reproduce.

---
-- For XYZ
--- 
oracle@xxxxx:/u01/home/dbs> export ORACLE_SID=XYZ
oracle@xxxxx:/u01/home/dbs> cat init.ora
db_name='XYZ'
oracle@xxxxx:/u01/home/dbs> sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 28 13:39:02 2007
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='$ORACLE_HOME/dbs/init.ora';
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2069712 bytes
Variable Size             113249072 bytes
Database Buffers           50331648 bytes
Redo Buffers                6316032 bytes
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

---
-- for ABC. edited init.ora.
--- 

oracle@xxxxx:/u01/home/dbs> export ORACLE_SID=ABC
oracle@xxxxx:/u01/home/dbs> cat init.ora
db_name='ABC'
oracle@xxxxx:/u01/home/dbs> sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 28 13:41:51 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='$ORACLE_HOME/dbs/init.ora';
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2069712 bytes
Variable Size             113249072 bytes
Database Buffers           50331648 bytes
Redo Buffers                6316032 bytes

---
-- check.
--- 
SQL> !ps -ef | grep ABC
oracle   10837     1  0 13:42 ?        00:00:00 ora_pmon_ABC
oracle   10839     1  0 13:42 ?        00:00:00 ora_psp0_ABC
oracle   10841     1  0 13:42 ?        00:00:00 ora_mman_ABC
oracle   10843     1  0 13:42 ?        00:00:00 ora_dbw0_ABC
oracle   10845     1  0 13:42 ?        00:00:00 ora_lgwr_ABC
oracle   10847     1  0 13:42 ?        00:00:00 ora_ckpt_ABC
oracle   10849     1  0 13:42 ?        00:00:00 ora_smon_ABC
oracle   10851     1  0 13:42 ?        00:00:00 ora_reco_ABC
oracle   10853     1  0 13:42 ?        00:00:00 ora_mmon_ABC
oracle   10855     1  0 13:42 ?        00:00:00 ora_mmnl_ABC
oracle   10856 10772  0 13:42 ?        00:00:00 oracleABC (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle   10974 10772  0 13:42 pts/0    00:00:00 /bin/bash -c ps -ef | grep ABC
oracle   10976 10974  0 13:42 pts/0    00:00:00 grep ABC

SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

Report message to a moderator

Re: Problem with ORACLE_SID [message #221873 is a reply to message #221852]

Wed, 28 February 2007 13:58

roopla
Messages: 52
Registered: May 2006

Member

Mahesh

You are right. Even I can't reproduce this probelm on other servers.

I have this problem only on a particular server. It works fine on all other servers just like in your case. What could be the problem with my server box. Is it hardware or something else?

Report message to a moderator

Re: Problem with ORACLE_SID [message #221875 is a reply to message #221873]

Wed, 28 February 2007 14:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Check whether you have a database/instance named ABC (look for ps -ef | grep smon, init.ora file anything.).
Obviously, you are doing something quirky Smile

Report message to a moderator

Previous Topic:	Import Error Messages
Next Topic:	cronjob

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:48:30 CST 2024