[Bulk] Running PH and Database on different servers

[Ken Langendock]

Maybe you can set variables at the OS level and use them with this code in
the dictionary


In windows I do this:

 

REM Setup Oracle Database Location (defined in tnsnames.ora)

set ORACLE_SID=XE

 

REM Setup Oracle Database User/Password (Login name in Database)

set ORDBUSER=mydbuser

set ORDBPASS=mypassword

 

DATABASE SYSTEMDB &

  Type ORACLE &

  NULL VALUES NOT ALLOWED & ; NEVER set this to ALLOWED!!!

  Owner SYSTEM & ; cannot be a variable!!!

  OPEN "ORACLE@%ORDBUSER%@%ORACLE_SID%/%ORDBPASS%"

 

 

Other than this, I think you are dead in the water on this one.

Tell your infra structure guy you need to start using application security
and allow access to the database the way it was meant to be done with PH.
Via one user/password in the dictionary.

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Birkmose, Anders
Sent: June 16, 2010 9:50 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] Running PH and Database on different servers

 

Hi all, 

 

For infra structure reasons we have been ask to separate our PH application
and ORACLE Database into two different Linux Redhat servers. 

But there is still a requirement that each User most connect to the ORACLE
Database via PowerHouse with their own user/password.  

 

Currently  we are running on one AIX server, so we uses the OPS$ option from
ORACLE, where the user automatically are granted access, 

as long as they are locally login to the AIX server. 

 

So our issue is, how do we connect via the PH Dictionary to the from PH
application server to another database server, when each user most have
their own user/password in the database. 

 

We don’t want the user to type in user/password each time they should attach
to the database. The users also starts a lot of background job, running in
the own Shells, so where it will not be possible for them to type database
user/password. 

 

One top of everything, we have also been ask to implement AD (Active
Directory), but that is another issue, which brings up a lot of other
challenges.  Right now our focus is on splitting the application and
Database, and still have the users there own database user. 

 

Any suggestion will be appreciated . 

 

Many regards 

Anders 

 


Please help Logica to respect the environment by not printing this email /
Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen
Sie so Logica dabei, die Umwelt zu schützen. / Por favor ajude a Logica a
respeitar o ambiente não imprimindo este correio electrónico. This e-mail
and any attachment is for authorised use by the intended recipient(s) only.
It may contain proprietary material, confidential information and/or be
subject to legal privilege. It should not be copied, disclosed to, retained
or used by, any other party. If you are not an intended recipient then
please promptly delete this e-mail and any attachment and all copies and
inform the sender. Thank you. 

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.829 / Virus Database: 271.1.1/2940 - Release Date: 06/16/10
02:35:00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100616/38b47ea0/attachment.htm