Client Tools :: Cannot Connect Using JDBC Oracle Thin Client With (New Method)?

Feb 21, 2013

The problem is that this connection errors when I try to connect using my SQuirreL client. My developers want to connecting using the SID or the SERVICE_NAME and by using the "New Method" syntax, not the "Old Method" syntax. According to the documentation the "New Method" syntax works with the SERVICE_NAME or the SID. The "Old Method" only works with the SID.

# Host name is vmwwin7634.na.SAS.com
# SID is sting2
# SERVICE_NAME is sting2.na.sas.com

PROBLEM using SID errors ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2
THIS WORKS using SERVICE_NAME ==> jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com

I am using SQuirreL Client version 3.4.0

# Here is the tnsnames.ora entry on the server.
STING2 =
(DESCRIPTION =

[code]...

# In this documentation it says, "On new syntax SERVICE may be a oracle service name or a SID."You can find this on the orafax wiki under JDBC#Thin_driver.

# I was able to connect with the "old method" using the SID only, SERVICE_NAME errors jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2.na.sas.com
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521:sting2 (this works)

# "New Method"
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2.na.sas.com (this works)
jdbc:oracle:thin:@vmwwin7634.na.SAS.com:1521/sting2 (this errors)
(SQuirreL client error, "Unexpected Error occurred attempting to open an SQL connection.")

View 10 Replies


ADVERTISEMENT

Client Tools :: How To Connect From Client To Oracle Database In Unix

Dec 11, 2012

I have new virtual UNIX machine and I installed oracle client on /usr/lib/oracle. Also I have a oracle database and I am able to connect to this database from my desktop sql developer.

So now I am trying to connect from new UNIX machine. Where I created tnsnames.ora file under /usr/lib/oracle/network/admin and before connecting did export the following

export TNS_ADMIN=/usr/lib/oracle/network/admin
export ORACLE_HOME=/usr/lib/oracle/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:/sbin:$ORACLE_HOME/bin
export ORACLE_SID=VFIODSD1

when I try

# sqlplus
username :xxxxxxx
password : xxxxxxx

ORA-12545: Connect failed because target host or object does not exist. Not sure what I missed here. using same tns file I am able to connect from sql developer on windows.

View 1 Replies View Related

Client Tools :: How To Set Connection Property Oracle.jdbc.thinLogonCapability

Sep 25, 2013

how to set connection property "oracle.jdbc.thinLogonCapability"

View 3 Replies View Related

Client Tools :: How To Connect To Oracle 7 Using Client

Dec 15, 2011

I have Oracle 7 database on Server1. I need to connect this using Oracle client from windows XP.

I have downloaded Oracle client 3.0 and when I am trying to connect it saying "Unable to connect: Unsupported Oracle version".

View 8 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Client Tools :: Connect From Oracle 9i To Sql Developer?

Aug 30, 2011

how i can add new connection to sql developer i had made a database name abb how i will connect that to sql developer.

View 12 Replies View Related

Client Tools :: TOAD 8.6 And Oracle 10g - Cannot Connect?

Feb 22, 2012

I have TOAD 8.6 installed and hoping to use with Oracle 10g databases. I have SQL Navigator also - it works fine. However TOAD does not. Open up TOAD and see the TNS dropdown, select a database and try to log in - click on Connect and the little SQL hour glass comes on, goes off - there is no error, no message and no connection. I have tried several databases and again, SQLPlus, SQL Navigator are both working fine.

View 2 Replies View Related

Client Tools :: Unable To Connect To Oracle From Toad

Jul 28, 2010

I installed Oracle 10g XE and Toad 10.5 in my home system.I am able to connect to Oracle from Oracle XE homepage and XE SQL command line but when I try to connect to Oracle from toad 10.5 I am getting the error 'TNS: could not resolve the connect identifier specified (XE)'.From toad I tried direct and TNS options but it did not work. My tns ora file looks like below.

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Anu-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

TNS_ADMIN variable has correct parameter and Toad is directing the correct TNS file. I tried changing hostname with my system's ip but still I am unable to connect to Oracle from Toad.

View 18 Replies View Related

Client Tools :: Connect With Sqlplus Or Toad - Unable To Initialize Oracle Call Interface

Sep 6, 2012

when i try to connect with sqlplus or toad then i get an error

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Users>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
C:Users>

and i want to tell what i do before it-my all files were be converted in .FLT then i shorted out this problem after that when i tried to connect with sqlplus or toad then i get above error.and i have restarted my system but throwing same error.

i am using oracle 11.2.0.1 on windows 7

View 5 Replies View Related

Client Tools :: Able To Connect From SQL-Assistant BUT Unable To Connect From SQL Developer

Jul 7, 2012

I have been troubling with this issue for the last two weeks...tried so much, but could not able to resolve....

sqlplus username/password@IPAddress:port/ServiceName

I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.

View 3 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

View 1 Replies View Related

Client Tools :: Install Oracle To Get Latest SQL Plus Working On Client PC

Jul 11, 2012

I need to install Oracle client to get latest sql plus working on client pc as the problem is, i am not able to find out where i can download this , i just need the sql plus as i am not able use many commands because when i installed oracle forms 6i client tool , sql plus 8.0 got installed.

View 4 Replies View Related

Client Tools :: ODBC Instant Client Oracle 10g

Jun 28, 2010

The version is Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi. for Unix AIX 5

I install the ODBC Driver Manager, Basic Instant Client, ODBC Instant Client packages (libsqora.so, odbc_update_ini.sh).

The error:

[oracle@d4 oracle] $ isql OracleODBC-10g user passtemp -v
[01000][unixODBC][Driver Manager]Can't open lib '/home/oracle/instantclient_10_2/libsqora.so' : file not found
[ISQL]ERROR: Could not SQLConnect

Configuration

odbcinst.ini
[Oracle10gODBCdriver]
Description = Oracle ODBC driver for Oracle 10g
Driver = /u01/app/oracle/product/10.2.0/db_1/lib/libsqora.so
Setup =
FileUsage =
CPTimeout =
CPReuse =

The documentation explic with exists the file libsqora.so.10.1 but not exists in the ODBC Instant Client packages.

I applied ln -s libsqora.so.10.1 libsqora.so but the connection not function

odbc.ini
[oradns]
Application Attributes=T
Attributes=W
BatchAutocommitMode=IfAllSuccessful
CloseCursor=T
[code].......

View 1 Replies View Related

Client Tools :: How To Connect To Sql Plus

Nov 18, 2010

I have to connect to sql*plus to get explain plan.When I conect in Toad, the credentials are as:-
User/schema :- TestDb
Password :- TestDb

Under direct tab:-
Host :- 172.17.252.96 Port :- 1521

Service Name :- xe

I am not able to connect to sql*plus using:-

Username :- TestDb
Password :- TestDb
Host String :- 172.17.252.96

Not sure how to login when I have IP address

I also tried login as:-

Username :- TestDb
Password :- TestDb
Host String :- xe

View 5 Replies View Related

Client Tools :: Cannot Connect To Isql Plus?

Feb 28, 2010

I am using oracle 10 g on my pc .i have no issues while working on it but whenever i am not connected to the internet its says failed to connect.As most of the time i am not connected to the internet the isql plus browser would show the same error but the moment i connect to the inet,it works.

Is it that 10g isql plus wont work while not connected to internet ?

View 3 Replies View Related

Client Tools :: Identify Oracle Client

Oct 3, 2011

I would like to know if there is some specific file who identifies the installation of Oracle Client in some machine.

View 4 Replies View Related

Client Tools :: Unable To Connect To Database?

Oct 4, 2013

I am getting error in my database....

SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

I tried shutdown and startup

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted

[code]....

ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>

View 1 Replies View Related

Client Tools :: Error When Trying To Connect Sybase Through SQL Developer

Nov 17, 2012

I am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter

View 1 Replies View Related

Client Tools :: UNIX User In Group Dba But Cannot Connect As SYS?

Jun 4, 2012

> id -a
uid=56088(appadm) gid=50120(dba) groups=50120(dba)
> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 4 09:26:23 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12545: Connect failed because target host or object does not exist

Enter user-name: ^C

our UNIX user in group "dba" but can't connect as SYS

why?

View 9 Replies View Related

Client Tools :: Connect Database On Unix And Windows

Jun 24, 2013

How I can connect database on unix OS and windows what is the deference.

View 7 Replies View Related

Client Tools :: Connect To Mssql Express 2008

Jan 29, 2011

I have installed and loaded a mssql express database on my pc for migration testing. When I test a connection from sql developer 3 receive "Failure -Test failed Cannot connect to Microsoft SQL Server on localhost. I am using windows authentication and SQL Server authentication and the default port 1433.

View 5 Replies View Related

Client Tools :: ORA-12154 / TNS - Could Not Resolve Connect Identifier Specified

Nov 21, 2012

I'm not able to login to PL/SQL Developer 7.0.3.1123.I'm receiving "ORA-12154: TNS: could not resolve the connect identifier specified" error. Although it lists all TNS entries in Database drop down.It was working fine last week but now I'm not able to login.

View 10 Replies View Related

Windows :: Fast Method To Install Oracle Client In Multiple Machines?

May 25, 2010

I need to install Oracle Data Provider for NET (and all depending Oracle client SW components) in multiple client machines.

Exist any other options (faster) without installing oracle client on each of the machines?

View 4 Replies View Related

Client Tools :: ORA-12505 - TNS - Listener Doesn't Currently Know Of SID Given In Connect Descriptor

Jul 25, 2011

When i'm trying to connect my already-existing database, i get an error: "ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.The Connection descriptor used by the client was: localhost:1521:xe".

i can't loose the builted tables and the information stored in them.My listener.ora file is :

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct10.2.0server)
(PROGRAM = extproc)
[code]....

View 36 Replies View Related

Client Tools :: Connect With Database Through Toad - It Throws Error?

Apr 23, 2012

there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.

View 9 Replies View Related

Client Tools :: Sqlplus Error ORA-12154 - TNS - Resolve Connect Identifier Specified?

Feb 24, 2010

it seems to me that the file tnsnames.ora is not read when i execute sqlplus.whit the command: sqlplus username / password @ servicename i receive the error ORA-12154, while if i pass the whole connection string i can connect without problems

sqlplus username/password@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oradev10)(PORT = 10520))(CONNECT_DATA = (SERVICE_NAME = D10)))

i set the ORACLE_HOME environment variable correctly... what more i have to do? following is my tnsnames.ora

TOTEMPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ttf19.cern.ch)(PORT = 1521))

[code]...

View 6 Replies View Related

Client Tools :: Error When Connect To Database Using ERWIN Data Modeler

Feb 17, 2010

I am trying to connect to database using ERWIN Data Modeler (7.1.0) but the following error occurs.

ORA-01041:internal error. hostdef extension doesn't exist.

The connection to database through other tools (e.g PL/SQL Developer etc) are successfully established.

View 3 Replies View Related

Client Tools :: Unable To Connect Database / ORA-27101 / Shared Memory Realm Does Not Exist

Feb 21, 2012

[oracle@localhost ~]$ sqlplus system/password
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:20:09 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

But when i am using SID name while connecting to database i am able to connect...

[oracle@localhost ~]$ sqlplus system/password@apple
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:21:42 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>

I have only one database...

TNS.......
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
APPLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 72.0.0.11)(PORT = 1521))

[code]...

View 6 Replies View Related

Client Tools :: Tools For Load Testing On Oracle - J2EE Application?

Jan 5, 2012

which are recommended Tool for load testing (for performance) on Oracle-J2EE, 3 Tier applications?

Is 'Oracle Application Test Suite' the best for such test where we can simulate numbers of users and their various actions?

Does it come with Oracle Database license or we have to buy it separately?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved