Home » RDBMS Server » Server Utilities » SERVER CRASH
SERVER CRASH [message #151535] Thu, 15 December 2005 07:10 Go to next message
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
Member
Hi to all..
We have Oracle 9i Database server install on Operating System WINDOWS ADVANCE 2000 server.
Now the system has to be formatted due to some error(OS).
So when operating system reinstall then our DATABASE will be finished.
I did export system and two more schemas on which our application is based, but i am unable to connect to database as sysdba so the sys schema is not being exported.
If we create new database can we recover our system and other schemas by import facility.

Any other solution that please pass it on.

Waiting for reply......

Thanks
Karan.

Report message to a moderator

Re: SERVER CRASH [message #151537 is a reply to message #151535] Thu, 15 December 2005 07:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You do not need to 'recover' SYS/SYSTEM and other users.
Create a new database( sys /system etc will be created).
Precreate the tablespaces etc.
Precreate the users to be imported.
Do the import.
imp dba/user@newdb fromuser=OLDUSER touser=NEWUSER file=yourdumpfile.dmp

Report message to a moderator

Re: SERVER CRASH [message #151543 is a reply to message #151537] Thu, 15 December 2005 08:19 Go to previous messageGo to next message
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
Member
Thanks Mahaesh for reply.


"imp dba/user@newdb fromuser=OLDUSER touser=NEWUSER file=yourdumpfile.dmp"


Can 'fromuser' and 'olduser' be same as i have to create same user/schema.
How do i distinguish the new and the old user as both will have the same name.

Karan.

Report message to a moderator

Re: SERVER CRASH [message #151545 is a reply to message #151543] Thu, 15 December 2005 08:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It can be the same.
Search the forum for examples.

imp dba/user fromuser=scott touser=scott .....

Report message to a moderator

Re: SERVER CRASH [message #151552 is a reply to message #151545] Thu, 15 December 2005 09:12 Go to previous messageGo to next message
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
Member
Thanks Mahesh for your worth reply..

Karan.

Report message to a moderator

Re: SERVER CRASH [message #151560 is a reply to message #151535] Thu, 15 December 2005 09:38 Go to previous messageGo to next message
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
Member
Mahesh sorry for bother you again.
I am not being connected as sysdba in my database.

OS-Xp
Oracle 9i.
getting error while login as sysdba

>connect sys/karan as sysdba
ERROR
ORA-01031: insufficient privileges.

Waiting again for your reply.

Karan.

Report message to a moderator

Re: SERVER CRASH [message #151569 is a reply to message #151560] Thu, 15 December 2005 12:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is very generic error. It may be anything.
May be you did not set ORACLE_SID.
May be you have all the unwanted entries in sqlnet.ora.
May be your pwdfile is corrupt.

Report message to a moderator

Re: SERVER CRASH [message #151697 is a reply to message #151535] Sun, 18 December 2005 05:53 Go to previous message
karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai
Member
On my PC i installed Oracle 9i and Oracle forms 6i. tool.
Now when i tried to connect as sysdba from form6i builders
SQL Plus 8.0 it gave error that
###########################################
SQL> connect sys/dba as sysdba
ERROR:
ORA-01031: insufficient privileges
###########################################

While SQL version of oracle 9i connect me as sysdba.

BUT WHEN I CONNECT BOTH ON SQL Plus 8.0 and oracle 9i SQL version
with user SCOTT or other except SYS who has sysdba privilege then,
i found my screen as########################################
SQL*Plus: Release 9.0.1.0.1 - Production on Sat Dec 17 10:31:48 2005

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-06553: PLS-213: package STANDARD not accessible


ERROR:
ORA-06553: PLS-213: package STANDARD not accessible


Error accessing package DBMS_APPLICATION_INFO

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

SQL>
##########################################
_______________________________________________________________
THIS message i found when I do export utility from command prompt AS

C:\>EXP SYSTEM/MANAGER@DB OWNER=SCOTT DIRECT=Y
OR
C:\>EXP USER=SCOTT/TIGER FULL=Y DIRECT=Y_______________________________________________________________________
ORA-06553: PLS-213: package STANDARD not accessible
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.sche
ma_info_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-213: package STANDARD not accessible
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schem
a_info_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-213: package STANDARD not accessible
EXP-00083: The previous problem occurred when calling SYS.DBMS_TRANSFORM_EXIMP.sche
ma_info_exp
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-213: package STANDARD not accessible
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info
_exp
. exporting foreign function library names for user SCOTT
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Direct Path ...
. . exporting table BONUS
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-213: package STANDARD not accessible
. . exporting table DEPT
EXP-00008: ORACLE error 1036 encountered
ORA-01036: illegal variable name/number
. . exporting table EMP
EXP-00008: ORACLE error 1036 encountered
ORA-01036: illegal variable name/number
. . exporting table NEW
EXP-00008: ORACLE error 1036 encountered
ORA-01036: illegal variable name/number
. . exporting table SALGRADE
EXP-00008: ORACLE error 1036 encountered
ORA-01036: illegal variable name/number
. exporting synonyms
EXP-00008: ORACLE error 4052 encountered
ORA-04052: error occurred when looking up remote object
EXP-00000: Export terminated unsuccessfully


Any solution for this ?
Waiting for reply....

Thanks
Karan

Report message to a moderator

Previous Topic: Resolving Field in data file exceeds maximum length error
Next Topic: Export error ...........
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 06:09:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.