SQL> select name from v$services;
NAME
----------------------------------------------------------------
bidb
orabidbXDB
orabidb
SYS$BACKGROUND
SYS$USERS
Password is devmanager
Install JDK on windows BI apps server
Java should be install on c:\java
And diffident on path
java -jar fmw_12.2.1.0.0_infrastructure.jar
Go to the directory :
D:\BI_Software\fmw_12.2.1.0.0_bi_windows64_Disk1_1of2
Run the installer
Run config.cmd
Now install Oracle BI Clinet Home should be D:\Oracle\obiee12c-client-tool
Now Data Integrator 12c Home should be different D:\Oracle\Middleware\ODI_HOME
NOW RUN RCU:
From the ODI Studio menu, select File, then select New.
On the New gallery screen, select Create a New ODI Repository Login, then click OK.
jdbc:oracle:thin:@PBAD-BIDEVDB.pbad.sbg.com.sa:1539/bidb
than okay.
Than connect to repository ICON, and provide wallet password “wallet123”
Configuring the Domain
CD D:\Oracle\Middleware\Oracle_Home\ODI12c_HOME\oracle_common\common\bin>
Press Create.
D:\Oracle\Middleware\Oracle_Home\ODI12c_HOME\user_projects\domains\base_domain\bin>agent.c
md -NAME=OracleDIAgent1 -PORT=20910
Picked up _JAVA_OPTIONS: -Xmx512M
2016-01-27 15:43:42.436 NOTIFICATION New data source:
[DEV1_ODI_REPO/*******@jdbc:oracle:thin:@//PBAD-BIDEVDB.pbad.sbg.com.sa:1539/BIDB]
2016-01-27 15:43:43.796:INFO::main: Logging initialized @5295ms
2016-01-27 15:43:44.796 NOTIFICATION ODI-1128 Agent OracleDIAgent1 is starting. Container:
STANDALONE. Agent Version: 12.2.1. Port: 20910. JMX Port: 21910.
2016-01-27 15:43:44.796:INFO:oejs.Server:main: jetty-9.2.2.v20140723
2016-01-27 15:43:44.921:INFO:oejw.StandardDescriptorProcessor:main: NO JSP Support for
/oraclediagent, did not find org.apache.jasper.servlet.JspServlet
2016-01-27 15:43:47.296:INFO:/oraclediagent:main: Initializing Spring root WebApplicationContext
Allowing : 127.0.0.1,10.100.224.93,127.0.0.1
2016-01-27 15:43:48.936 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:49.155 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:49.390 NOTIFICATION New data source:
[DEV1_ODI_REPO/*******@jdbc:oracle:thin:@(description=(address=(host=PBAD-
BIDEVDB.pbad.sbg.com.sa)(protocol=tcp)(port=1539))(connect_data=(service
_name=BIDB)(server=dedicated)))]
2016-01-27 15:43:49.718 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:49.749 NOTIFICATION ODI-1111 Agent OracleDIAgent1 started. Agent version: 12.2.1.
Port: 20910. JMX Port: 21910.
2016-01-27 15:43:49.749 NOTIFICATION ODI-1136 Starting Schedulers on Agent OracleDIAgent1.
2016-01-27 15:43:49.749:INFO:oejsh.ContextHandler:main: Started
o.o.@749ffdc7{/oraclediagent,file:/D:/Oracle/Middleware/Oracle_Home/ODI12c_HOME/user_projects/
domains/base_domain/system_components/ODI/
OracleDIAgent1/work/webapp/,AVAILABLE}
{file:/D:/Oracle/Middleware/Oracle_Home/ODI12c_HOME/odi/agent/lib/./oraclediagent.war}
2016-01-27 15:43:49.765:INFO:oejs.ServerConnector:main: Started
ServerConnector@2f96e49f{HTTP/1.1}{10.100.224.93:20910}
2016-01-27 15:43:49.765:INFO:oejs.Server:main: Started @11275ms
2016-01-27 15:43:49.796 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:50.015 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:50.077 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:50.311 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:43:50.390 NOTIFICATION ODI-1137 Scheduler started for work repository WORKREP on
Agent OracleDIAgent1.
2016-01-27 15:44:00.302 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:44:00.599 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:44:00.630 NOTIFICATION Successfully set the current thread authentication
2016-01-27 15:44:10.365 NOTIFICATION Successfully set the current thread authentication