Networking And Gateways :: Connect Oracle Report And Forms 6i To Sysbase?
Jun 17, 2011coonnect sybase SQL anywhere 7 with Oracle Forms and Reports 6i.
View 6 Replies
ADVERTISEMENT
Networking And Gateways :: Forms Not Connect On Remote Site
Sep 17, 2013I have a strange problem of connecting Oracle Forms6i from our Remote site.actually we change our IP address of lease line, we connect to it.but when we connect locally,forms are running without any problem,but when we connect globally or from other sites it can't able to connect,even sql prompt and toad also connect from remote site,but when we try to connect forms(forms runtime) it gives error message(ORA-12203: TNS:unable to connect to destination).when we connect this application from local application(Forms) it can connect well but from globally it can't able to connect.
View 1 Replies View RelatedNetworking And Gateways :: Oracle Database Not Connect From Outside LAN Via Static IP
Nov 17, 2011I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,
ie.select * from v$shared_server,
the output of this query is attached with this post.
Networking And Gateways :: Using Putty To Connect To Oracle Database?
Jul 5, 2011Do I need to install the Oracle client in order to use putty to connect to the database?
View 11 Replies View RelatedNetworking And Gateways :: Connect To SQL Server From Oracle Using Heterogeneous Services?
Mar 11, 2011I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.
But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)
Networking And Gateways :: Unable To Connect To ORACLE ODA 11g - JDBC Connection Error
Aug 21, 2013I am not able to connect to ORACLE ODA 11g. but using sqlplus its getting connected with below credential.
URL------------------- jdbc:oracle:thin:sacblmdbuser/sacblmdbuser@10.66.12.229:1521:OVPINHA
Oracle JDBC driver loaded ok.
Unable to create connection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Networking And Gateways :: Cannot Connect To Database
Nov 2, 2011I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files
tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Networking And Gateways :: Connect Time Fail Over?
Mar 12, 2010I would like to implement connect time fail over from my JDBC thin client. The client will try to first connect with dedicated connection mode, if the connection time crosses more than two seconds, then connection will be opened with shared mode. To implement this, I have put the following connection string in my JDBC URL. I am able to connect to database with this URL, however it seems fail over does not work. Is it because, my database listener is not configured with dynamic service registration. If I implement the dynamic service registration, is fail over going to work? Note, I want to fail over in the same database instance but with different listener.
(DESCRIPTION_LIST =
(FAILOVER = TRUE)
(LOAD_BALANCE = FALSE)
[Code].....
Networking And Gateways :: TNS Could Not Resolve Connect Identifier Specified
Nov 4, 2010I have a really strange problem connecting from a new client to an Oracle server, here are the points :
- There is no problem with DB server and its listener and all that as I am able to connect from other clients
- I have installed the oraclient on this machine ( it is a XP machine ) and copy/pasted the TNSNAMES.ORA from one of those correct PCs here and when I do a TNSPING is returns OK
- even when I open oracle net manager I see the TNS entries in there and when I test a connection thru it is says successfull
- BUT WHEN I USE SQL+ or TOAD or ODBC ( any of these) trying to make a connection using the exact same TNS entries it returns :
"ORA-12154: TNS:could not resolve the connect identifier specified"
- I have tried with both IP and Host name but no luck
- TNSNames.Ora and sqlnet.ora both are located here : oracleproduct10.2.0client_1NETWORKADMIN
- there is just one oracle home
- I have already uninstalled/installed oracle client
- These lines are included in Sqlnet.ora :
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES)
I marked those entries in Sqlnet.ora and that made no diff in result, another thing : if I use easy connect method : sqlplus scott/tiger@<Servername>:1521/ORCL it does connect but using TNSNames still I can not get connected. so strange!!, seems somehow the TNS file even is not being picked or looked at !
Networking And Gateways :: Unable To Connect To DB From Client
Dec 3, 2011I 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
listener.ora
------------
[oracle@localhost admin]$ more listener.ora
# listener.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/netw
ork/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
[code]........
Networking And Gateways :: Connect Remotely Database?
Jul 14, 2010i 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
following examples are my tnsnames.ora
IP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.12)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
IP2.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.13)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
i am not understand what i write the code on-logon trigger
Networking And Gateways :: Unable To Connect To OPMN
Jan 25, 2011Getting Unable to connect to OPMN. Opmn may not be up while checking the status of instance.
View 2 Replies View RelatedNetworking And Gateways :: Unable To Connect To Database?
Feb 1, 2012I am getting beloww error very frequently in database log and not able to connect to the database.
************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 01-FEB-2012 18:00:34
Tracing not turned on.
Tns error struct:
ns main err 12535
TNS-12535: TNS:operation timed out
ns secondary err 12606
nt main err 0
nt secondary err 0
nt OS err 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.1.24)(PORT=65503))
WARNING: inbound connection timed out (ORA-3136)
Wed Feb 01 18:00:44 2012
*****************
Networking And Gateways :: TNS - Could Not Resolve Connect Identifier Specified
Dec 29, 2012I have both 10g and 11g installed in my machine.There are so many CI builds that runs without problems.For few builds which uses 10g, it throws errors as ,
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 01:18:52 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
Only at a particular step, this is happening. After this,if some-other target is connecting to Oracle,it is able to connect.
Networking And Gateways :: Can't Connect To Remote DB Listener
Jul 2, 2010I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).
I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).
Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.
Networking And Gateways :: Unable To Connect To Database
Jun 27, 2011am getting this message when am connecting to a database :
ora-12519:Message 12519 not found;product=RDBMS80 facility = ORA
am not getting this message all the time, sometimes am connected without any problem sometimes i get this message and i have to try again several times until am connected
i searched the net and my database provider guided me to this log URL.....
how to set my ORACLE_HOME environment variable.
Networking And Gateways :: Connect Remote Database Without Providing SID?
Apr 5, 2010i need to connect to a remote database located on a different server using sqlplus without using database name in connect string.
e.g. if mydb1 (located on another database server on network)
sqlplus username/password
i am able to do this on local database but not on the remote database
Networking And Gateways :: ORA-12203 TNS - Unable To Connect To Destination
Oct 17, 2012I install oracle database 11g and developer 6i on windows7 64bit server everything is working fine on the server and i install developer 6i on windows XP on client now i'm getting "ora-12203:TNS: unable to connect to destination" when trying to connect the server. i have check the TNSNAMES.ORA file the configuration is fine. then why i'm getting this message?
View 5 Replies View RelatedNetworking And Gateways :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified
Dec 4, 2012While connecting to Database through sqlplus as sysdba, error pop-up.
SQL> conn sysdba@disdevt
Enter password: *******
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL>
but i am able to log-in to database through pl/sql developer. Since TNS is same for both.
Networking And Gateways :: ORA-12170 / TNS / Connect Timeout Occurred
Jul 18, 2011I was getting the following error when trying to connect development database.
sqlplus bala/test11@ORCL.SBC.COM
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 13:04:18 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:ORA-12170: TNS:Connect timeout occurred
Enter user-name:
But i am to connect this database through putty,toad at that time. But after sometime, i was able to connect the database.
Networking And Gateways :: Fatal NI Connect Error 12638
Aug 10, 2008I'm getting this information in sqlnet.log file lying at D:oracleoradatadatabase
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclemaninder)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA=(SID=maninder)(CID=(PROGRAM=d:oracleora92inORACLE.EXE)(HOST=SAI-E6C10175EE4)(USER=OraUser))))
[code]...
Networking And Gateways :: ORA-12170 / TNS / Connect Timeout Error
Jan 10, 2012I installed my Oracle 10g R2 software in redhat linux installed in VMWare player in my laptop.
I am trying to connect to database from my laptop which has windows 7 installed
My goal is to connect to database installed in linux vmware from my laptop having windows7 OS..
I have installed Oracle instant client on windows 7,trying to make a connection to database but its giving me the following error when i tried...
sqlplus sqlplus scott/tiger@(description=(address_list=(
address=(protocol=TCP)(host=192.168.1.7)(port=1521)))(connect_data=(service_name=subhani)))..
ora-12170:TNS Connect TimeOut Error..
Networking And Gateways :: Can't Connect To Sybase (ASA) Via Database Gateway
Sep 6, 2009I'm trying to connect from Oracle 11g (11.2.0.1.0) to Sybase Adaptive Server Anywhere (9.0.2.3527). My Oracle environment is running on Linux Centos 5.3, the sybase database runs on a Windows Server.
All my attempts have failed so far - both through Oracle Database Gateway for Sybase and via Oracle Database Gateway for ODBC in combination with freeTDS. Using either way I'm ending up with apparently the same error:
ASA Error -611: Transact-SQL feature not supported
When I use db link created via dg4sybs (Oracle Database Gateway for Sybase) I get this:
SQL> SELECT * FROM aaa@hvx;
SELECT * FROM aaa@hvx
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[code]....
When I use db link created via dg4odbc (Oracle Database Gateway for ODBC) and freeTDS driver I get this:
SQL> SELECT * FROM aaa@hvx1;
SELECT * FROM aaa@hvx1
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
[code]....
It seems both drivers use Transact-SQL instructions which are then denied by ASA. I'm not familiar with Sybase products at all, but as far as what my googling revealed the Transact-SQL is only supported in Adaptive Server Enterprise (enterprise-class version of Sybase's database). I couldn't figure out if there's a way how to disable Transact-SQL in the driver configuration. how to connect from Oracle (10g or 11g) to Sybase Adaptive Server Anywhere?
Networking And Gateways :: ORA-12154 - Could Not Resolve Connect Identifier Specified
Dec 26, 2008I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).
When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.
D:Documents and SettingsBAR>tnsping appdev
TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:22:57
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
TNS-12533: TNS:illegal ADDRESS parameters
D:Documents and SettingsBAR>tnsping vislinux
TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:23:21
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora
TNS-03505: Failed to resolve name
and when I use TOAD to connect the schema's I get the following error ORA-12154:TNS:could not resolve the connect identifier specified
Here are the contents of my TNSNAMES.ora file
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
(CONNECT_DATA =
[Code]....
Networking And Gateways :: How To Connect To Database When LAN / USB Datacard Connection
May 12, 2011when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.
but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.
how can i connect to database when the LAN,USB datacard connection.
Networking And Gateways :: ORA-12170 - TNS - Connect Timeout Occurred
Jan 24, 2012I get below error when trying to connect to database server using
C:Documents and SettingsAdministrator>sqlplus jack/jack@DB_PROD
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 24 12:11:45 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
Enter user-name:
FYI,
The database i am trying to connect is 9.2.0.8.0 and the client that is installed in my machine is 10.2.0.1.0
Is problem with the database versions ?
Networking And Gateways :: ORA-12154 / Could Not Resolve Connect Identifier Specified
Mar 17, 2011What works: There is a oracle database on the local network. I'm connecting to it through my web server on my pc (apache/php). I have installed "oracle_instantclient10". It works fine - i can connect to oracle db, queries are executed fine.
What doesnt work: I'm trieing to connect to the same oracle db from a Linux server, but i get the error:
ORA-12154: TNS:could not resolve the connect identifier specified
My linux server can connect to remote oracle db, because "nmap ORACLE_DB_MACHINE_IP -PN", gives me answer "1521/tcp open oracle". I have the same firewall allowance with my winXp pc.
I use the same "TNSNAMES.ORA" and "SQLNET.ORA" files on both: linux server, winXp pc. The only difference between winXp and linux machines is that winXp uses oracle instant client version 10.2, and linux uses version 11.2.
Networking And Gateways :: Client Machines Unable To Connect DB?
Sep 2, 2011Database is up and running and client machines able to do TNSPING; But when users try to connect the database thro SQL DEVELOPER, they are getting below information:
your database connection has been reset. Any pending transactions or session state has been lost.in the database server, SQLNET.ORA reads as below:
> more sqlnet.ora
AUTOMATIC_IPC = ON
names.directory_path = (TNSNAMES,EZCONNECT)
names.default_domain = world
name.default_zone = world
sqlnet.expire_time = 15sqlnet expire time shows 15 min.
normally this error willbe suppressed if user tried after some time. But now we get this error for more than 2 hrs.
Networking And Gateways :: Client Connect Directly To Instance Rather Than During TNS?
Jun 20, 20101) I put attention that TNS write events into its log in too big frequency: ~ 10 time in second. I see that it is for every connection, but I assume that this no too good to performance.Is there some way to tell to TNS not to write event for every connection but only for errors?
2) May I to remove alert.log of DB? Or DB will make me problems with this?
3) How can I tell to my client connect directly to my instance rather than during TNS?
I have Oracle RAC 11g running on Red Hat 4 64 bit.
Networking And Gateways :: How Connect-time Failover Is Setup
Mar 5, 2010How connect-time failover is setup.
I am following lab instruction from my Oracle Admin Workshop book. The exercise is to create a 2nd listener to support connect-time failover. I have two listeners up and running. I connected the second listener using Static Database Registration in OEM, and then I started it.
When I looked in the listener.ora file, I was expecting to find the entries for FAILOVER=TRUE but it is not there. Both listeners are designed to connect to the same instance 'orcl'.
My questions:
1) Is the FAILOVER entry supposed to be done automatically when the second listener is created ? or is it always a manual entry ?
2) How can I test that it is working ?