Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connecting to a database with PutTy

SoulbrodaOct 6 2013 — edited Oct 7 2013

Ok, I got this job with a company handling about 10 databases. I'm rather new using putty... How do I use putty to connect to one out of the 10 databases and how do I specify the exact one I want to connect to?

N.B: In windows, I know you type SET ORACLE_SID=Name_Of_Database... How does this work on linux?

Thanks in advance.

Comments

Kiran Pawar
Answer

Hi RichDBA,

RichDBA wrote:


I have an existing OHS install that's running a number of DAD's to connect to different databases all running Apex 4.2.  I'm looking to migrate to using ORDS on Tomcat.

I've tested deploying ORDS to Tomcat and connecting to a new default 11g XE install and all works fine, I'm comfortable with the process of running the ORDS install itself, but wondered if there's a document on MOS or somewhere similar on how to migrate an existing install, what pitfalls to look out for, what might need changing when using a different listener etc.

     You are changing the Web Tier of Oracle APEX and this will require nothing but proper configuration of Web Server with existing Oracle APEX installation.

I did read a thread on here that mentioned things like authentication might need changing when using the ORDS listener over OHS etc.

     Then mention that threads, and how do they resemble your authentication scheme issues.

As a side note, I'm aware that I can convert each of those DAD's to individual war files deployed to Tomcat by changing the war file name and using a different context root, or I can use mapping and set up each database on a single ORDS war install, there isn't much documentation about this, is there an Oracle recommended stance on this?

     With ORDS 2.0 (latest ORDS 3.0) you don't require to generate different ords.war for each DAD configuration. In this ORDS you can configure multiple databases and through URL mapping feature you can have multiple APEX instances listening to one Web Server.

     Refer :

     Hope this helps!

Regards,

Kiran

Marked as Answer by RichDBA · Sep 27 2020
RichDBA

Thanks Kiran, that's extremely helpful and answered my queries.

One small clarification then, I'm assuming as I'm only altering the web tier, that I can set up the ORDS listener to point to the DB and start using it in parallel with the OHS install that I have, and once I'm happy that it's working, just shutdown the OHS instance?

Kiran Pawar

Hi RichDBA,

RichDBA wrote:


One small clarification then, I'm assuming as I'm only altering the web tier, that I can set up the ORDS listener to point to the DB and start using it in parallel with the OHS install that I have, and once I'm happy that it's working, just shutdown the OHS instance?

     Yes, you can set up ORDS in parallel with OHS(If you are setting up OHS and ORDS on same server then just take care of the ports. They have to be different). While configuring ORDS you have to point to the correct DB where APEX is installed.

     Once, your APEX instance is stable and you are satisfied with ORDS configuration you can shutdown the OHS instance.

Regards,

Kiran

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 4 2013
Added on Oct 6 2013
5 comments
11,368 views