OraFAQ Forum: Server Administration » Database is not mounted

Home » RDBMS Server » Server Administration » Database is not mounted

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

Database is not mounted [message #281468]

Sat, 17 November 2007 03:13

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

Report message to a moderator

Re: Database is not mounted [message #281482 is a reply to message #281468]

Sat, 17 November 2007 04:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

LOG_ARCHIVE_DEST
LOG_ARCHIVE_DEST_n

Regards
Michel

Report message to a moderator

Re: Database is not mounted [message #281523 is a reply to message #281468]

Sat, 17 November 2007 21:59

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.

Report message to a moderator

Re: Database is not mounted [message #281533 is a reply to message #281523]

Sun, 18 November 2007 00:06

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.

Report message to a moderator

Re: Database is not mounted [message #281659 is a reply to message #281468]

Sun, 18 November 2007 23:50

pratik123
Messages: 41
Registered: October 2007
Location: hyderabad

Member

thanx to every one

Report message to a moderator

Re: Database is not mounted [message #281663 is a reply to message #281468]

Sun, 18 November 2007 23:57

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

Report message to a moderator

Re: Database is not mounted [message #281664 is a reply to message #281468]

Mon, 19 November 2007 00:01

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Database is not mounted [message #281667 is a reply to message #281468]

Mon, 19 November 2007 00:06

pratik123
Messages: 41
Registered: October 2007
Location: hyderabad

Member

ok sir

can you give me details

thanks for replay

Report message to a moderator

Re: Database is not mounted [message #281668 is a reply to message #281468]

Mon, 19 November 2007 00:11

pratik123
Messages: 41
Registered: October 2007
Location: hyderabad

Member

I HAVE CREATED P FILE NOW HOW I USE IT AT STARTUP DATABASE

Report message to a moderator

Re: Database is not mounted [message #281671 is a reply to message #281468]

Mon, 19 November 2007 00:14

BlackSwan
Messages: 26766
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

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

Smile

Report message to a moderator

Re: Database is not mounted [message #281678 is a reply to message #281468]

Mon, 19 November 2007 00:33

pratik123
Messages: 41
Registered: October 2007
Location: hyderabad

Member

hi seniours now my database is up

thank you very much to all

Report message to a moderator

Re: Database is not mounted [message #281682 is a reply to message #281468]

Mon, 19 November 2007 00:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

stop shooting yourself in the foot & you won't have to recover from self inflicted wounds

Report message to a moderator

Re: Database is not mounted [message #282105 is a reply to message #281682]

Tue, 20 November 2007 21:43

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)

Report message to a moderator

Re: Database is not mounted [message #282164 is a reply to message #282105]

Wed, 21 November 2007 01:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	SYS-GRANT on V_$SESSION impossible
Next Topic:	redo transport services

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:43:47 CST 2024