 SPFILE Problem, Oracle Startup Problem [message #170400] |
Wed, 03 May 2006 10:43  |
Naji Ghanim
Messages: 8
Registered: January 2005
Location: Amman - Jordan
|
Junior Member |
|
|
Hellow All;
My Platform 10g on Windows.
I have this big problem:
1- I was trying to enable Archive log
2- I modified the value of LOG_ARCHIVE_DEST using Toad 'Oracle Parameters'
3- I shutdown the DB from SQLPLUS
4- I started it up nomount ,
then I got ORA-16019: cannot use %s with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST,
& It wasn't restarted.
5- I have backup of Pfile , & I tried the command
startup pfile= pfile loc
It didn't work
6- Now I can't log using any user & it gives me
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
PLS
1- I need to create my SPFILE from PFILE again, while instance is not started, or from OS level.
2- Is it possible to let the instance start with PFILE insted of SPFILE.
startup pfile= pfile loc
Will not work because I can't connect @ all
Best regards,
Naji
[Updated on: Wed, 03 May 2006 13:49] Report message to a moderator |
|
|
|
| Re: SPFILE Problem [message #170423 is a reply to message #170400] |
Wed, 03 May 2006 13:26  |
Naji Ghanim
Messages: 8
Registered: January 2005
Location: Amman - Jordan
|
Junior Member |
|
|
Hellow All,
I read my old documentations I found We can do the following:
1- Use oradim to delete current service.
2- Use oradim to create new service
oradim -new -sid <SID_NAME> -intpwd <SYS_PASS>
-startmode auto
-pfile D:\Oracle\ADMIN\HR\pfile\init.ora
A friend told me over phone:
There is a backup file in the sample folder. It contains the essential keys to start the engine. Copy it to the d:\Oracle\Database, Then instance will go up.
I will try both ways when I go to my work tomorrow.
I welcome any suggestion from u dear friends.
---------------------------
I don't know what about the ORA-12514 error. Will it go after I solve the spfile problem?
Best Regards,
Naji Ghanim
[Updated on: Wed, 03 May 2006 13:27] Report message to a moderator |
|
|
|
| Re: SPFILE Problem, Oracle Startup Problem [message #170544 is a reply to message #170400] |
Thu, 04 May 2006 05:18 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
you can edit your pfile manually and then try to start the instance..once you succeed in doing that, you can create spfile from the pfile and use that spfile..
regarding listener, make sure, that the listener is up and running ...go to listener control utility by lsnrctl command , and post output of status command.
|
|
|
|
 Re: SPFILE Problem, Oracle Startup Problem [message #170580 is a reply to message #170544] |
Thu, 04 May 2006 07:23 |
Naji Ghanim
Messages: 8
Registered: January 2005
Location: Amman - Jordan
|
Junior Member |
|
|
Dear niravshah ,
Thank you very much for ur reply.
I done the following:
1- Rename the spfile.ora to something else.
2- make copy of pfile.ora with name init$ORACLE_SID.ora
3- In Services I restared both the instance & listener.
4- Thank GOD it worked very fine.
5- CREATE SPFILE='SPFILE$ORACLE_SID.ORA' FROM PFILE='init$ORACLE_SID.ora';
------------------------------------------------
The following is from Oracle Documantation:
In the platform-specific default location <Defaulf Home\Database>, Oracle Database locates your initialization parameter file by examining filenames in the following order:
1. spfile$ORACLE_SID.ora
2. spfile.ora
3. init$ORACLE_SID.ora
Best Regards,
Naji
[Updated on: Thu, 04 May 2006 07:24] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
