Can not create PSDB
Posted: Sun Jul 30, 2006 8:44 am
Client: Windows 2003 Server sp1
Server: Windows 2003 Server sp1, Oracle 10gR1
Oracle properly set up, with database STATWH configured and accessible via SQL*PLUS both from client and server machines. ProfileStage client, message switch and analysis server already installed on Client machine.
I now attempt to install a PSDB. The same error occurs whether the attempt is made on client or server machine. Here are the steps.
1. Choose ProfileStage from CD options.
2. Choose option to Create PSDB repository.
3. Provide identity of client machine as location of Message Switch.
4. Provide 3070 as TCP port number.
5. Provide default pathname for installation location.
6. Click Next> to start copying files.
7. Choose option Oracle on Windows to describe location of repository.
8. Click Yes on "Is client and server software installed?" message box.
9. Provide user ID, password and STATWH as repository user information.
10. Provide user ID and password as DBA information.
11. Provide pathname of oradata folder as data file path.
12. Click Yes to Create DSN for PSDB? message box.
13. Provide IP address of server and Oracle SID.
At this point a warning message box appears, containing the text "Can't find Oracle client installed"
This is a mystery, since the Oracle client IS installed, as evidenced by the fact that SQL*PLUS connectivity and Oracle Enterprise Manager connectivity can be achieved.
Can any one suggest what might be happening here and, if possible, a quick solution or workaround? TIA
Server: Windows 2003 Server sp1, Oracle 10gR1
Oracle properly set up, with database STATWH configured and accessible via SQL*PLUS both from client and server machines. ProfileStage client, message switch and analysis server already installed on Client machine.
I now attempt to install a PSDB. The same error occurs whether the attempt is made on client or server machine. Here are the steps.
1. Choose ProfileStage from CD options.
2. Choose option to Create PSDB repository.
3. Provide identity of client machine as location of Message Switch.
4. Provide 3070 as TCP port number.
5. Provide default pathname for installation location.
6. Click Next> to start copying files.
7. Choose option Oracle on Windows to describe location of repository.
8. Click Yes on "Is client and server software installed?" message box.
9. Provide user ID, password and STATWH as repository user information.
10. Provide user ID and password as DBA information.
11. Provide pathname of oradata folder as data file path.
12. Click Yes to Create DSN for PSDB? message box.
13. Provide IP address of server and Oracle SID.
At this point a warning message box appears, containing the text "Can't find Oracle client installed"
This is a mystery, since the Oracle client IS installed, as evidenced by the fact that SQL*PLUS connectivity and Oracle Enterprise Manager connectivity can be achieved.
Can any one suggest what might be happening here and, if possible, a quick solution or workaround? TIA