SQL & PL/SQL :: How To Connect To Oracle 10g From Lower Client Version
Oct 6, 2010
We have a Oracle 10g database in the server. We are trying to connect to the server using oracle6 client and we are able to do so. How ever when retrieving the "time stamps" field , getting an error "ORA-03115: unsupported network datatype or representation". I understood from the error that, the client version need an upgrade.
How ever , We have another server which is having Oracle6 installed in the server and hence If i install/upgrade the client in my local system , I will be having trouble.
My question is , is there any way to get the timestamps from oracle6 client with out any issue.
View 5 Replies
ADVERTISEMENT
Jan 27, 2011
For importing higher version database exp dump e.g. 10g exp dump into 9i database it is suggested at many places "Always use a version of the EXPORT utility that is equal to the lowest version of either the source or the target database"
I understand from this is, I will be using 9i exp utility for exporting 10g database
I would like to know the ways it can be achieved.
1) Installing oracle 9i client on 10g database Do I still need to execute 9i catexp.sql after that? If answer to above is 'yes', I assume catexp.sql of 9i wont be created after 9i client is installed as such I will need to copy it from 9i database server and execute on 10g database server. Correct? For above question I have assumed catexp.sql has different contents for 9i and 10g
2) After configuring tns file in 9i database, can I use?
exp user/password@10gdbconnstring ....
(of course for small amount of data)
Is there any other option for achieving the same?
Also I understand export and import between any 9.* into any 9.* wont be issue e.g. import from 9.2 into 9.1 Similarly any 10.* to another 10.* wont be issue.
View 6 Replies
View Related
Aug 3, 2010
We can Import dump from higher database version to lower database version.
View 26 Replies
View Related
Jan 13, 2011
can we use oracle client version to create a database in that server.
View 3 Replies
View Related
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
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
View Related
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
Mar 26, 2008
I want to find out the oracle client version on a particular server. How can I do that? I used to know some files to look at, and part of the file name indicated the version #, but it's been too long and I don't remember which files they are.
View 2 Replies
View Related
Aug 22, 2011
Which version of 32 bit oracle client should I install on 10204_vista_w2k8_x64_production_db and Windows Server 2008 R2 x64 operating system?
10203_vista_w2k8_x86_production_client - This version does not work (no pre-requisite checks found in oraparam.ini)
View 15 Replies
View Related
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
Dec 6, 2010
I want to update the ODBC drivers in ORACLE 8i version. it's possible or not.
View 2 Replies
View Related
Dec 8, 2011
when i am trying to connect to the database using sqldeveloper i am not able to connect to database. its giving me an error "Unsupported Oracle database version" but with plsql developer I am able to connecting.
View 8 Replies
View Related
Sep 24, 2012
Grid Version : 11.2
OS : Unix, Unix-like
For one of our Java applications, the Oracle Client installed in the apps server was 10.2 . One of the SCAN LISTENERs were down in the cluster. When DNS resolves the scan name to that particular SCAN IP where the listener is down, the connection will fail. But , after they upgraded the oracle client to 11.2 , the issue seems to be resolved. It seems that the client is skipping the faulty SCAN IP which doesn't have scan listener running. Are 11.2 and higher Oracle clients intelligent enough to check this ?
View 1 Replies
View Related
Apr 18, 2008
Is it possible to connect to 10g oracle server from 9i client?
View 1 Replies
View Related
Aug 20, 2013
I am trying to connect to database remotely. I have installed Oracle client on my local machine(Windows 7) and trying to connect to db.
I am able to do tnsping. Below is the log.
But when i try to connect i am getting ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA error.
Below is the complete log.
C:\Windows\System32>tnsping DEVDB
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 20-AUG-2
013 14:18:42
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
D:\app\swanand_kulkarni\product\11.2.0\client_1\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=10.111.0.121)(PORT=1521)))
OK (560 msec)
C:\Windows\System32>sqlplus test1/********@devdb
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 20 14:18:47 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
View 8 Replies
View Related
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
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
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
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
Apr 29, 2012
all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log
alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604
[code]...
View 5 Replies
View Related
Aug 26, 2011
I'm looking for 3 simple things.
1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.
2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).
3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.
View 9 Replies
View Related
Mar 30, 2012
I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?
View 4 Replies
View Related
Aug 6, 2012
I am creating a cross platform database application using Mono. It uses oracle database as back end. I used ODBC drive to connecting database. I can connect to database using this following connection string in my windows machine
Driver={Oracle in OraDb11g_home1};Server=localhost;Uid=system;Pwd=manager
For Linux I uses Linux Oracle OS for Database server. I installed oracle client in my fedora OS. and cofigure the client using net cofiguration assistant tool with oracle client. client connection working OK. Then I try to connect with my mono application using the following connection string
Driver={Oracle ODBD Drive};Server=orcl;Uid=system;Pwd=manager
but the above connection string not worked.I am using Oracle 11g version. Do I need to install any other ODBC driver to access oracle database
View 1 Replies
View Related
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
Sep 26, 2013
Oracle client version whether it is of 32-bit or 64-bit.
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.
C:>sqlplus -v
SQL*Plus: Release 10.2.0.1.0 - Production
C:>
it shows me only version not bit information.is there any other command to get it.
View 26 Replies
View Related
Sep 17, 2010
installing Oracle 9i and Oracle 10 g client on a single PC.
What are the things I should take not of for the installation?
View 4 Replies
View Related
Jun 29, 2013
I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.
On the server machine I configured oracle server in the following way:
Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:
Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521
All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.
With SQL Plus as by the official documentation I have entered the following command:
CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.
With SQL Developer I have entered the same parameter.
But with both SQLPlus and SQL Developer the connection fails.
View 14 Replies
View Related
Aug 10, 2010
we have oracle server. we have to connect 500+ client machine to oracle server.
is it i need to install client version to all 500+ or any other shortcut way?
View 6 Replies
View Related
Apr 15, 2011
The following error message occured when i connected from a client 11.2.0 (64 bits) to a database installing with a 10g 64 bits.
"Test connection failed because of an error in initializing provider.Oracle client and networking components were not found.These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. "
Is there any requirement like the client has to be installed with a 32 bits version of oracle because Windows restrictions?
The current config:
The server: Windows 2008 (64 bits) with Oracle 10g (64 bits).
The client: Windiws 2003 (64 bits) with Oracle 11.2.0 (64 bits).
View 3 Replies
View Related
Mar 11, 2011
is it possible to take table dump in .dmp extention format in toad? if yes then how?
View 4 Replies
View Related