Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How can I configure DADS.conf for Multiple database in multiple Servers? (Oracle Application Server 10g, Oracle COmpanion CD 10g)
How can I configure DADS.conf for Multiple database in multiple Servers? [message #486987] Tue, 21 December 2010 22:58 Go to next message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Hi, I have been using Oracle Companion CD 10g as application server with Oracle Apex Application. In DADS.CONF file I have properly configured the required information and my Apex Application runs just fine. Database 10g r2 and Oracle Companion CD 10g is installed in different servers. In DADS.CONF it is configured to connect to the database server and SID. I need to create a development and production environment in different servers. Now can I configure to connect to multiple servers and databases keeping the same Application server? For example can I connect to different server and database depending on port number I choose? If so then where to configure? What is the prcedure? I am in crying need. Please help.

Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka, Bangladesh
Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487139 is a reply to message #486987] Thu, 23 December 2010 02:32 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
I'm guessing that when you say "Database 10g r2 and Oracle Companion CD 10g is installed in different servers" what you mean is that you have your database running on one machine, and your Apache web listener on another? Is that correct? And that you want to create a second DAD that will logon to a different database? If so, edit your dads.conf file to include a second database access descriptor that connects to the second database; just copy the existing DAD and make appropriate edits.
Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487284 is a reply to message #487139] Fri, 24 December 2010 10:18 Go to previous messageGo to next message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Here is my dads.conf file

----------------------------
Alias /i/ "D:\OraCompanion\Apache\Apache\images/"
AddType text/xml xbl
AddType text/x-component htc
<Location /pls/apex>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword APXPUBLIC
PlsqlDatabaseConnectString [database-server]:[port]:[sid]
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
</Location>
---------------------------------------
take a look at the PlsqlDatabaseConnectString item. Here only one connection string is mentioned, and default http port is 7777. Now can I mention another database connection string? if yes then where can I mention the http port? remember [port] in PlsqlDatabaseConnectString is TNSNAMES (1521) port. dont confuse with http port.

Regars

Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka Bangladesh
Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487289 is a reply to message #487284] Fri, 24 December 2010 10:51 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
As I said already, copy the DAD and make appropriate edits. The minimum changes would be to specify a different URI (such /pls/somethingelse ) and a different PlsDatabaseConnectString.

And by the way, I do know the difference between the http listener port and the database listener port. However, I am not sure that you know what a DAD is: it is defined with an opening tag

<Location /uri>

and ends with the tag

</Location>

And you might consider saying "thank you".
Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487322 is a reply to message #487289] Fri, 24 December 2010 22:11 Go to previous messageGo to next message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Hi thanks for your kind reply. You are correct, I am new in Application Server, Very recently I have known of DAD, httpd.conf etc still confused about proper configurations of these. In my oracle apex application I have two servers

1. database server(proddb-srv)
2. Oracle HTTP server (orahttp-svr)

url to access the application is http://orahttp-svr:7777/pl/apex/f?p=112:1

in DADs.conf file database connection string
PlsqlDatabaseConnectString proddb-srv:1521:proddb

Now my requirements is I will add another database server called devdb-svr for development environment.in DADs.conf file database connection string should look like
PlsqlDatabaseConnectString devdb-svr:1521:devdb

With the same application server can I connect to both database servers depending on some criteria.

may be url to access the application could look like http://orahttp-svr:7778/pl/apex/f?p=112:1

Please help, I am really confused.

Hasan Al Mamun

Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487339 is a reply to message #487322] Sat, 25 December 2010 04:13 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
Stop going on about different http listening ports, and do what I tell you: copy the existing DAD, and edit it. This is a dads.conf file that defines two DADs:
<Location /pls/orasso>
    SetHandler pls_handler
    Order deny,allow
    Allow from all
    AllowOverride None
    PlsqlDatabaseUsername orasso
    PlsqlDatabasePassword xxx
    PlsqlDatabaseConnectString infra-as.bplc.co.za:1521:inf
    PlsqlDefaultPage orasso.home
    PlsqlDocumentTablename orasso.wwdoc_document
    PlsqlDocumentPath docs
    PlsqlDocumentProcedure orasso.wwdoc_process.process_download
    PlsqlAuthenticationMode SingleSignOn
    PlsqlPathAlias url
    PlsqlPathAliasProcedure orasso.wwpth_api_alias.process_download
    PlsqlSessionCookieName orasso
</Location>
<Location /pub>
    SetHandler pls_handler
    Order deny,allow
    Allow from all
    AllowOverride None
    PlsqlDatabaseUsername pub
    PlsqlDatabasePassword xxx
    PlsqlDatabaseConnectString ebspub.bplc.co.za:1521:prd
    PlsqlDefaultPage pub.home
</Location>

The URL for the first DAD is
http://xxx.bplc.co.za:7777/pls/orasso
and the URL for the second DAD is
http://xxx.bplc.co.za:7777/pub
Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487366 is a reply to message #487339] Sat, 25 December 2010 22:26 Go to previous messageGo to next message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Hi, thanks for suggestions. I will definitely try it. And dont mind if I ask for your help in future.

Regards

Hasan Al Mamun
Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487414 is a reply to message #487366] Sun, 26 December 2010 22:51 Go to previous messageGo to next message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Dear John Watson thank you for your kind cooperation so far. I have one little question. In my senario, I have been granted only one app server which will have real-ip to launch to web. Here orahttp-svr has been assigned the IP. So it means to access my application I have to use orahttp-svr.domain.some only. and URL should be http://orahttp-svr:7777/pl/apex/f?p=112:1. But still I have to manage two database servers. In your example as far as I think both infra-as.bplc.co.za and ebspub.bplc.co.za have to have real IP to get access from web. Please suggest on the senario.

With best regards

Hasan AL Mamun

[Updated on: Sun, 26 December 2010 22:52]

Report message to a moderator

Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487433 is a reply to message #487414] Mon, 27 December 2010 01:34 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
I have told you already what to do, but your present level of knowledge means that you do not understand. May I suggest that you take some courses from Oracle University.

Now I have no idea what you are talking about. Perhaps someone else will be able to help you, I cannot.

Re: How can I configure DADS.conf for Multiple database in multiple Servers? [message #487682 is a reply to message #487433] Wed, 29 December 2010 22:37 Go to previous message
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
Member
Dear Mr. John Watson, Thank you so much for your help. I have tried your solution and it works. I am really sorry that I have asked so many irrelevant questions..actually I have never faced problems like this before and I am in a hurry in my office to do the job as soon as possible. May be that made me ask funny questions. However thank you for the solution, may be I will ask more questions in future (Dont get mad if they are dumb and funny).

with best regards

Hasan Al Mamun
Previous Topic: report server problem
Next Topic: REP-1847: Failed while trying to set up for printing
Goto Forum:
  


Current Time: Wed May 27 16:03:23 CDT 2020