| Oracle database startup error [message #60150] |
Mon, 19 January 2004 15:48  |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
SQL> connect /as SYSDBA
Connected to an idle instance.
SQL> startup
ORA-07446: sdnfy: bad value '/home/oracle/admin/erp/udump' for parameter user_dump_dest.
SQL>
|
|
|
|
| Re: Oracle database startup error [message #60151 is a reply to message #60150] |
Mon, 19 January 2004 18:19  |
etryblr
Messages: 28
Registered: December 2003
|
Junior Member |
|
|
Mount the database(but not open the dB) and run this query
select name,value from v_$parameter where name = 'user_dump_dest'
chk out whthr this path is the same as the path mentioned in the error
Did u/anyone change init.ora by any chance.
|
|
|
|
| Re: Oracle database startup error [message #60152 is a reply to message #60150] |
Mon, 19 January 2004 18:41 |
etryblr
Messages: 28
Registered: December 2003
|
Junior Member |
|
|
Sorry ...u cannot query v_Parameter in mount state(It's a fixed table)
1.Check in your init.ora file for the variable user_dump_dest.This Path will have all trace files.
2.Check whether the physical path is same or different.
|
|
|
|
| Re: Oracle database startup error [message #60153 is a reply to message #60150] |
Mon, 19 January 2004 19:20 |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
Good Day
Thanks for ur reply,
actually before this the server ip was different after that we had changed the server ip.
Then a week after that i try to boot oracle it giving this error.
This oracle is running on linux redhat 7.2
i cant find the init.ora you had mentioned
Is there any where i need to re-enter the new ip add
If yes please guide me
Bye
|
|
|
|
| Re: Oracle database startup error [message #60156 is a reply to message #60153] |
Mon, 19 January 2004 22:00 |
etryblr
Messages: 28
Registered: December 2003
|
Junior Member |
|
|
1.What version of oracle u r using?
2.start the dB in nomount stage and run the falg query
select name,value
from v$parameter
where name = 'user_dump_dest';
This gives the path of user_dump_dest
Check out whether the path is physically present.
3.find for init.ora on the server.U can use find command.
u shud search for initSID.ora
replace SID by your ORACLE_SID
usually this will be in $ORACLE_HOME/dbs
Once u figure out init.ora, find the value for parameter user_dump_dest. This shud be the same as the out come of query in step 3.
4.IP address,i think u wud be re-entering only in tnsnames.ora.
Let me know these details
|
|
|
|
| Re: Oracle database startup error [message #60157 is a reply to message #60156] |
Mon, 19 January 2004 23:47 |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
im running oracle9i
i found tnsnames.ora - everything seems ok
i cant find initSID.ora
i cant run the query you ask me to do.
im sorry cause im not that good in oracle
im still learning
when i run ur query it says the db not started
cause i can go to sqlplus but the database not started yet.
what i do always is go to sqlplus /nolog
connect /as sysdba
startup
this what i always do
and now when enter startup it displaying that error
sorry to bug u
thank u
|
|
|
|
| Re: Oracle database startup error [message #60167 is a reply to message #60157] |
Tue, 20 January 2004 10:06 |
Jadie
Messages: 64
Registered: January 2002
|
Member |
|
|
1. connect to database from Unix
sqlplus "/ as sysdba"
2. start the database in nomount:
startup nomount
3. show parameters user
if you did not get any error message from the previous step, you should be able to check the parameter. Same as the query you said you can not run actually.
4. correct the parameter. Default oracle 9i runs in server parameter mode.
alter system set user_dump_dest = 'Correct Path';
show parameter spfile to see if the DB runs in Server Parameter mode.
|
|
|
|
| Re: Oracle database startup error [message #60172 is a reply to message #60167] |
Tue, 20 January 2004 15:31 |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
Good Day
i have tried you suggesstion but still the same message comes out.
[[oracle@support oracle]]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 21 09:42:41 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-07446: sdnfy: bad value '/home/oracle/admin/erp/udump' for parameter user_dump_dest.
|
|
|
|
| Re: Oracle database startup error [message #60175 is a reply to message #60150] |
Tue, 20 January 2004 18:21 |
sachin kumar gupta
Messages: 157
Registered: March 2003
|
Senior Member |
|
|
Pls. follow the steps, it may help u:
1. First search out ur initSID.ora or its IFILE for the db u want to start.
2. It has to be available for startup command to work. If it's available check the user_dump_dest. Verify that the destination is existing.
Also check all the files like listener.ora, tnsnames.ora where HOST string has host name/IP address. Check whether IP address is new one.
Regards,
Sachin
|
|
|
|
| Re: Oracle database startup error [message #60176 is a reply to message #60172] |
Tue, 20 January 2004 18:37 |
etryblr
Messages: 28
Registered: December 2003
|
Junior Member |
|
|
okay.Chk this out in your server
1.Chk out what's present at '/home/oracle/admin/erp/udump' on your server.
It'll usually have trace files.
2.From your home dir run this unix cmd
>find / -name 'init*.ora' -print > iora
this will find all iit.ora files on your m/c and save it in a file named iora.Open the file iora and see the path for your init.ora(init<SID>.ora)
SID details, u can get by running this cmd
> echo $ORACLE_SID
3.Chk for the value set to user_dump_dest in init.ora
let me know the result
regds
Prashanth
|
|
|
|
| Re: Oracle database startup error [message #60177 is a reply to message #60176] |
Tue, 20 January 2004 19:54 |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
Good Day
This is what been present in udump
----------------------------------------/home/oracle/OraHome1/admin/erp/udump/erp_ora_13009.trc
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /home/oracle/OraHome1
System name: Linux
Node name: support.com
Release: 2.4.7-10
Version: #1 Thu Sep 6 17:27:27 EDT 2001
Machine: i686
Instance name: erp
Redo thread mounted by this instance: 0 <none>
Oracle process number: 12
Unix process pid: 13009, image: oracle@support.com (TNS V1-V3)
*** SESSION ID:(9.1) 2003-11-21 17:51:36.502
Archiving is disabled
Archiving is disabled
/home/oracle/OraHome1/admin/erp/udump/erp_ora_13009.trc
Exception signal: 11 (SIGSEGV), code: 128 (unknown code), addr: 0x0, PC: [[0x400a2001,
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [[0x4000d440,
-----------------------------------------------------
when i echo $ORACLE_SID
it gives "erp"
So what am i suppose to do now
Thanks
|
|
|
|
| Re: Oracle database startup error [message #60179 is a reply to message #60177] |
Wed, 21 January 2004 01:24 |
etryblr
Messages: 28
Registered: December 2003
|
Junior Member |
|
|
1.Did u figured out init.ora?If so, is the path correct?
What's the date/time stamp of erp_ora_13009.trc.
Is it approximately date/time the IP Addres changed?
2.If so start the dB as below
SQL >startup nomount pfile = init.ora(full path with full name)
3.If it works out, then
SQL >alter database mount;
SQL >alter database open;
|
|
|
|
| Re: Oracle database startup error [message #60184 is a reply to message #60179] |
Wed, 21 January 2004 16:11 |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
Good Day
i had done as you guide this was the reply
SQL> startup nomount pfile = /home/oracle/OraHome1/dbs/init.ora
ORACLE instance started.
Total System Global Area 67907504 bytes
Fixed Size 450480 bytes
Variable Size 67108864 bytes
Database Buffers 204800 bytes
Redo Buffers 143360 bytes
SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying controlfile, check alert log for more info
SQL>
--------------------------------------------
i couldnot find the udump dest or anything metionning the destination in init.ora but there is some line mentioning the control file and i check the particula directory there is no such control file. if you can give ur email add i can mail u the init.ora.
the time stamp on the error file its showing nov 21 - i changed ip somewhere on december.
Thanks
|
|
|
|
|
|
| Re: Oracle database startup error [message #60195 is a reply to message #60150] |
Thu, 22 January 2004 10:29 |
Sanjay
Messages: 236
Registered: July 2000
|
Senior Member |
|
|
Let's make each others life easier here ... always start from the basics ...
[[/home/oracle:]] oerr ora 7446
07446, 00000, "sdnfy: bad value '%s' for parameter %s."
// *Cause: The directory specified as the value for the stated parameter could
// not be used.
// *Action: Make sure the directory you have specified is a valid
// directory/file specification.
Looks like your udump folder DOES NOT exist...
|
|
|
|
|
|
| Re: Oracle database startup error [message #60214 is a reply to message #60187] |
Fri, 23 January 2004 16:01 |
Kumar Arjunan
Messages: 9
Registered: January 2004
|
Junior Member |
|
|
Good Day
Im the one installed oracle in the machine, but i'm still new to this oracle and linux.
I dont what happen, may be i'll try to load back the database or oracle.
I need to ask you another thing: I had installed this oracle and i'm using a software that uses oracle, so i actually wantted to learn that particular software only, so i really dont anything else in oracle accept sqlplus where i login and startup the database. This is the only thing i no in oracle.
can you guide me on how to use oracle, is there a GUI mode came with the installation which i can access, after the installation i saw a GUI to access the db but now i dont no where is located and how to access it. If you can help thanks a lot.
Bye
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
