Home » RDBMS Server » Server Administration » ORA-342 & ORA-312
ORA-342 & ORA-312 [message #274773] Wed, 17 October 2007 02:02 Go to next message
alok_personal
Messages: 4
Registered: October 2007
Location: Dehradun
Junior Member

Hi,

We have oracle 7 on machine. Our DBA just left and of
course the database died. Somehow I was elected to try and fix it, but
Im a software engineer, I know about oracle.but dont know like this problem...

When I run the startup script, I get the following:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.
Total System Global Area 959467680 bytes
Fixed Size 73888 bytes
Variable Size 138080256 bytes
Database Buffers 819200000 bytes
Redo Buffers 2113536 bytes
Database mounted.
ORA-00341: log 4 of thread 1, wrong log # 4 in header
ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/budget/redoG04M01.log'
SVRMGR>
Server Manager complete.

Database "budget" warm started.

But whenever I (or anyone else) tries to connect it says the database is
initializing or shutting down.

I tried recovering, which fails becuase of the ORA-00341/312 error. I
dont know how to reset the logs, or even if I did what the ramifications
of this are. I dont even know what GUI tools exist to help with
database maintenance, or how to run them.

Can anyone help out?
Thanks,
Alok
Re: ORA-00313 and ORA-00312 [message #274776 is a reply to message #274773] Wed, 17 October 2007 02:07 Go to previous messageGo to next message
alok_personal
Messages: 4
Registered: October 2007
Location: Dehradun
Junior Member

allow_resetlogs_corruption=TRUE (Beware this option may lead to loosing the entire DB)
------->
i simply edit it in inti.ora

i am also use this but oracle 7 display unrecognize command...
if possible then plz give me the proper solutionfor this....

i think if i recreate log file agine or update it i thik the problem is solved ..
but i am not able to do this...
help me out.
thxs
ALok
Re: ORA-00313 and ORA-00312 [message #274863 is a reply to message #274773] Wed, 17 October 2007 08:06 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
alok_personal wrote on Wed, 17 October 2007 03:02

Hi,
We have oracle 7 on machine.


then...

Quote:


When I run the startup script, I get the following:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production



Please clarify. In any event both version are desupported with V7 desupported in the last century. That may be the reason that
Quote:

Our DBA just left

[Updated on: Wed, 17 October 2007 08:10]

Report message to a moderator

Re: ORA-00313 and ORA-00312 [message #274867 is a reply to message #274863] Wed, 17 October 2007 08:32 Go to previous messageGo to next message
alok_personal
Messages: 4
Registered: October 2007
Location: Dehradun
Junior Member

Hi!!

i have face a a problem when i login in database oracle 7 . it shown following error

"ORA-00472: PMON process terminated with error"

plzzz send solution urgent .



thanks
Alok
Re: ORA-00313 and ORA-00312 [message #274868 is a reply to message #274863] Wed, 17 October 2007 08:34 Go to previous messageGo to next message
alok_personal
Messages: 4
Registered: October 2007
Location: Dehradun
Junior Member

Oracle7 i used
Re: ORA-00313 and ORA-00312 [message #274908 is a reply to message #274868] Wed, 17 October 2007 11:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

If it is PRODUCTION database then contact Oracle Support and MUST upgrade your database to atleast 10g Oracle Version.


Regards
Mohammed Taj
Re: ORA-00313 and ORA-00312 [message #274916 is a reply to message #274908] Wed, 17 October 2007 12:22 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
I would say you'd have to upgrade first before you contact support since Oracle has not provided support for that version since the 20th century.
Previous Topic: SYSAUX getting full
Next Topic: how to find most frequently accessed objects
Goto Forum:
  


Current Time: Wed Dec 07 07:07:18 CST 2016

Total time taken to generate the page: 0.05259 seconds