| rmjvm.sql errors [message #121757] |
Tue, 31 May 2005 18:55  |
oraclejunior
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
Hi,
I am running Oracle 8.1.7.4.1 on Windows 2000 and am trying to remove Java from it. When I run the rmjvm.sql script I get numerous messages of the following errors:
JVMRMACTION
--------------------------------
FULL_REMOVAL
initjvmaux.drp('drop role javauserpriv');
*
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00201: identifier 'INITJVMAUX.DRP' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
ORA-06550: line 4, column 1:
PLS-00201: identifier 'INITJVMAUX.DRP' must be declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
ORA-06550: line 5, column 1:
PLS-00201: identifier 'INITJVMAUX.DRP' must be declared
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored
Any help anyone has would be great. Thanks.
[Updated on: Wed, 01 June 2005 14:44] Report message to a moderator |
|
|
|
|
|
|
|
| Re: rmjvm.sql errors [message #122081 is a reply to message #122064] |
Thu, 02 June 2005 14:33  |
oraclejunior
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
Hi Mahesh,
When I run the sql "select count(*) from all_objects where object_type like 'JAVA%'" I get a count of 6497 returned. I am logged in as SYS and am trying to run the script from SQLPLUS through the command line interface by running the command "@rmjvm.sql" and starting SQLPLUS from the directory were the rmjvm.sql file is located (trying to give as much detail as I can here).
The reason I am trying to remove Java is because I believe it is causing our backups to fail. We have two other servers with similiar databases setup which don't return any counts of Java objects and the backups work fine. We recently had to rebuild the server that we are having the backup issues with and I think the Java objects must have been mistakenly installed with Oracle.
Thanks in advance for any help you or anyone else can provide.
|
|
|
|
| Re: rmjvm.sql errors [message #122082 is a reply to message #121757] |
Thu, 02 June 2005 14:36 |
oraclejunior
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
Hi Mahesh,
When I run the sql "select count(*) from all_objects where object_type like 'JAVA%'" I get a count of 6497 returned. I am logged in as SYS and am trying to run the script from SQLPLUS through the command line interface by running the command "@rmjvm.sql" and starting SQLPLUS from the directory were the rmjvm.sql file is located (trying to give as much detail as I can here).
The reason I am trying to remove Java is because I believe it is causing our backups to fail. We have two other servers with similiar databases setup which don't return any counts of Java objects and the backups work fine. We recently had to rebuild the server that we are having the backup issues with and I think the Java objects must have been mistakenly installed with Oracle.
Thanks in advance for any help you or anyone else can provide.
|
|
|
|
|
|
| Re: rmjvm.sql errors [message #122087 is a reply to message #121757] |
Thu, 02 June 2005 15:34 |
oraclejunior
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
This is the error we are getting when we try to do a full export of our database:
. . exporting table Z_ORDER 55 rows exported
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
Is the bug you speak of the same as refered to in posting 54205? I pasted the solution given in that post below. Is this the same bug/solution you are speaking of?
There is a known issue with the removal of JVM in version 8.1.6. It doesn't completely remove it. If you are using 8.1.6 do this:
To run the script correctly, you will need to edit the RMJVM.SQL script and change line
"call rmjvm.run(true)" to "execute rmjvm.run(true)".
On Oracle8i 8.1.6 for Windows NT, the file rmjvm.sql does NOT exists! Create the file rmjvm.sql containing the following:
set serveroutput on
variable jvmrmaction varchar2(30) execute :jvmrmaction := 'FULL_REMOVAL';
@@jvmrm
execute rmjvm.run(true);
Thanks a lot for your help!
|
|
|
|
|
|
| Re: rmjvm.sql errors [message #122185 is a reply to message #122089] |
Fri, 03 June 2005 10:56 |
oraclejunior
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
I tried running that and got the same errors on both the export and the rmjvm script. The backup is kicked off from a batch script on the server. The backup is setup the same way as our other Oracle DB servers, which don't have any issues. I'm pretty sure that if I remove the Java objects it will fix the issue. This is our only Oracle DB server that has the Java objects installed and is the only one that is failing.
Do you think it would be okay to run initjvm.sql overtop what is already there then try rmjvm.sql again?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
