Home » RDBMS Server » Server Administration » ARCHIVE MODE
ARCHIVE MODE [message #169029] Mon, 24 April 2006 14:08 Go to next message
jiteshmnair
Messages: 12
Registered: April 2006
Location: Mumbai
Junior Member
Please help me out.
Using Oracle 10g. My Database is in NOARCHIVELOG mode. I want to switch it to ARCHIVELOG mode. I did the following steps: -

1. Shutdown Immediate.
2. Startup Mount
At this stage following error is shown: -
Error:-
ORA-12528: TNS:listener: all aprropriate instances are blocking new sessions.

I do not know why this error is ocurring.

Also, tell me the correct syntax of the changes to be made in the Spfile for ARCHIVING. I think this should be done after the above steps. I am new so am unaware as to what will happen if anything goes out of hand.

Also, please suggest any indepth detail books which i can refer.

Thank You,
Jitesh

Report message to a moderator

Re: ARCHIVE MODE [message #169711 is a reply to message #169029] Fri, 28 April 2006 06:04 Go to previous message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
can you post server parameter file

Thanks & Regards
madhu

Report message to a moderator

Previous Topic: Temporary tablespace
Next Topic: Adding and Dropping Partitions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:48:50 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.