Home » Developer & Programmer » Warehouse Builder » OWB installation->Orc 10g Express ,javaidpriv role error
OWB installation->Orc 10g Express ,javaidpriv role error [message #194761] Mon, 25 September 2006 03:03 Go to next message
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 Go to previous messageGo to next message
senthil29
Messages: 4
Registered: October 2006
Junior Member
u dont hav JAVAID,JAVASYS,JAVADeBUG privs.....
icon3.gif  Re: OWB installation->Orc 10g Express ,javaidpriv role error [message #202591 is a reply to message #194761] Fri, 10 November 2006 08:26 Go to previous messageGo to next message
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 \==--
Re: OWB installation->Orc 10g Express ,javaidpriv role error [message #239164 is a reply to message #202591] Mon, 21 May 2007 11:21 Go to previous message
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.





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


Current Time: Mon Dec 05 13:21:26 CST 2016

Total time taken to generate the page: 0.06278 seconds