archival & no archival issues

[randy]

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?

[marist89]

did you switch your database to noarchivelog mode?

http://technet.oracle.com/docs/produ...e3.htm#2049046

Most likely, your logfiles need archiving.

[noor]

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

[ligang]

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)

[noor]

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