redo log alloaction problem urgent

[drishti]

hello
this is the extract of my alertlog,pl help soon-
thread 1 cannot allocate new log,sequence 1036
all online logs need archivelog
shutting down instance
license hwm=17
ora-00600-internal error code,arguments :[12333],[7],[5],[49],[],[]

the db is getting downfrequently.pl help soon

[pando]

is your arch directory full

[drishti]

hello,and thanks for response
yesterday I recreated a database in archivelog mode.previously it was in noarchivelog mode.
today morning i saw some errors in alertlog like this-
ARC0: Beginning to archive log# 1 seq# 1021
Mon Nov 06 11:47:19 2000
Thread 1 cannot allocate new log, sequence 1023
All online logs needed archiving
Current log# 2 seq# 1022 mem# 0: E:\ORACLE\ORADATA\ORTEL\REDO02.LOG
Mon Nov 06 11:47:21 2000
ARC0: Completed archiving log# 1 seq# 1021
ARC0: re-scanning for new log files
ARC0: prodding the archiver
ARC0: STARTING ARCH PROCESSES
ARC1: Failed to archive log# 2 seq# 1022

so on seeing this i changed the parameters in init.ora
as i am not being able to connect as internal -
so i cant do alter database noarchivelog;
restarted the db.

within 5 minutes i got this errors
oracle error during redolog archival ,cannot allocate log
archival needed.
as previuosly stated-
can u get it?hurry pl.

[pando]

so basically you are still in archivelog, why you cant connect with internal? Do you use passwordfile, if you do you can connect with sys or system with sysdba or sysoper role to startup or shutdown the database.
Is it in UNIX or NT, production or development

also try

alter system archive log start to '/another_directory';
to change the directory of archive logs

or
alter system archive log stop;
this will stop archive process ARCH0 & ARCH1

[siroracle]

U must do

ALTER DATABASE ARCHIVELOG

U cannot just alter the init.ora.

[pando]

I think he cant even do that since he cant connect as internal to startup the database in mount state to change to noarchive log, I guess it´s fasterby stopping the ARCH processes to stop archiving

[siroracle]

but if he wants archiving...he nust do the alter system archivelog thing

I didn't understand why he can't connect as internal?!?!?

[pando]

I think he is in archivelog already, well according to his alert log it seems like the ARCH0 & 1 are trying to archive the logs anyway.

I dont know why he cant connect as internal neither :o May be he is running 9i? :D just kidding

[siroracle]

what's with the 9i? there is not internal there? :)

[pando]

yea I heard internal is gone in 9i, it was supposed to be phase out in 8.1.7 though :)

[pando]

btw I wonder how can we create a database if we cant logon as internal heh

[aracnid]

connecting as internal generates a log file .aud ,so if your file system is full "forget connect as internal".
P.s move your arch file from there.

[pando]

that if you have audit trail on though?

[aracnid]

yes! .......(is the default)

[aracnid]

sorry ...
audit_trail string NONE

[drishti]

hi,
I am working on oracle 8i i.e, 8.1.5.I am not being able to connect as internal after full db import.i don't know why it is giving the error message invalid username/pwd?any way out-
and i am on NT.

[siroracle]

did u try the default password 'oracle' ?

[pando]

create a new password file if password 'oracle' doesnt work and cross the fingers ;)

[drishti]

how to create a new password file as oracle does not work,it is really confusing that on my test db I am being able to access user internal but not on real DB.

[pando]

The real DB needs security and your test DB I dont think so.
To create a new password file

orapwd file=$ORACLE_HOME/database/pwdSID.ora password=any_thing_you_want entries=10

[drishti]

hi pando,
if this donot have any adverse effects on my real DB.if this pwd will be my pwd to internal.anyway thanks for all u'r help.

[drishti]

hello pando,
I donot know if by recreating pwdfile I will do some wrong with my real DB.and if this pwd will be of internal's or what????

[pando]

well you wont don anything serious to your real database, anyway you better try with your test database beforehand just to make sure it works and you did it correctly

[drishti]

hi pando,i did it in test db,but U know in test DB its even not asking for a password,its taking as such .if I say connect internal/anything it gets connected ,is it because I set
remote_login_passwordfile=none in init.ora.
ok i will do the same to real db and let U know,

but do I need to call oracle customer support as ora-00600
say to call oracle customer support .
bye

[pando]

err set that parameter to shared otherwise there is no need of using a password file, Oracle is asking for a password file because that parameter is not set to NONE in your real database

[drishti]

thanks a lot pando for your help.it worked.
thanks a lot.

[pando]

welcome ;)