Connecting To Remote DB - Getting Error When Try To Open File

Mar 8, 2011

I am trying to connect to a remote database (Oracle) using my Windows terminal and I am successfully able to connect. But when I try to open a SQL File is gives the following error:

SQL > @int1.sql
SP2-0310: unable to open file

I found out that this error occurs when the file name or the path is invalid. But since I am having a remote access I really don't know the location. What can be done to remove this error?

View 1 Replies


TNS Error : Connecting To Remote Oracle DB From .Net

Sep 22, 2010

I have been trying to connect to an remote oracle db from c# .Net . I believe I have the proper code (Cos when the user id and password strings were omitted , it threw an error of invalid user Id and password).

Once this was properly provided , the connection is now throwing "TNS Error : No Listener " error . The same remote DB is perfectly connecting through TOAD and it is from the tnsnames.ora file of the local file that i got the connection string from . Hence , I don't thing its a problems with that as well.

View 7 Replies View Related

Forms :: Getting Error When Cancel File Selection In File Open Dialogue

Mar 18, 2010

I have created the below stored procedure and calling the procedure in when-button-pressed trigger. Problem here is that when I cancel the file selection in file open dialogue box its raising exception.

buffer_lines client_text_io.file_type;
v_outputstr VARCHAR2 (32767);
p_delimiter VARCHAR2 (10) := '","';
v_transaction_no VARCHAR2 (10);

View 3 Replies View Related

Windows :: Connecting Oracle To Remote Access Server?

Mar 2, 2011

Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.

View 5 Replies View Related

Server Utilities :: SQL Loader Unable To Open File Error?

Mar 9, 2012

I am recieving errors when trying to load the control file. The errors are as follows:

SQL*Loader-500 Unable to open file (homework.ctl)
SQL*Loader-553 file not found
SQL*Loader-559 SYstem error: The system cannot find the file specified.

My control file is located directly in the C drive (C:homework.ctl). The control file contains the following

INFILE 'c:country.dat'
fields terminated by ',' optionally encloded by '"'
(country, month, day)
WHEN (month='April')

The command I am entering is:

sqlldr system/password control=homework.ctl

I've tried c:homework.ctl, 'c:homework.ctl', and placing the file in the BIN folder of Oracle.

View 7 Replies View Related

Precompilers, OCI & OCCI :: Error ID 0706-006 Cannot Find Or Open Library File

Apr 1, 2010

I have 3 code files written in ProC. I have precompiled, compiled, tested them in my local environment (Windows) & they work fine. But when I try in real environment, AIX 5.3, I can precompile them. But when I try to compile & link them with the libclntsh library I get errors. I am using a Makefile but just for testing this is the command -

xlc oraProcs oraProcs.c test_curva.c lib_util.c -I $ORACLE_HOME/precomp/public -L $LIBPATH -l libclntsh.a
Error - ld: 0706-006 Cannot find or open library file: -l libclntsh.a
ld: open(): A file or directory in the pathname does not exist


library libclntsh.a exists in $ORACLE_HOME/lib & has the right permissions

I also tried removing the library libclntsh.a & recreating it using the command - genclntsh When I run this command I get this warning more than once -ld: 0711-783 Warning TOC overflow TOC size: 66888 Max size: 65536 genclntsh creates the library libclntsh.a, just not sure if these warnings damage the library file and are related to my link erros in some way.

View 2 Replies View Related

Server Utilities :: Data Pump Error - ORA-39070 / Unable To Open The Log File

Nov 1, 2006

I'm getting an error when trying to use the new Data Pump Export/Import utility.

I am able to create a directory using SQLPLus, and I get the "Directory Created" message, but no directory actually gets created on the server.

SQL> CREATE DIRECTORY datapump AS 'C:Inetpubdatafiledatapump';

Directory created. But I dont see the directory created on the server.

Then on the server:

C:Documents and SettingsAdministrator>expdp ******/****** FULL=y DIRECTORY=datapump DUMPFILE=expdata.dmp LOGFILE=expdata.log
Export: Release - Production on Wednesday, 01 November, 2006 1:51:55
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

View 5 Replies View Related

Server Utilities :: Unable To Open File And 503 File Not Found

Mar 30, 2008

I am trying to have sqlldr running against a file:


Is it possible I get SQL*Loader-500: Unable to open file and 503 file not found just because the file name does not have an extension?

I can see that any file name I try it looks after whateverFileName.dat! Is there a way to have sqlldr working with files that do not have extensions?

View 22 Replies View Related

Getting Error While Connecting To One Node

May 23, 2013

I have recently installed ORACLE 11gr2 rac. After installation i am not able to connect to one node i am getting the below error

<msg time='2013-05-23T10:25:24.660+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DPDCNSFDB1'
<txt>TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
IBM/AIX RISC System/6000 Error: 32: Broken pipe

My Tns connects to only one node.And i tried to connect using the virtual IP but not able to connect. TNS poing works fine.

View 1 Replies View Related

Error While Connecting To RMAN?

Oct 23, 2012

I am trying to connect rman target / from windows

Microsoft Windows [Version 5.2.3790]
� Copyright 1985-2003 Microsoft Corp.
C:\>set ORACLE_HOME=C:\oracle\product\10.2.0
C:\>rman target /
Message file RMAN<lang>.msb not found
Verify that ORACLE_HOME is set properly
C:\>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

View 2 Replies View Related

Users Getting Error When Connecting To DB

Dec 26, 2012

The users are getting an error when connecting to the DB. I'm also not able to connect thru sqlplus . I get the message

$ sqlplus "/as sysdba"

SQL*Plus: Release - Production on Wed Dec 26 14:39:55 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

ORA-01075: you are currently logged on

ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes o bytes of shared memory ("","","","")
ORA-04031: unable to allocate ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select a.obj# OBJOID, a.clas...","sga heap(1,0)","kglsim hea

I need to restart the DB.

View 5 Replies View Related

Sqlplus Error While Connecting To Database?

Mar 13, 2013

after connecting to database using username and password , i get below error message connection is established and able to work asusal,

Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
select 'Welcome to database: ' || name from v$database
ERROR at line 1:
ORA-00942: table or view does not exist

View 8 Replies View Related

Client Tools :: Getting Error While Connecting To DB In PL/SQL Developer

Dec 5, 2012

I am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.

PL/SQL developer

01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g

I am getting the below error

ORA-12154: TNS could not resolve the connect identifier specified

View 1 Replies View Related

While Connecting To Oracle-DB With Designer - Error ORA-12541

Mar 25, 2007

I have a problem on my PC when I try to connect Oracle-db with Designer .It,s Show this message

ORA-12541 :TNS:no Listener

View 2 Replies View Related

Data Guard :: Error While Connecting Standby Database

Apr 19, 2011

During data guard configuration i have receive an error while connecting to stanby database from primary database rman prompt.

rman target sys/srk786@orcli
Recovery Manager: Release - Production on Tue Apr 19 09:59:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCLI (DBID=3754068166)
RMAN> connect auxiliary sys/srk786@stnd

View 1 Replies View Related

Call Interface :: ORA-12504 Error When Connecting To Oracle 11G DB Using OCI?

Jul 11, 2013

I am using OCI and instant_client (  in my C++ program (on Windows 7) to connect remotely to 11G database. While doing a connection using server name as well as servername:port/service_name as connection strings, I am getting error of ORA-12504 TNS:listener was not given the SERVICE_NAME in CONNECT_DATA. According to instant client FAQ & white paper at [URL]..., no tnsnames.ora is required for instant client. Then why could I be getting this error? I ensured that only the instant client directory is in Path environment variable. There was a ODBC driver installed on this same host.

View 3 Replies View Related

SQL & PL/SQL :: Ftp File To Remote Server By Reading Data From Table?

May 1, 2012

I need a way to ftp file to remote server by reading data from table. I searched a couple of sites which asked me to use Chris xutl_ftp package..but unfortunately the site is no accessible..

Here is the code

* LICENSE: GNU Lesser General Public License (LGPL)
* Copyright (C) 2003-2006 Russ Johnson (


View 3 Replies View Related

Connect From A Remote Client / Received Error Of No Listener

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:

(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)

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

SQL & PL/SQL :: Excel File Can't Open

Aug 17, 2010

im sending email with attachment of report output in xml format. file was attached but cant opened.

it show me error at the time of opening that

XML ERROR in Unknown
REASON: Illegal Tag
FILE: C:Documents and SettingsTxisDesktopAR_AGING_DETAILS_1186958_1(3).XML
VALUE: ?B/to{??C

i face this problem when i send mail on yahoo and from outlook. but it opened in gmail, from incredimail

View 1 Replies View Related

Performance Tuning :: Command To Transfer File From Local To Remote Server

Apr 21, 2011

I ran a scp command to transfer a file from local server to a remote server. when I am trying to kill the process, its giving an error.

ksh: kill: 19258: No such process

If I do a ps -ef | grep scp its showing the process running, but if i try to kill it, its showing me error.

View 7 Replies View Related

Windows :: Copy A File To DB Server From A Remote Machine Using Plsql / Java

Oct 2, 2013

We want to copy a file from a remote machine to the DB server. copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql

I've used Java and a wrapped it into a PL/SQL procedure so I can do :

exec run_os_command(p_command => 'copy \<IP_ADRESS>SHARED_FOLDERsome_file.sql d:copied_file.sql');

The file was not copied.

I have mapped \<IP_ADRESS>SHARED_FOLDER to x: for example and issued : exec run_os_command(p_command => 'copy x:some_file.sql d:copied_file.sql');

The file was not copied.

But when I issued from the OS prompt copy x:some_file.sql d:copied_file.sql then the file is copied.

What can I add to the PL/SQL procedure so it wil work ?

View 19 Replies View Related

Getting Error When Try To Open PL / SQL Developer

Jul 3, 2012

i try to open PL/SQL Developer and i get this error:

Could not locate OCI dll
OracleHomeDir: d:\app\...................\product\11.1.0\client_1

what can be the problem ?

View 2 Replies View Related

Forms :: How To Open PDF File In Oracle 10g

Nov 25, 2010

i am trying to open a .pdf file in oracle forms 10g which had stored in oracle 9i.10g database.

so which method shall i use to do this?

View 1 Replies View Related

Forms :: Open FMX File In Oracle 10g?

Apr 4, 2013

how can i open the .fmx file in oracle 10g?

View 12 Replies View Related

Forms :: FRM-10043 Cannot Open A File

Jul 11, 2011

When I am trying to open a PLL[5i] through Form5i Builder , Getting Error message like "FRM-10043 Cannot open a File".

View 1 Replies View Related

Recovery Manager (RMAN) :: Duplicate Database From ASM To Non-ASM File System To Remote Machine

Aug 30, 2012

I have oracle in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?

Can i keep the database name as ASMDB in another Machine ?

View 9 Replies View Related

Ora-06413 Connection Not Open Error

Jul 13, 2013

I have Oracle 11g XE and Toad installed on Windows 7 64-bit machine. I am able to connect to database from Oracle's SQLPLUS. But when connecting from TOAD i am getting ora-06413 connection not open error.

View 1 Replies View Related

PL/SQL :: Getting Error - ORA-06511 - Cursor Already Open?

Jul 27, 2012

I have the following code for a Apex(Application Express) project I am developing.

mail_id varchar2(100);
min_skill_cnt number;
skill_cde varchar2(30);
total_leave number;
toal_emp number;

cursor cur is
select S_EMP_EMAIL

cursor minskill is
select skill_code,MINRQMT_AM
from skills_code_info
where skill_code in (select skillcode from emp_skills_info where S_EMP_EMAIL = lower(:APP_USER));

cursor leavecnt(v_skill IN VARCHAR2) is
select count(*) from emp_leave_info
where leave_date = :P24_LEAVE_DATE
and emp_email IN (select S_EMP_EMAIL from EMP_SKILLS_INFO where SKILLCODE = v_skill);
cursor empcnt(v_skills IN VARCHAR2) is


Ideally this should send email to managers when a particular skill is running short when employee applies for leave. I am getting error that cursor is already open when I run this code. I am not sure which cursor or where it is picking open cursor command.

View 2 Replies View Related

Forms :: Open File JavaBean For Web Deployed 6i?

Feb 5, 2008

I want to use dialog for selecting file in Fomrs 6i.I attached d2kwutill.pll into form, i uploaded d2kwut60.dll into <ORA_HOME>/bin and coded WIN_API_DIALOG.OPEN_FILE to open file. Everything works fine on the machine I'm developing, the open file dialog works and it returns file name. But when i upload form on remote machine where i access through the web it won't work.

I uploaded d2kwutil.plx on remote machine to the directory where forms reside. This is when I attach library without storing full path of it which is in my case c:someFormsDir - note! on remote machine Forms reside on d:Forms, and on local machine I have only c: HDD D: is cdrom and i can't change drive letters.

I also try to upload d2kwutil.plx in c:someFomrsDir on remote machine although forms there reside in d:Forms, but on local machine library(and forms) reside in c:someFormsDir.

None of two above examples work.

I upload d2kwut60.dll in <ORACLE_HOME>in direcotry - doesn't work. I even upload d2kwut60.dll in orahome2in direcory, doesn't work. On my local machine d2kwut60.dll is in ORA_HOMEin where ifsrv60.exe can be found, the same i do on remote.

When I puch button to open dialog for choosing file Internet Explorer freezes.

View 12 Replies View Related

Forms :: Open PDF File When Button Pressed?

Dec 6, 2009

I've a button on a form and I wrote a trigger when button pressed to open a pdf file and it worked fine this was my

AppID := DDE.App_Begin('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe Z:BUILTINS.pdf',DDE.APP_MODE_NORMAL);

The thing is this form is used by multiple clients and if a user has a different version of acrobat reader rather than version 8 this will not work how to do it to be uniform?

View 5 Replies View Related

Copyrights 2005-15, All rights reserved