-
I shut my database down immediate
I changed my database from Archive mode to noarchive mode by commenting
these parameters:
#log_archive_start = true
#log_archive_dest = /11/oracle02/TESTDB/archive
#log_archive_duplex_dest = /oracle_direct/TESTD/archive
#log_archive_format = "arch%S.arc"
After I start the database as sys.
I later tried to connect using a username that has dba priveledges.
For 30 minutes, I could not connect. But If I connect as sys, no problem.
Has anyone ever experienced this problem? What's going on?
-
did you switch your database to noarchivelog mode?
http://technet.oracle.com/docs/produ...e3.htm#2049046
Most likely, your logfiles need archiving.
-
Hello,
I think that you forgot to put the database in NOARCHIVE MODE using : alter database noarchivelog
(!!! : the database must be mounted not opened).
Hope this helps
-
If you want to switch your database to archive mode , you can not just change your parameter file . (type archive log list , it will show you which mode your database is)
-
Hello,
I have forgotten to give you a way to see if the DB is in ARCHIVELOG or NOARVHIVELOG Mode. launch :
select * from v$database;
Hope this helps
