| SERVER CRASH [message #151535] |
Thu, 15 December 2005 07:10  |
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.
|
|
|
|
|
|
| Re: SERVER CRASH [message #151543 is a reply to message #151537] |
Thu, 15 December 2005 08:19  |
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.
|
|
|
|
|
|
|
|
| Re: SERVER CRASH [message #151560 is a reply to message #151535] |
Thu, 15 December 2005 09:38 |
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.
|
|
|
|
|
|
| Re: SERVER CRASH [message #151697 is a reply to message #151535] |
Sun, 18 December 2005 05:53 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
