Home » RDBMS Server » Server Administration » Error Creating Database using DBCA Oracle 11 g r2 (Oracle 11g r2 + rollup patch 6 on Windows 2008 R2 running on VMWARE)
Error Creating Database using DBCA Oracle 11 g r2 [message #483127] Thu, 18 November 2010 10:57 Go to next message
Jon Howes
Messages: 2
Registered: November 2010
Location: Wales
Junior Member
This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6

I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.

during the database creation I got an error as the system was adding the JVM that read:-

ORA-01927:cannot REVOKE privileges you did not grant.

I was given the options to ignore or abort

I chose to ignore the error and continue.

After the database creation completed I looked in the jserver log copied below and found two errors

Has anyone else come across these errors or have any idea what may have caused them ?

I did not get the same error before installing patch set 6

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv
create role javauserpriv
grant javauserpriv to sys
drop role javaidpriv
create role javaidpriv
grant javaidpriv to sys
drop role javasyspriv
create role javasyspriv
grant javasyspriv to sys
grant javauserpriv to javasyspriv
drop role javadebugpriv
create role javadebugpriv
drop role ejbclient
create role ejbclient
drop role jmxserver
create role jmxserver
grant jmxserver to sys
create or replace java system
revoke execute on "oracle/aurora/vm/HotLoader" from public
drop public synonym javasnm
19618
FULL_REMOVAL

drop package dbms_java
drop PUBLIC SYNONYM dbms_java
drop FUNCTION dbj_long_name
drop function "NameFromLastDDL"
drop PUBLIC SYNONYM "NameFromLastDDL"
drop FUNCTION dbj_short_name
drop PUBLIC SYNONYM dbj_short_name
foo
drop public synonym get_error$
FULL_REMOVAL

drop TABLE java$policy$shared$table
drop ROLE java_deploy
drop TABLE java$policy$
drop SEQUENCE java$policy$sequence$
drop VIEW dba_java_policy
drop PUBLIC SYNONYM dba_java_policy
drop VIEW user_java_policy
drop PUBLIC SYNONYM user_java_policy
drop ROLE java_admin
delete from obj$ where type#=56 and name like 'JAVA$POLICY$SHARED$%'


insert into java$policy$
values( 0, 0,
0, 'java.lang.RuntimePermission', 'createClassLoader', null,
2, java$policy$sequence$.nextval )



insert into java$policy$
values( 0, 1,
0, 'java.util.PropertyPermission', '*', 'read',
2, java$policy$sequence$.nextval )

create role java_deploy

create table java$policy$shared$table (version number)

FULL_REMOVAL

drop package JAVA_XA
drop PUBLIC SYNONYM JAVA_XA
No errors.
No errors.
revoke execute on sys.dbms_jvm_exp_perms from PUBLIC
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant


drop sequence java$prefs$seq$
drop table java$prefs$
1
NONE
NONE

NONE

NONE

NONE

NONE

NONE

revoke execute on "oracle/aurora/util/Wrapper" from public
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist


No errors.
No errors.
No errors.
No errors.






No errors.
No errors.
No errors.

No errors.
.. creating EXFSYS user
.. loading the Expression Filter Java library
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
.. creating Expression Filter dictionary
.. creating Expression Filter PL/SQL Package Specifications
No errors.
.. creating Expression Filter catalog views
.. creating Expression Filter private package in SYS schema
.. installing Expression Filter APIs
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
.. creating System Triggers for Expression Filter management
No errors.
.. installing Expression Filter indextype and operators
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.
No errors.

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Re: Error Creating Database using DBCA Oracle 11 g r2 [message #483136 is a reply to message #483127] Thu, 18 November 2010 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
These errors do not matter.
It tries to revoke something, so the purpose is that they no more exist, they already do not exist, so it is fine.

Regards
Michel
Re: Error Creating Database using DBCA Oracle 11 g r2 [message #483519 is a reply to message #483136] Mon, 22 November 2010 11:18 Go to previous message
Jon Howes
Messages: 2
Registered: November 2010
Location: Wales
Junior Member
Thanks Michel
Previous Topic: Migration of Oracle Jobs
Next Topic: Apply oracle patch 10.2.0.5
Goto Forum:
  


Current Time: Sun Dec 01 13:05:41 CST 2024