Home » RDBMS Server » Server Administration » Database is not mounted
Database is not mounted [message #281468] Sat, 17 November 2007 03:13 Go to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
i have instal the oracle 10 create database when i set in archive log following way

alter system set log_archive_dest=.........
scope =spfile;
alter system set log_archive_start=true scope=spfile

shutdown immediate..... its well
startup mount

ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE
_DUPLEX_DEST


please help me

Re: Database is not mounted [message #281482 is a reply to message #281468] Sat, 17 November 2007 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LOG_ARCHIVE_DEST
LOG_ARCHIVE_DEST_n

Regards
Michel
Re: Database is not mounted [message #281523 is a reply to message #281468] Sat, 17 November 2007 21:59 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

log_archive_start parameter has been deprecated in 10g.

Don't use it.
Re: Database is not mounted [message #281533 is a reply to message #281523] Sun, 18 November 2007 00:06 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And also add "location" keyword when you set "log_archive_dest_n" parameter for local location.
Re: Database is not mounted [message #281659 is a reply to message #281468] Sun, 18 November 2007 23:50 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
thanx to every one
Re: Database is not mounted [message #281663 is a reply to message #281468] Sun, 18 November 2007 23:57 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
HI SIR

BUT HOW DO WE RESOLVE THE

ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE
_DUPLEX_DEST
SQL>

WHEN I STARTUP MY DATA BASE SHOW THIS ERROR
Re: Database is not mounted [message #281664 is a reply to message #281468] Mon, 19 November 2007 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>BUT HOW DO WE RESOLVE THE
create a correct & valid PFILE & use it during the STARTUP of the database
Re: Database is not mounted [message #281667 is a reply to message #281468] Mon, 19 November 2007 00:06 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
ok sir

can you give me details

thanks for replay
Re: Database is not mounted [message #281668 is a reply to message #281468] Mon, 19 November 2007 00:11 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
I HAVE CREATED P FILE NOW HOW I USE IT AT STARTUP DATABASE
Re: Database is not mounted [message #281671 is a reply to message #281468] Mon, 19 November 2007 00:14 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
SQL> STARTUP PFILE=<pfile_name>

GOOGLE is your friend, but only when you actually use it!

Results 1 - 10 of about 74,500 for oracle startup pfile.

[Updated on: Mon, 19 November 2007 00:16] by Moderator

Report message to a moderator

Re: Database is not mounted [message #281673 is a reply to message #281468] Mon, 19 November 2007 00:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Or delete your default spfile and just invoke startup if you have default name and location of your pfile. Smile
Re: Database is not mounted [message #281678 is a reply to message #281468] Mon, 19 November 2007 00:33 Go to previous messageGo to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
hi seniours now my database is up


thank you very much to all
Re: Database is not mounted [message #281682 is a reply to message #281468] Mon, 19 November 2007 00:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
stop shooting yourself in the foot & you won't have to recover from self inflicted wounds
Re: Database is not mounted [message #282105 is a reply to message #281682] Tue, 20 November 2007 21:43 Go to previous messageGo to next message
ora_zhp
Messages: 10
Registered: September 2007
Junior Member
Initialization Parameters Deprecated in Release 10.1
The following initialization parameters were deprecated in release 10.1:


BUFFER_POOL_KEEP (replaced by DB_KEEP_CACHE_SIZE)
BUFFER_POOL_RECYCLE (replaced by DB_RECYCLE_CACHE_SIZE)
GLOBAL_CONTEXT_POOL_SIZE
LOCK_NAME_SPACE
LOG_ARCHIVE_START
MAX_ENABLED_ROLES
PARALLEL_AUTOMATIC_TUNING
PLSQL_COMPILER_FLAGS (replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG)
Re: Database is not mounted [message #282164 is a reply to message #282105] Wed, 21 November 2007 01:07 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And in your list there is not the parameter at the origin of OP's problem.
Parameter which is clearly displayed in the error message.

Regards
Michel
Previous Topic: SYS-GRANT on V_$SESSION impossible
Next Topic: redo transport services
Goto Forum:
  


Current Time: Thu Dec 08 21:50:10 CST 2016

Total time taken to generate the page: 0.11803 seconds