| Oracle Application Server Staging(BI Discoverer query) [message #430868] |
Thu, 12 November 2009 12:28 |
desi_bob02
Messages: 8
Registered: November 2009
Location: india
|
Junior Member |
|
|
Hello All,
I am in the process of Staging a Oracle Application server, i am following the following oracle guide:-
download-uk.oracle.com/docs/cd/B14099_19/core.1012/b13995/prodtest.htm
I am at step 6 of "Prerequisite Export Steps",i am new to BI Discoverer and Application server and had some doubts which i was hoping some one would please clarify.
Our production servver has Oracle10g(Data Warehouse) and Application Server 10g both running on the same machine, so there are 3 homes, OraHome(Oracle 10g home) , Infrahome and Midhome(AS Homes), the BI discoverer connects to the Oracle 10g and generates reports.
The step 6 states:-
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
For each EUL in the customer database, create a copy using the following command from the production environment:
PRODUCTION_MIDTIER_HOME/bin/eulapi -
connect old_eul_owner/password@database_service_name
-export /tmp/file1.eex -all -log /tmp/exp.log
If you intend to copy data to another customer database in the test environment, use the service name of the test database for database_service_name.
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
1) the statement 'use the service name of the test database for database_service_name' confuses me, i have a doubt if this means:-
a) the connect identifier of the my Oracle 10g(Data Warehouse) from were the reports are generated.
b) the connect identifier of my meta data repository
c) as the last line states " use the service name of the test database for database_service_name" how can i connect and export EUL from the produciton system if i give the database_service_name of the new test database
2) Also when i open BI discoverer on production i see a list of reports, when clicked these reports are executed and generate the output, i want to know if all these reports would be exported as well with the above command,
i am doubting this as the command says that the schemas are exported then how do i get all these reports in the new staged development environment.
When i open the BI Discover i see that i have 2 EUL's, the details of one of them reads as follows:-
Connect ToOracleBI Discoverer Connection Key acdd
User Name DW_1 Connection TypePublic
Database OraDW End User Layer DW_1
Locale English
3) I want to know if all the above settings will be replicated into the staged environment after following the document or i would have create them once the BI discovere is installed on the new machine.
Sorry for sounding stupid but i am quite new to AS and Discoverer world and would be really glad if someone could answer these questions as i have to run this query first thing in the morning.
Regards,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
