Connectiong To Oracle Via KeepTool
NickName:user1023137 Ask DateTime:2013-07-20T00:03:20

Connectiong To Oracle Via KeepTool

I'm new to KeepTool and Oracle And I'm going to connect to my Oracle database on a remote server (Linux) from KeepTool in my Windows 7. It asks me to enter the Host:Port:SID to connect but it didn't work when I use the Linux server IP address or HostName specified in tnsNames.ora. Should I add the IP Address to tnsnames.ora? Would you please help me?

Regards

RS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = **linux-y29w.site**)(PORT = 1521))
    (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RS)))

Copyright Notice:Content Author:「user1023137」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/17750603/connectiong-to-oracle-via-keeptool

More about “Connectiong To Oracle Via KeepTool” related questions

Connectiong To Oracle Via KeepTool

I'm new to KeepTool and Oracle And I'm going to connect to my Oracle database on a remote server (Linux) from KeepTool in my Windows 7. It asks me to enter the Host:Port:SID to connect but it didn'...

Show Detail

SSRS subscription with Oracle data source

We have an SSRS with Oracle as data source. Creating report Works, but creating subscriptions doesn't. On the Data Source configuration page,i use Oracle internal user and enabled "Credentials st...

Show Detail

Login as SYS user to Oracle 11g from .NET

Using the Oracle Data Provider for .NET, my application connects to the database using the privileged SYS user. The connection string is as follows: Data Source=MyTnsName;User ID=sys;Password=

Show Detail

Oracle access via SSIS

In a server ex: 111.21.11.abc has oracle client. There is a oracle database. Now I am in a server ex: 222.21.44.xyz from where i want to access that oracle server via SSIS package. How can I do th...

Show Detail

connecting to oracle timesten via cx_oracle in sqlalchemy

I can connect to oracle via cx_Oracle in sqlalchemy by this connection string: connection_string = 'oracle+cx_oracle://user:[email protected]/orcl' and also i can connect TimesTen by cx_Oracle using...

Show Detail

Connecting to Oracle via Python (Spyder IDE)

I am having difficulty connecting Oracle via python (in Spyder). I am trying to import cx_Oracle , and get an error (No module named cx_Oracle) I have Python 3.7.0 installed I have downloaded cx_...

Show Detail

Connecting to Oracle via VBA

All, I am trying to connect to an oracle database via the Cloud through VBA. Below is my code. When I debug print my VBA after the variable "strConOracle" is set, the variable prints as below

Show Detail

Oracle Database Connection via SQLPLUS Oracle Client

I am not able to connect to remote Oracle Database connection via SQL Plus. below are more details. I have installed Oracle Client 10.2 I am able to connect to Oracle Database via SQLDeveloper.

Show Detail

Applying Oracle PL/SQL via JDBC

Is it possible to create/replace PL/SQL via the Oracle JDBC driver, i.e not via SQLPLus* ? Update 1: Driver: ojdbc14 (JDBC) Update 2: Change is being applied to oracle via Ant <SQL> task, w...

Show Detail

Oracle Database connection via SQLPLUS

I am trying to connect to my Oracle database from SQLPlus, but I'm not able to connect. I have Oracle client(10g) on my machine. Below are the details through which I am able to connect from my Java

Show Detail