ORA-16044 & ORA-16154 & ORA-00922

luyan used Ask the Experts™
Our envirnment is 10g on Linux. I got the following errors in alert log. How to fix it?
ORA-16044: destination LOG_ARCHIVE_DEST_1 attribute cannot be specified at session level
ORA-16154: suspect attribute: MAX_FAILURE
ORA-00922: missing or invalid option
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you need to do alter system
not alter session
to change  LOG_ARCHIVE_DEST_1
If you found those errors in the alert log, then there's nothing to fix.

Someone else (other dba or a developer, ...) tried to issue a command lile "alter session set log_archive_dest_1="some destination';" so the errors came out in the alert log. As it-rex has commented, LOG_ARCHIVE_DEST is a system parameter that can only be changed at system level, not session.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial