OraFAQ Forum: Data Integration » OWB installation->Orc 10g Express ,javaidpriv role error

Home » Developer & Programmer » Data Integration » OWB installation->Orc 10g Express ,javaidpriv role error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OWB installation->Orc 10g Express ,javaidpriv role error [message #194761]

Mon, 25 September 2006 03:03

mymot
Messages: 225
Registered: July 2005

Senior Member

Hi,

os : WIN XP Home
DB : oracle 10g express edition
Application : OWB

I am getting below error while creating repository owner,user etc using
Repository Assistant. I have also granted "create role to new user" but no luck.

Error message :

==========================================================
main.TaskScheduler timer[5]20060925@17:31:57.057: 00> 
oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:391):
   url = 
(DESCRIPTION=(ADDRESS=(HOST=LOCALHOST)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SE
RVICE_NAME=XE)))
main.TaskScheduler timer[5]20060925@17:31:57.057: 00> 
oracle.wh.service.impl.assistant.DatabaseEngine.display(DatabaseEngine.java:391):
 [getSysConnection]....
main.TaskScheduler timer[5]20060925@17:31:57.057: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:8
16):  parseSqlFile() ======= enter file: ../../rtasst/platform_system_rights.sql
main.TaskScheduler timer[5]20060925@17:31:58.058: 00> 
oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1409): 
 fileName is ../../rtasst/platform_system_rights.sql
main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529): java.sql.SQLException: ORA-01919: role 'JAVAIDPRIV' does not exist
main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168
)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:161
4)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:520)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.wh.service.impl.assistant.ProcessEngine.processSQLDBAToken(ProcessEngine.j
ava:1136)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.wh.service.impl.assistant.ProcessEngine.processFileTokens(ProcessEngine.ja
va:573)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.wh.service.impl.assistant.ProcessEngine.createOWBRepository(ProcessEngine.
java:269)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at 
oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition$4.runTask(Assist
antWizardDefinition.java:541)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.ewt.timer.Timer.doRun(Unknown Source)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at oracle.ewt.timer.Timer.run(Unknown Source)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.j
ava:529)+>    at java.lang.Thread.run(Thread.java:534)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:8
16): java.sql.SQLException: ORA-01919: role 'JAVAIDPRIV' does not exist
main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.RuntimeInstaller.display(RuntimeInstaller.java:8
16)+> [ at runSqlScript(RuntimeInstaller.java ) ].
main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.ProcessEngine.processSQLDBAToken(ProcessEngine.j
ava:1140): java.sql.SQLException: ORA-01919: role 'JAVAIDPRIV' does not exist
main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.ProcessEngine.processSQLDBAToken(ProcessEngine.j
ava:1140)+>    at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.ProcessEngine.processSQLDBAToken(ProcessEngine.j
ava:1140)+>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.ProcessEngine.processSQLDBAToken(ProcessEngine.j
ava:1140)+>    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

main.TaskScheduler timer[5]20060925@17:31:59.059: 00> 
oracle.wh.service.impl.assistant.ProcessEngine.processSQLDBAToken(ProcessEngine.j
ava:1140)+>    at

=============================================

Thanks

[Updated on: Mon, 25 September 2006 03:11]

Report message to a moderator

Re: OWB installation->Orc 10g Express ,javaidpriv role error [message #198288 is a reply to message #194761]

Mon, 16 October 2006 07:25

senthil29
Messages: 4
Registered: October 2006

Junior Member

u dont hav JAVAID,JAVASYS,JAVADeBUG privs.....

Report message to a moderator

Re: OWB installation->Orc 10g Express ,javaidpriv role error [message #202591 is a reply to message #194761]

Fri, 10 November 2006 08:26

ukuechle
Messages: 9
Registered: June 2005

Junior Member

Hi mymot,

Do you have the JVM and XDK installed and is the XDK loaded into the JServer?
If not --> RTFM or in a very short form:

- set java_pool_size >= 150M
- set shared_pool_size >= 150M
- have 150MB free space in tablespace SYSTEM
- shutdown and restart your instance
- run
SQL> @?/javavm/install/rmjvm
SQL> shutdown immediate
SQL> startup
SQL> @?/javavm/install/initjvm
SQL> @?/xdk/admin/initxml
SQL> @?/xdk/admin/xmlja
SQL> @?/rdbms/admin/catjava

Don't forget to drop the repository owner and all 'OWB%'-roles, if they had been created by a former installation process.
Then try again. Good luck! Cool

--==/ Uwe \==--

Report message to a moderator

Re: OWB installation->Orc 10g Express ,javaidpriv role error [message #239164 is a reply to message #202591]

Mon, 21 May 2007 11:21

raj1shah
Messages: 3
Registered: May 2007

Junior Member

Thanks for the help.

I ran into the same problem,
ORA-01919: role ‘JAVAIDPRIV’ does not exist

I checked the log file under ORACLE_HOME\owbUnifiedRepos\log ...
and found error in file
enter file: ../../rtasst/platform_system_rights.sql as

oracle.wh.service.impl.assistant.ProcessEngine.display(ProcessEngine.java:1409):
fileName is ../../rtasst/platform_system_rights.sql
main.TaskScheduler timer[5]20070518@13:51:34.034: 00>
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.java:529
): java.sql.SQLException: ORA-01919: role 'JAVAIDPRIV' does not exist
main.TaskScheduler timer[5]20070518@13:51:34.034: 00>
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.java:529
)+> at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)main.TaskSched
uler timer[5]20070518@13:51:34.034: 00>
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.java:529
)+> at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)main.TaskScheduler
timer[5]20070518@13:51:34.034: 00>
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.java:529
)+> at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)main.TaskScheduler
timer[5]20070518@13:51:34.034: 00>
oracle.wh.service.impl.assistant.RuntimeInstaller.runSqlScript(RuntimeInstaller.java:529

Attached is image of the actual Oracle SQL code that caused the error.

I am using Solaris, so did not set the parameters
- set java_pool_size >= 150M
- set shared_pool_size >= 150M
since Solaris allocates memory pool dynamically.

I compelted the steps identified to remove and re-install JVM
1. SQL> @?/javavm/install/rmjvm
2. SQL> shutdown immediate
3. SQL> startup
4. SQL> @?/javavm/install/initjvm
5. SQL> @?/xdk/admin/initxml
6. SQL> @?/xdk/admin/xmlja
7. SQL> @?/rdbms/admin/catjava

but on step 4, I am getting
ORA-29558: JAccelerator (NCOMP) not installed. (also shown in attached ifle)

Can I ignore this safely?

In the process of deleting, OWBRepos Owner the OWB Repository Assistant could not find any owner either.

Now, I am in th eprocess of creating new Repos Owner.

Attachment: OraFAQ OWB JVM Issue.doc
(Size: 100.00KB, Downloaded 3349 times)

Report message to a moderator

Previous Topic:	any good books on informatica?
Next Topic:	How to preserve the links while reconciling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 19 06:17:34 CST 2024