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!

Proposal for 12 database and Fusion Middle-ware.

idreesNov 3 2013 — edited Nov 4 2013

Dear all,

i am not sure that the question is relevant here or not, if not then please accept my sorry for that.

we are going to move to 12c database and fusion middle-ware from 10g database.

our head of department ask me to prepare a proposal for that so i ask and forward it to the top management.

i am wonder what should i include in that proposal?

thanks

This post has been answered by Alvaro on Nov 3 2013
Jump to Answer

Comments

Gary Graham-Oracle

I have not tested specifically on Linux, but it should behave the same as on Windows.  Basically...

0.  You must have a Java 8 JRE (public, standalone) or JDK installed.

1.  If PATH environment variable points to an Oracle client, SQLcl should automatically connect with OCI/Thick driver

2.  If not, then SQLcl connects with Thin driver.

Once connected, you can verify the connection type by running...

show connection

which will display something like...

CONNECTION

HR@jdbc:oracle:oci8:@ADC122PB

or...

CONNECTION:

HR@jdbc:oracle:thin:@(DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.mycompany.com)(PORT = 1521))    )    (CONNECT_DATA =

   (SERVICE_NAME = orcl.mycompany.com)    )  )

If it does not work on Linux as I describe above, then you can try passing the -oci flag when invoking SQLcl.

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

Post Details

Locked on Dec 2 2013
Added on Nov 3 2013
9 comments
448 views