Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
biapps 11.1.1.10.2 biapps rcu failed
Weblogic 10.3.6 , OBIEE 11.1.1.9.0 and ODI 11.1.1.9.0 have been installed on Windows 2012 R2.
Now, biapps repository need to be created on Oracle DB server, different environment, Oracle Linux 6.
Running rcu command line silent mode as following command
./rcu -silent -createRepository -connectString hostname:1521:dw -dbUser SYS -dbRole SYSDBA -schemaPrefix OBIA -component DW -component BIACOMP -component BIA_ODIREPO
After enter the full screen is cleared, entered sys password then our schema passwords then it prompt custom variable path.
it seems OK so far, but failed to read dump files and reverse the whole process.
error message on rcu.log file as
2016-07-23 18:29:45.900 NOTIFICATION rcu: oracle.biapps.rcu.dbinstall.DataPumpUtils::importSchema: importSchema done.
2016-07-23 18:29:45.900 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method: Excepton:
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)
at java.lang.Thread.run(Thread.java:662)
at oracle.sysman.assistants.rcu.backend.action.JavaAction.perform(JavaAction.java:164)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.biapps.rcu.dbinstall.DataPumpException: ORA-39211: unable to retrieve dumpfile information as specified
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4424
ORA-31640: unable to open dump file "/tmp/bi/rcu/rcu/integration/biapps/schema/obia_partitions.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at line 1
at oracle.biapps.rcu.dbinstall.DataPumpUtils.importSchema(DataPumpUtils.java:526)
at oracle.biapps.rcu.dbinstall.DataPumpUtils.importSchema(DataPumpUtils.java:466)
... 10 more
Caused by: java.sql.SQLException: ORA-39211: unable to retrieve dumpfile information as specified
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4424
ORA-31640: unable to open dump file "/tmp/bi/rcu/rcu/integration/biapps/schema/obia_partitions.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.biapps.rcu.dbinstall.DataPumpUtils.getDumpfileInfo(DataPumpUtils.java:206)
at oracle.biapps.rcu.dbinstall.DataPumpUtils.importSchema(DataPumpUtils.java:522)
... 11 more
It looks like privilege problem. Tried to fix it but not succeed.
Can any biapps expert can help me out, Please.
Many thanks in advance,
Roger
Answers
-
GIve some small path for the dmp files .It may help full importing smoothly while doing the rcu
Thanks
0 -
Hi Roger,
I performed a silent install of OBIA 11.1.1.10.2, and when I got to this stage, I used password file which was populated with not only passwords, but dmp file locations, and this worked for me.
Here was my rcu command call:
rcu -silent -createRepository -databaseType ORACLE -connectString $DB_CONNECT_STRING -dbUser $DB_USER -dbRole SYSDBA -schemaPrefix $DB_SCHEMA_PREFIX -component DW -component BIACOMP -component ODI -f < $RCU_PASSWORD_FILE
The RCU_PASSWORD FILE needs to be in the following format (7 lines):
<SYSDBA Account Password>
<DW Schema Password>
<obia.dmp or obia_partitions.dmp directory location on database server>
<BIACOMP Schema Password>
<obia_comp.dmp directory location on database server>
<ODIREPO Schema Password>
<obia_odi.dmp directory location on database server>
Hope this helps.
0 -
Hi Greg,
Very Good Morning to you.
Could you please paste the Password File content, how you have written the same.
Thanks & Regards,
Angshuman Roy
0 -
Hi Angshuman,
I wrote a series of blog entries about how to configure OBIA 11.1.1.10.2 a while back. As part of that blog series, I talk about installing OBIA silently and I post a link to the password file I used (which I put on GitHub). Here's the link to my blog entry:
Fusience Corporation - Business Intelligence
Hope this helps,
Greg
0