Cannot Connect To Database From Remote Computer (ORA-12545)
Jul 19, 2013
I am trying to connect to a database located at my work from at home. I am running into the following issue (see command and error below):
ansichart@ansivm:~/src/perl$ sqlplus aspxdba/********@aspxp2 SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 18 21:15:09 2013 Copyright (c) 1982, 2011, Oracle.
All rights reserved. ERROR:ORA-12545: Connect failed because target host or object does not exist-- Here is my tnsnames.ora file (I have the service_name censored out for privacy reasons):-
ansichart@ansivm:~/src/perl$ cat $ORACLE_HOME/network/admin/tnsnames.oraaspxp2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = orarac9-scan)(PORT = 1521)) ) (CONNECT_DATA =(SERVICE_NAME = *****************)(UR=A) ) )-
I have verified that I can establish a TCP connection to this DB server on the port specified, using the same info from the TNSnames.ora file (see below):-
---ansichart@ansivm:~/src/perl$ nmap -sT -p 1521 orarac9-scan Starting Nmap 5.21 (URL.... ) at 2013-07-18 20:53 CDTNmap scan report for orarac9-scan (10.1.13.115)Host is up (0.0088s latency).PORT STATE SERVICE1521/tcp open oracle Nmap done: 1 IP address (1 host up) scanned in 0.09 secondsansichart@ansivm:~/src/perl$--
I have another terminal opened up to a server at work and I can connect to the DB with sqlplus just fine. I verified that the record for this database on the tnsnames.ora file is the same as it is at work. In conclusion, I can connect to the Database at work, but I cannot at home, even though I am using the same connection information and verified that port 1521 is accessible on this Database server from at home. So why can't I establish a DB connection?
View 6 Replies
ADVERTISEMENT
Sep 19, 2012
i am working on oracle 10g windows & all my disks are full and i want to add a datafile on other computer . how can i do it ?
View 11 Replies
View Related
Jan 31, 2013
I have installed the Oracle Instant Client* on UNIX(Mac OS X Lion 10.7.5), and I want to use it on localhost because i just want to study and test it.but here, the some error appeared to me. so I was so screwed up.
here is the error messages and the settings
Command:
~ user$ sqlplus scott tiger
ERROR:
ORA-12545: Connect failed because target host or object does not exist
env settings:
$ORACLE_HOME=/usr/local/oracle
$ORACLE_SID="Oracle 10g+ASM" // I don't know what ORACLE_SID means
$ORACLE_LIBRARY=/usr/local/oracle/instantclient_10_2
$DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/instantclient_10_2
$SQLPATH=$ORACLE_HOME/instantclient_10_2
$PATH=$PATH:$SQLPATH
View 1 Replies
View Related
Sep 3, 2009
I installed oracle 10g and developed simple software using forms 6i. Its working well as a stand alone system.
I want to share it in network. so I installed forms 6i as oracle client , copied the tnsnames.ora from the oracle installation path to forms installation path.(inside NET80/Admin folder)
When i try to connect with user name and password , it comes ORA-12203 Unable to connect to destination. I checked LSNRCTL in the database machine, it is listening.
View 11 Replies
View Related
Jul 24, 2011
I am using Report Builder 10.1.2.0.2. There is a table in a remote database with synonyms/links defined. I am getting error trying to access those tables. DBA says links/synonyms are correct and I am also able to access that table from SQLTool without error.
I can do a select statement on those tables from 'SQL Query statement' in data model.
Error is generated only if I try to use those tables in 'Formula' or in function/procedure.
I don't know if this is a bug or something else.
View 28 Replies
View Related
Apr 5, 2010
i 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
View 7 Replies
View Related
May 22, 2013
I have created a function for knowing the status of link which connect me with remote database.function is as follows
---------------------------------------------------------------------------------------------
CREATE OR REPLACE FUNCTION get_status_db_link (p_db_link_in VARCHAR2)
RETURN NUMBER AS
rows NUMBER;
v_code NUMBER;
v_errm VARCHAR2(64);
[code]....
Now functin should returns 1 when link is up and it should return 0 when link down but sometime when link is down it continues showing executing it hang my pc.
View 1 Replies
View Related
Jul 19, 2010
When I try to remotely connect to an Oracle schema using SQLplus, I consistantly get this error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Yet I can connect to the same machine, from my own machine just fine using SQLDeveloper.Here are the details I have collected so far
- I am using the instantclient for OS X
- export DYLD_LIBRARY_PATH=/Users/jeff/instantclient
- export ORACLE_HOME=/Users/jeff/instantclient
- export TNS_ADMIN=/Users/jeff/instantclient/tns
The command line i ran : ./sqlplus seam_classoft/seam_classoft@//oracle11gtest.terida.net:1521/orcl
Its behind a VPN, so I'm not worried about posting my info.
My /Users/jeff/instantclient/tns/tnsnames.ora that I copied directly from the server looks like this:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11gtest.terida.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.terida.net)
)
)
I've tried changing SERVICE_NAME to SID = orcl, no change inbehavior. My original guess was that the database wasn't registered with the listener, but that would mean sqlDeveloper should fail as well, but it works.Here is out put of lsnctrl status:
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-JUN-2010 09:16:40
Uptime 42 days 0 hr. 58 min. 59 sec
Trace Level off
[code]....
View 4 Replies
View Related
Oct 1, 2012
Im doing a project for my college and i need to transfer database. The thing is that i have created tables with databases and linked it to VB using ADODC.
I have done all this in the Computer at my home. So i have done all the project in my computer. I want to show the same project in my college, but i cant do it as the database is stored in my personal computer at home. Is there any ways i could transfer the database from my house to college like storing it in a pendrive. I used sqplus
oracle 9i to create the tables.
View 15 Replies
View Related
Jul 2, 2010
I 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.
View 31 Replies
View Related
Dec 24, 2007
We installed Oracle 10g on one of our servers and configured the listener to host=localhost. Here's our listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
[code]...
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.
View 1 Replies
View Related
Sep 17, 2013
I 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 Related
Jul 23, 2012
I have sample windows C# application to connect remote Oracle DB(Enterprise edition SQ L plus).
Want to connect remotely without installing oracle client on local system.
View 13 Replies
View Related
Feb 23, 2012
i've 0racle 9i database, i wanted to know the easiest way how to copy that database on another computer throw local network,
View 15 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
Oct 6, 2010
I have the following computer/setup:
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?
View 2 Replies
View Related
Jul 16, 2013
I am using Oracle 11g version, and i am using plsql developer 7.1.I am able to connect Oracle through sql*plus, But i am not able to connect Oracle through plsql developer from past few days, it is giving me error like: ora-12545 connect failed because target host does not exist...I recently installed oracle dev_suite 10g client first and then i installed oracle 11g server in windows 7. Both tns files are having identical entries.
Please find the tns entries below.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEPANIGR-IN)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
[code]....
View 7 Replies
View Related
Nov 20, 2012
I want to update my table base on changes in a column of a table from remote database automatically. I just want to pick some updated column then update to my own. i have made a trigger but failed.
CREATE OR REPLACE
TRIGGER TG_UPD_ID
after update OF STUD_ID on STUDENT@SCHOOLDB
for each row
begin
update MARKS set ID_ST = :new.STUD_ID where STUDID_STUDENT = :old.IDS;
end;
Error report:
ORA-02021: DDL operations are not allowed on a remote database
02021. 00000 - "DDL operations are not allowed on a remote database"
*Cause: An attempt was made to use a DDL operation on a remote database.
For example, "CREATE TABLE tablename@remotedbname ...".
*Action: To alter the remote database structure, you must connect to the remote database with the appropriate privileges.
View 11 Replies
View Related
Nov 21, 2011
I have 2 database . One is production and other is Integration and I have one table "emp" which is on integration server and a synonym of that table with the same name"emp" on production. On production we have a proc in which we are using "emp", but some time our integration server goes down, so is there any way to ping the integration server inside the proc and if it returns success then we will execute the rest of code of proc , otherwise it will send a mail to us saying that integration server is down.
View 1 Replies
View Related
Sep 19, 2011
I have a simple script which fetch data from another SQL server database.
The remote SQL Server database is accessed by oracle thru gateway, and a simple DB link is made in local database to the remote oracle datbase (which actually access the MS SQL Server)
The SQL script empties all the data in local database, and fills it with the fresh data from MS SQL server.
Problem is sometimes SQL Server is down, and i lose all the data in local database. The script runs automatically as schedualed job. I want to make my script intelligent enough to terminate the script if the other database is down.
View 7 Replies
View Related
Oct 4, 2013
i am trying to load data into a table in a remote database schema, and my files are residing on another remote Server, Server having the files does not have a DB installed, i just need to know that if its possible or not..
View 2 Replies
View Related
Feb 16, 2010
As a part of requirement need to clean up some of database objects from database. Before cleaning up need to check for dependencies with in database and also on remote database.
Is there any data dictionary in oracle which proivides information about remote dependencies.
Any other way to get a list of remote dependencies other then manual checking.
View 3 Replies
View Related
Nov 23, 2012
I have one PLSQL package that does a join of two tables of remote database instance via the datalink. I just wonder where the most calculation(the join) is done, local machine or remote machine? Is there any best practice to have a better performance for such configuration.
View 3 Replies
View Related
May 13, 2010
I have installed Oracle 10g on one system and Oracle developer on another machine, means i have different machines for DB Server and Application server. It all working excellent inside the company premises, but if i want to access my Oracle DB and application server outside the company then it gives me problem..how to access application (forms and reports ) remotely outside the company...having same db.
View 2 Replies
View Related
Jul 28, 2013
How to know the version of Oracle and JDBC of remote databases that is accessing my database through DBLInk.
For example I have a database A , B database is using my database Through a dblink.Now I want to know the version of oracle and jdbc which working on B.
View 4 Replies
View Related
Jun 16, 2010
I have a function declared as PRAGMA AUTONOMOUS_TRANSACTION.
If i execute this function everything is fine.
If I call this function from a remote database, I have this error message:
"ORA-14551: cannot perform a DML operation inside a query".
select function('parameter') from dual;
Result: "OK"
select function@dblink1('parameter') from dual;
Result: "ORA-14551: cannot perform a DML operation inside a query"
View 14 Replies
View Related
Mar 12, 2009
I have created ".sql" script in Unix and I am trying to execute the script at SQL prompt. But I am getting the following error message after getting the output.
ORA-02019: connection description for remote database not found
Disconnected from Oracle Database 10g Enterprise Edition
Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options
View 10 Replies
View Related
Jan 24, 2013
is there a way to copy WF_EVENT_T type column data from local database to remote database.
View 2 Replies
View Related
Apr 9, 2013
There are 2 Oracle databases with pseudo names Remote and Local. I have a function in Remote called FUS.F_Return_10 which simply returns 10 for testing purposes, where FUS is a schema name. In Local I want to create a procedure that will call the above function. Here's the PL/SQL:
CREATE OR REPLACE PROCEDURE TEST
(
V_COUNT OUT NUMBER
)
AS
V_FOO NUMBER(2,0);
BEGIN
[Code]...
There's a Public Database Link called PER_ACC in Local. When I try to create this procedure I get: Encountered symbol "@" when expecting one of the following: .(*%&................
where my mistake is?
View 7 Replies
View Related
