Home » RDBMS Server » Server Administration » Archive in multiple destination
Archive in multiple destination [message #215871] Wed, 24 January 2007 02:29 Go to next message
Maheshprajap
Messages: 7
Registered: September 2005
Location: Nepal
Junior Member
Oracle 9i database is to archive to multiple destinations. there is the error reporting "ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed" when log_archive_start= true . What may be the possible cause for this error.
Re: Archive in multiple destination [message #215875 is a reply to message #215871] Wed, 24 January 2007 02:32 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,

ORA-16024: parameter string cannot be parsed

Cause: The value for the indicated LOG_ARCHIVE_DEST_n (n = 1...10) parameter could not be parsed. Common causes for this error are a misplaced equal sign, an unrecognized attribute, or an attribute that is missing a required value.

Action: Correct the value for the indicated LOG_ARCHIVE_DEST_n parameter.


can you post your "LOG_ARCHIVE_DEST_n" parameter value.

regards
Taj
Re: Archive in multiple destination [message #215876 is a reply to message #215875] Wed, 24 January 2007 02:34 Go to previous messageGo to next message
Maheshprajap
Messages: 7
Registered: September 2005
Location: Nepal
Junior Member
value:
LOG_ARCHIVE_DEST_1 = 'LOCATION = F:\Oracle\ARCHIVE1'

in the same pc. The parameter is processed when log_archive_start=false is applied.
Re: Archive in multiple destination [message #215879 is a reply to message #215876] Wed, 24 January 2007 02:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
i don't think it is because of "LOG_ARCHIVE_START" parameter.
becuase if you specify "LOG_ARCHIVE_START"="true". archive start automatic with INSTANCE startup.
if you turn to FALSE archiving not START with instance startup.

and your error is gone.
but root cluase is something else.

also post your init.ora file.

regards
Taj

[Updated on: Wed, 24 January 2007 02:40]

Report message to a moderator

Re: Archive in multiple destination [message #215880 is a reply to message #215879] Wed, 24 January 2007 02:43 Go to previous messageGo to next message
Maheshprajap
Messages: 7
Registered: September 2005
Location: Nepal
Junior Member
here is the init.ora file
Re: Archive in multiple destination [message #215909 is a reply to message #215880] Wed, 24 January 2007 04:54 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Couple things to check:

* Remove the spaces around the equal sign (=) before and after the LOCATION keyword.
* Are you sure the directory exists and you have privileges to the directory?

Re: Archive in multiple destination [message #216019 is a reply to message #215880] Wed, 24 January 2007 12:12 Go to previous message
satheeshb
Messages: 5
Registered: July 2006
Junior Member
Hi,
As per Note:96278.1,

Solution Description
--------------------
Check the following after ensuring that the location is a valid directory
and that Oracle has write permissions there.

1. Remove the spaces on either side of the '=' sign. You cannot have
as space on either side on the '=' sign. Note: The word location
can be in either upper or lower case.

log_archive_dest_1 = 'location=/u01/oracle/arc'

2. Make sure that there is no trailing /.

3. Make sure that LOG_ARCHIVE_DEST is not set in the init.ora. These 2
parameters are not compatible with each other.

4. If still not working set the LOG_ARCHIVE_DEST_n parameter to a null
value - LOG_ARCHIVE_DEST_n=''

Regards,
Satheesh Babu.S
Bangalore

Previous Topic: Is this Procedure is OK
Next Topic: Script to Monitor Table Space
Goto Forum:
  


Current Time: Fri Dec 02 14:01:29 CST 2016

Total time taken to generate the page: 0.05637 seconds