I have installed oracle 10g database in the my local laptop ( Windows 7) . This laptop is in LAN. I am not able to connect from other machines in LAN. When i open sqlplus, SQL Developer from the same machine, i was able to login to the instance.
But when i want to login from the other machines in LAN. I was not able to connect. I was able to ping the server on which the database was installed from other machines. why i am not able to connect ?
"instantclient" already downloaded and configured as below :
dll files like "oci.dll,... etc" are here : C:Oracleinstantclientinstantclient_11_2 Created both tnsnames.ora & listener.ora are here : C:Oracleinstantclient etworkadmin
And did the below in user/system variables :
User Variables : ========= TNS_ADMIN with value "C:Oracleinstantclient etworkadmin"
System Variables : =========== TNS_ADMIN with value "C:Oracleinstantclient etworkadmin" ORACLE_HOME with value "C:Oracleinstantclient" Path edited and added this value "C:Oracleinstantclientinstantclient_11_2"
i have a inventory system and trying to connect remote database one by one throught two static ips. If first ip is not ping then go to 2nd ip only when open the login.fmx page
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.")
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
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.
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.
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.
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.
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.
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.
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
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
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'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.
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).
Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit) Delphi 2010 Professional Oracle XE (+ the Oracle XE client that comes with it)
I cannot can't to the Oracle database from Delphi. The error I keep getting is:
Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.
Here's what I've done:
1. Create an ODBC connection to my Oracle database
- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator. - Data source name: bt_user - TNS Server Name: localhost/xe - user bt_user - Clicked "test connection" -- Success.
2. Open Delphi and drop a TDatabase component on my main form.
- Set the Alias Name property to "bt_user" (the alias I set up in ODBC) - Set database name to "bt_user". - Checked "connected".
Alternatively, I tried using the Delphi ADO components (the dbGo components).
- Drop TADOConnection component on my form. - Select "connection string" and open the dialog. - Click "build string". - Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection. - In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1) - Click "test connection".
Again the same error.
My questions are:
1. Can Delphi work with Oracle XE (Express Edition)?
2. If so, then do I need to install the "Instant Client"?
3. Will the instant client for Oracle 10g work with Oracle 10g XE?
4. Do I need to install any additional ODBC driver(s)?
5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?
6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?
I have installed oracle 10g on Red Hat Linux and I am able to connect as well.The listener and DB is up and running and I am able to coonect as well from the server.
But I have installed the oracle client (TOAD) on some windows machine and from there I am not able to connect . I am directly connecting by giving IP and other details and using TNS as well but I am not able to connect from client machine. I am getting ORA 12170 - TNS timeout error.
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 ?
I was trying to connect to oracle 10g database from oracle 10g client. But unable to do so.
i am able to tnsping the db from client but unable to estatblish sqlplus connection. I get ORA-28547 error when i issue the command sqlplus hr/***@db1. ORA-1560 when the command sqlplus hr/*** is issued.
I have mentioned the listener and tnsnames.ora files
Just wanted to know if 11XE (R2,32bit) will install and work correctly on Windows Server 2008 R2 x64?
I would like to install either the Oracle 11g Client and/or ODP.NET(x86 and x64) on the same machine, would this work? I cannot find any documentation regarding this and so far I am having some issues. At this point in time I have 11XE and ODP.Net (both x86) on this x64 machine under separate Oracle_homes and I cannot connect to the XE database from either SQLPlus client installed with the respective Oracle_Home..
Can I use a 32bit client to connect to a 64bit server?
After restarting the listener, we could connect using the connect identifier from the local server. However, when trying to connect from a remote client we received the error of "no listener". In the remote client the identifier is defined with host=ip_address. TNSping from the client to the host was successful.
When we changed listener.ora to host=up_address we could connect ONLY from the remote computer. Only after changing the host in tnsnames.ora file to the IP as well - we could connect from both the local server and the remote client.
I usually use host=localhost in the listener file (and the local tnsnames file) and never had this problem before.
