KEMBAR78
SQL Select Name From V$Services Name - Bidb Orabidbxdb Orabidb Sys$Background Sys$Users | PDF | Oracle Corporation | Java (Programming Language)
0% found this document useful (0 votes)
113 views42 pages

SQL Select Name From V$Services Name - Bidb Orabidbxdb Orabidb Sys$Background Sys$Users

This document contains log output from starting an Oracle Data Integrator (ODI) agent. It shows the agent starting up and initializing, loading the data source, and starting the scheduler. Key details include: - The agent is starting on port 20910 and is named OracleDIAgent1. - It loads the data source DEV1_ODI_REPO connecting to the BIDB database on the given host and port. - The agent and scheduler start successfully.

Uploaded by

Danish Majid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
113 views42 pages

SQL Select Name From V$Services Name - Bidb Orabidbxdb Orabidb Sys$Background Sys$Users

This document contains log output from starting an Oracle Data Integrator (ODI) agent. It shows the agent starting up and initializing, loading the data source, and starting the scheduler. Key details include: - The agent is starting on port 20910 and is named OracleDIAgent1. - It loads the data source DEV1_ODI_REPO connecting to the BIDB database on the given host and port. - The agent and scheduler start successfully.

Uploaded by

Danish Majid
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 42

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

You might also like