SQL & PL/SQL :: SP2-0310 - Unable To Open File When Running AWR Report?
Dec 1, 2011
When i run the awr report from sqlplus , i get below error message.
Quote:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
[code]////
Also i dont find the awrrpt.sql in the following path.
Quote:
$ pwd
/usr/local/oracle/product/9.2.0/rdbms/admin
$
$ ls -alrt awrrpt.sql
awrrpt.sql: No such file or directory
$
Is it something related to permissions on file ?
View 4 Replies
ADVERTISEMENT
Feb 2, 2010
i m unable to run the following script in sqlplus
SQL> @D:vasucount.sql
SP2-0310: unable to open file "D:vasucount.sql"
SQL>
View 5 Replies
View Related
Apr 14, 2012
when i run the script file 1.sqlIt throws me following error
SQL> @/c/temp/1.sql
SP2-0310: unable to open file "/c/temp/1.sql"
View 4 Replies
View Related
Mar 30, 2008
I am trying to have sqlldr running against a file:
C:oratest20080318
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
Jul 6, 2010
I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
View 2 Replies
View Related
Jan 30, 2012
I am using forms 10.1.2.0.
I am try to open one .fmb file but file is not open in form builder.Its shows message "cannot open file".
I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.
View 4 Replies
View Related
Jun 24, 2013
Lots of email alerts reporting SQL Loader failures (the data is actually loading) but I want to prevent all these email alerts being fired. We have an SQL Loader script that is failing regularly with this error, however the data does end up in the tables so it must run subsequently succesfully the log files are cleared out quite quickly so it is difficult to track the errors. Why is there no filename just a.day reference in the error log file?
Below is the shell script I do not have much script experience, so I am unable to see how I can alter this...could I add some kind of exclusive lock check to see if I actually have access to the file before SQL Loader tries to Load it?
value used for ROWS parameter changed from 64 to 63 SQL*Loader-500: Unable to open file (/e2e_ms_xfer/cent01/.dat) SQL*Loader-553: file not found SQL*Loader-509: System error: No such file or directory SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
This is the full error log file SQL*Loader: Release 11.2.0.3.0 - Production on Sat Jun 15 12:17:38 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Control File: /tmp/e2e_load_ms_raw_coda.ctl Data File:
/e2e_ms_xfer/cent01/.dat Bad File: /tmp/e2e_load_ms_raw_coda.bad Discard File: /tmp/e2e_load_ms_raw_coda.dsc (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array: 64 rows, maximum of 256000 bytes Continuation: none specified Path used: Conventional Table MS_RAW_CODA, loaded from every logical record. Insert option in effect for this table: APPEND TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype -----------CODA_RECORD FIRST 4000 CHARACTER Terminator string :
[code]....
View 0 Replies
View Related
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
LOAD DATA
INFILE 'c:country.dat'
APPEND INTO TABLE homework
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
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 10.2.0.1.0 - 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 10.2.0.1.0 - 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
Aug 1, 2013
I am doing steps to run report in Forms....
when I running command rwserver server=reportserver10g in command prompt I am getting orapls10.dll file not dynamically attached error...
Forms and Reports and Database in my system only(practice purpose).
View 1 Replies
View Related
Jul 11, 2012
I want to create a wallet on RAC setup.I have two node setup.I have created the wallet directory under shared folder /u01/oradata/$ORACLE_SID/wallet
I am Unable to open wallet.I tried this using the below command
SQL> alter system set encryption key identified by "aryabhat";
alter system set encryption key identified by "aryabhat"
*
ERROR at line 1:
ORA-28353: failed to open wallet
Following is the content of sqlnet.ora file
(path : /u01/app/11.2.0/grid/network/admin/sqlnet.ora)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle
ENCRYPTION_WALLET_LOCATION =
(SOURCE = (METHOD = FILE)(METHOD_DATA =
(DIRECTORY = /u01/oradata/$ORACLE_SID/wallet/)))
View 3 Replies
View Related
Jun 23, 2011
I am working on SQL,PLSQL and my application is in Java. I have 2 schemas in same database.
In one schema, the DML operations are very slow while in other schema is fine.
Also I am getting an error ORA-01000 maximum open cursors exceeded frequently while running application in Java.
View 13 Replies
View Related
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.
PROCEDURE TEST
IS
buffer_lines client_text_io.file_type;
v_outputstr VARCHAR2 (32767);
p_delimiter VARCHAR2 (10) := '","';
v_transaction_no VARCHAR2 (10);
BEGIN
[code].......
View 3 Replies
View Related
Jun 13, 2011
I have problems in opening the database of the physical standby in read- write mode/ read only mode. I have a primary server which is running on 2 node RAC and the standby on a seperate single server being used as DR. I recently got this server and my aim was to isolate the standby server from primary server and perform few test. As it has never been tested even once.
Primary Database spec: (2 Node Rac on ASM)
Oracle Version : 10.2.0.3.0
O/s : HP-UX B.11.23
Standby Database spec: (Single Node)
Oracle Version : 10.2.0.3.0
O/s: HP-UX db01 B.11.23
Error:
--------------------------------------------------------------------------------
alter database recover managed standby database cancel;
Database altered.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/dprod/datafile/system01.dbf'
--------------------------------------------------------------------------------
Parameters :
log_archive_dest_2 string SERVICE=PROD1 LGWR ASYNC VALID
_FOR=(ONLINE_LOGFILES,PRIMARY_
ROLE) DB_UNIQUE_NAME=PROD
remote_archive_enable string true
fal_client string DPROD
fal_server string PROD1, PROD2
Steps tried so far:
Changed log_archive_dest_2 = DEFER on both the primary nodes
Standby :
startup nomount
alter database mount standby database;
alter database recover managed standby database disconnect;
alter database recover managed standby database cancel;
alter database open/readonly (tried both)
Same error.
On Primary:
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
--------------------------------------------------------------------------------
55702
on Standby:
MAX(SEQUENCE#)
--------------------------------------------------------------------------------
33289
Primary Database:
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# FIRST_TIME NEXT_TIME
--------------------------------------------------------------------------------
55700 13-JUN-11 13-JUN-11
55700 13-JUN-11 13-JUN-11
55701 13-JUN-11 13-JUN-11
55701 13-JUN-11 13-JUN-11
55702 13-JUN-11 13-JUN-11
60824 rows selected.
Standby Database:
SEQUENCE# FIRST_TIME NEXT_TIME
--------------------------------------------------------------------------------
55698 13-JUN-11 13-JUN-11
55699 13-JUN-11 13-JUN-11
55700 13-JUN-11 13-JUN-11
55701 13-JUN-11 13-JUN-11
15206 rows selected.
Additional Information : There is a delay of 20 minutes before the logs get applied. which has been intentional set by team. Dataguard broker is not configured as well.
View 7 Replies
View Related
Feb 21, 2012
one of my friend created a form in his PC(which is having the same configuration as my PC) and sent me that .fmb file. when I'm opening that form, it is throwing "FRM-11009 : Failed to load in the color palette" error..
I have checked the CAUPREFS.ORA where Forms.color_mode = 1 and I haven't found 'forms.color_pallete' entry in that file.
View 3 Replies
View Related
Mar 22, 2010
I am unable to start ACTIVE DATAGUARD in 11g.
SQL> startup
ORACLE instance started.
Total System Global Area 522092544 bytes
Fixed Size 2090224 bytes
[code]...
Database altered.
SQL> select count(*) from scott.test;
select count(*) from scott.test
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
View 6 Replies
View Related
Aug 31, 2013
I tried to run the duplicate script after transferring new rman backup to standby. Even after transferring the backup, duplicate command and was unable to open the database.
View 1 Replies
View Related
Jul 3, 2013
I ran the script "Duplicate target database for standby" but it unable to open the database. Below are the rman scripts -
calhost dbs]$ rman target sys/oracle@PRODDB auxiliary sys/oracle
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 25 06:09:33 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PRODDB (DBID=558988263)
connected to auxiliary database: PRODDB (not mounted)
[code]....
Though I have taken the same backup but it's suggesting about the system datafile.
View 8 Replies
View Related
Oct 12, 2010
I am unable to open Oracle 9 iSQL window in internet explorer 6. And i have two oracle version installed in my system are 9i and 10g.Now i am able to open the iSQL windows of 10g but not the 9i. It's happen after installing the Oracle 10g in system.
how i open both the iSQL windows in my system the Oracle 9i and 10g
View 3 Replies
View Related
Aug 27, 2012
Is this possible to open rtp report(oracle report), by pressing button in apex.
View 2 Replies
View Related
Jun 4, 2013
We have the Oracle 11g XE database installed on a Windows 7 laptop. The Oracle XE database runs fine when the laptop not connected to a network, when connected to our corporate lan, or when connected to a cable-modem. However, when running under the Cisco AnyConnect VPN client, we are unable to connect to the Oracle XE service.
I have tried to resolve this, but am stuck. I do not if this issues is caused by:
1. There is no IPv6 address listed for the AnyConnect VPN (from ipconfig /all)?
2. Something regarding split-tunnelling that must be configured on the VPN?
3. Can the Oracle XE database run under an SSL VPN?
Below is the output of when I try to connect the Oracle XE service via sqlplus.
**************************
The OracleXETNSListener service is starting.
The OracleXETNSListener service was started successfully.
The OracleServiceXE service is starting..............
The OracleServiceXE service was started successfully.
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>sqlplus system/password@XE
SQL*Plus: Release 11.2.0.2.0 Production on Fri May 31 07:03:24 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12546: TNS:permission denied
Enter user-name:
**************************
listeneralertlog,xml
<msg time='2013-05-31T07:03:24.950-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:ProgramDataoraclexeapporacleproduct11.2.0serverinsqlplus.exe)(HOST=DEV-M-137GF)(USER=ptavolet))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.99.8.39)(PORT=56324)) * establish * XE * 12514
[code].........
**************************
listener racelistener.log file
Started with pid=3688
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV-M-137GF.paychex.com)(PORT=1521)))
[code]......
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:07:43
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 31-MAY-2013 07:01:12
Uptime 0 days 0 hr. 6 min. 31 sec
[code].......
The command completed successfully
**************************
C:ProgramDataoraclexeapporacleproduct11.2.0serverin>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:08:13
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
View 4 Replies
View Related
Sep 9, 2012
Is it possible to run Oracle 10g Report from PL/SQL code?
View 1 Replies
View Related
Jul 22, 2010
I am facing a problem while calling a report from FORM.the system gets hang and RWRBE60.EXE is not started.I am using client/server environment and Form 6i.
View 2 Replies
View Related
Oct 26, 2010
My requirement is:
I want to run multiple Reports Concurrently, being called from my Form.
Suppose I have 10 Reports Say Report1, Report2, ....Report10.
I am using "RUN_PRODUCT" to call these Reports from my Form. But it's taking too long time to run all the Reports one after another. Can I run all these Reports Concurrently at the Same time.
View 4 Replies
View Related
Jun 11, 2010
I have installed Oracle 10g DB and Developer Suite 10g and have made a simple report in it. This report runs perfectly fine when run from Reports Developer even in Browser. But when I called this report from FORM I get error.
The Trigger behind WHEN-BUTTON-PRESSED is
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
v_parameter_string varchar2(4000);
[code]....
I also set my Report Server as rep_fsprod using CMD
rwserver server=rep_fsprod
I have made changes in .env files adding the REPORTS_PATH in it of the location where my reports are placed.Also have made changes in REGISTRY adding in REPORTS_PATH the same location. But when I press button the Browser window opened shows the error REP-51002 - Bind to Reports Server rep_fsprod failed. I need to run reports from FORMS including ones with Parameters.
View 1 Replies
View Related
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
Apr 30, 2010
I'm using Dev10g Rel.2....If I call a report with paramform=no and pass it a value from forms then report runs well. but if I call report thru parameter form and pass value from parameter form the report doesn't run with error:
The webpage cannot be displayed.
Interesting fact is that If I call the report from a client on same domain as that of Application Server then it runs even thru paramform. I've also entered the application server I.P and name on other domain's client but no way.
View 1 Replies
View Related
Feb 16, 2010
I want to call a report through forms 6i and i want to send a parameter from forms6i to report 6i. in which i want to take records between two dates.
View 26 Replies
View Related
Jul 19, 2010
I have a report, where there are opening balance and closing balance, so i have to store the closing balance values in a separate table during runtime and should show this closing value as opening balance for next month.
View 24 Replies
View Related
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
