Shell Script Throwing Permission Denied Error Message?

Nov 1, 2012

I am learning oracle DBA training course. I tried to find disc space and mail alert .I got permission denied error message.I was running this script in my own pc.

CODE    #!/bin/sh
    # Shell script to monitor or watch the disk space
    # It will send an email to $ADMIN, if the (free avilable) percentage
    # of space is >= 90%
  
[code]...

View 14 Replies


ADVERTISEMENT

RMAN Backups On NFS Device Error - Permission Denied

Nov 25, 2011

I receive errors when trying to backup my database (version 9.2.0.2.0) to an NFS device.

I mounted the NFS device in the HP-UX 11.11 server with the folowing comand :

CODEmount -F nfs -o hard,rw,rsize=32768,wsize=32768,suid,proto=tcp ip_adress:/nfs/RMAN_BACKUPS /rman_backups

the device is succefully mounted.

drwxrwxrwx 2 99 100 17 Nov 25 16:17 rman_backups

When i begin a backup with rman i receive the folwing error :

CODEcanal ORA_DISK_1 : dM-imarrage de l'M-ilM-iment 1 dans 25/11/11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/25/2011 16:35:00
ORA-19504: Echec de crM-iation du fichier "/rman_backups/DB_6jmsi811_1_1.bkupset"
ORA-27041: ouverture du fichier impossible
HP-UX Error: 13: Permission denied
Additional information: 2

Gestionnaire de rM-icupM-iration (Recovery Manager) terminM-i.

It say permission denied but it is set to drwxrwxrwx and i can create and change any file in the directory.

View 3 Replies View Related

TNS Permission Denied?

Jul 12, 2011

I can connect to a database instance using toad. But I can not connect to the instance through sqlplus. Its says TNS permisson denied ora-12546. However I can connect to other instances on other machines. If there were any permission issues on client oracle directories then I would not be able to connect to other machines with other instances.

I am using Oracle 11g client on windows 7 64 bit and I am connecting to oracle server Linux 32 bit

View 8 Replies View Related

Forms :: PERMISSION DENIED While Setting Value Path

Oct 13, 2012

At the time of installing developer 6i am getting the above error,at the stage of selecting the path for forms its throwing the above error saying the permission denied in setting the value path....

does any one come across this type of error before...

View 1 Replies View Related

Windows :: ORA-12546 - Permission Denied At Database Configuration Assistant

Jun 12, 2011

While I am installing oracle 10g on vista i am getting the error ora-12546:tns:permission denied at database configuration Assistant.

View 1 Replies View Related

ORA-27369 / Job Of Type EXECUTABLE Failed With Exit Code / Permission Denied

Mar 21, 2013

I have created a simple external job to run export (expdp) job to be run from PL/SQL. When I create a job as SYS user, the job runs good but the same fails when I execute it as application user. I am certain that I am missing some privileges.

Below is the job:

BEGIN
dbms_scheduler.create_job(
job_name => 'mytestjob',
job_type => 'executable',
job_action => '/u01/myexpdp.sh',
enabled => TRUE,

[code]....

View 8 Replies View Related

SQL & PL/SQL :: Clob Is Capable Of 4gb But Throwing Error

Aug 29, 2012

I am getting error when trying to execute following. Clob is capable of 4gb why it is throwing error.

DECLARE
l_char1 CLOB;
BEGIN
l_char1 := l_char1 ||rpad('*', 32768, '*');
END;

View 11 Replies View Related

Windows :: Error / Cannot Delete OCI / Access Denied

Mar 23, 2005

I got an error while trying to install Oracle 9i on a Win XP machine. So, I decided to wipe out Oracle completely and starting again. I deleted all the Oracle entries from the registry and then tried deleting the folder. But while doing that, I am getting the following error - "Cannot delete oci:Access denied"

The disk is neither write-protected nor is the oci.dll file in use.

View 18 Replies View Related

Getting ORA-01017 Error Invalid Username / Pwd Logon Denied

Oct 19, 2010

i am getting ORA-01017 error frequently .

we have an application that is running from remote host to connect database using JDBC driver 10.2.0.2

but i am getting ORA-01017 error intermittently. we fetching stored username/pwd after every 5 min but for certain interval it's giving error and we get connection sucessful after some time with same username pwd.

the application monitor more number of databases but facing problem with only 1 instance.

View 1 Replies View Related

Real Application Clusters :: Database Not Starting Up - Permission Error

Nov 19, 2012

I recently installed 2 node Oracle 11g RAC on RHEL5. While creating Clustered Database, database creation on second node (racnode2) failed. So, I connected */ as sysdba* on the node and executed startup only to get this error message:

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+RACDB_DATA/RACDB/spfileRACDB.ora'
ORA-17503: ksfdopn:2 Failed to open file +RACDB_DATA/RACDB/spfileRACDB.ora
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 13: Permission denied
Additional information: 196612
Additional information: 10
SQL>But, *'+RACDB_DATA/RACDB/spfileRACDB.ora'* is present.

I strongly believe it is a permission issue that ORACLE owned processes are not able to access disks owned by GRID user. I checked the permission of disks:

[oracle@racnode2 ~]$ cd /dev/oracleasm/disks
[oracle@racnode2 disks]$ ls -l
total 0
brw-rw---- 1 grid asmadmin 8, 65 Nov 19 19:15 CRSVOL1
brw-rw---- 1 grid asmadmin 8, 49 Nov 19 19:15 DATAVOL1
brw-rw---- 1 grid asmadmin 8, 81 Nov 19 19:15 FRAVOL1
[oracle@racnode2 disks]$And also, ORACLE user has asmdba among other privileges.

[oracle@racnode2 disks]$ id
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1201(asmdba),1300(dba),1301(oper) context=user_u:system_r:unconfined_t

I am willing to furnish further data.

View 10 Replies View Related

TNS Listener Throwing ORA-12514?

Mar 29, 2011

Our Oracle database was working fine up until last Thursday, now, for reasons unknown, Oracle is refusing connections. I have done a lot of reading about this error and I have performed all of the recommended actions to no avail. The actions I have performed are (see [URL])...

- Wait a moment and try to connect a second time. Yes, did that, probably 1,000 times - same results.
- Check which services are currently known by the listener by executing: lsnrctl services <listener name> And here are those results (I replaced some of the private stuff with x's)...
C:\Documents and Settings\xxxxx.xxxxx>lsnrctl services orcl

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 29-MAR-2011 06:26:01

Copyright © 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx.xxxxx.com)(PORT=1521))(CONNEC
T_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
Services Summary...

[code]...

Why does the service PLSExtProc show up but not orcl? I don't get this but that's how its been since installation and as I said, it worked fine until last Thursday.

Here is what my TNSNAMES file looks like (again, replaced private info)...

# tnsnames.ora Network Configuration File: \oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx.xxxxx.com)(PORT = 1521))

[code]...

- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener. See above.
- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener. I don't know what this is.
- Check for an event in the listener.log file. There are a ton of them ... here is one of the entries...
29-MAR-2011 06:44:56 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)(CID=(PROGRAM=C:\Workspace\PDS\DS_App\DS_Engine\bin\Debug\DS_Engine.exe)(HOST=SPATCDT021)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2.113.85)(PORT=2499)) * establish * ORCL * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

View 3 Replies View Related

Keep Getting PLS-00306 Error Message?

Aug 26, 2013

I keep getting PLS-00306 error message.

I am also getting an error that the statement was ignored.

View 5 Replies View Related

SQL & PL/SQL :: Creating Custom Error Message

Apr 24, 2013

I am trying to create my own error message but when ever i used sp_addmessage it gives error sp2-0734 unknown command biggning... what to do?

View 12 Replies View Related

SQL & PL/SQL :: Error Message In Execute Immediate Command

May 30, 2012

I have created a procedure, which should be executed on the below condition with EXECUTE IMMEDIATE COMMAND. But i am getting error.

The error shows the procedure/function name is not existing. But it is exist.

SQL>
1 Declare
2 a varchar2(20);
3 b varchar2(20);
4 c varchar2(1000);
5 begin
6 select to_char(sysdate,'day') into a
7 from dual;
8 select to_char(sysdate,'HH24') into b
9 from dual;
10 if
11 (a='friday' and b>=22)
12 or
13 (a='saturday' and b<=6)
14 or
15 (a='wednesday' and b>=9)
16 then
17 begin
18 EXECUTE IMMEDIATE ('begin'||BACKUP_AUTO_execute_bat_file||'end;');
19 end;
20 else
21 null;
22 end if;
23* end;
SQL> /
EXECUTE IMMEDIATE ('begin'||BACKUP_AUTO_execute_bat_file||'end;');
*
ERROR at line 18:
ORA-06550: line 18, column 32:
PLS-00222: no function with name 'BACKUP_AUTO_EXECUTE_BAT_FILE' exists in this
scope
ORA-06550: line 18, column 4:
PL/SQL: Statement ignored

View 6 Replies View Related

PL/SQL :: EXCEL TEMPLATE Error Message?

Oct 31, 2013

i have a xml sheet which contain 30 attributes,and only because of one attribute i got this error when i preview my xls sheet and the rest 29 attribute is working correctly.

   Start Excel Previewonly open: falsemTemplate: C:Documents and Settingsesys36Local SettingsApplication DataOracleBIPublisherTemplateBuilderforExcel mp mp mp.xlsmTmpTemplate: C:Documents and Settingsesys36Local SettingsApplication DataOracleBIPublisherTemplateBuilderforExcel mp/tmp.xlsjava.lang.NumberFormatException: multiple points    at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)    at java.lang.Double.valueOf(Unknown Source)    at oracle.xdo.template.excel.render.BookDataWriter.copyCell(BookDataWriter.java:766)    at

[code]....

View 1 Replies View Related

Error Message When Attempting To Create 3rd Column

Jul 26, 2010

I've set up a query that creates 2 columns 'UVLCredit' and 'UVLDebit' and what I'm trying to do is subtract the 'UVLDebit' column from the 'UVLCredit' column and have the resulting value show up in a column called 'UVLTotal.

I'm multiplying 1 column times another to create a new column called UVLCredit, and then doing it again (with a different column) to create a 2nd new column called UVLDebit...the last thing I'm trying to do is to take the results of the 1st new column and subtract the results of the 2nd newly created column to create a 3rd new column called UVLTotal. The error states that the 'UVLDebit' column is an invalid identifier.

See code below....

CODESELECT          
T.PO_RELEASE_NBR, T.PO_LINE_STATUS, T.FACILITY,        
TI.STATUS_DATE, TI.QTY_ORDERED_UP,
TI.PO_UNIT_PRICE, TI.QTY_REC_TOTAL_UP, TI.QTY_INVOICED_UP,
[b]sum(TI.PO_UNIT_PRICE) * (TI.QTY_REC_TOTAL_UP) as "UVLCredit",
sum(TI.PO_UNIT_PRICE) * (TI.QTY_INVOICED_UP) as "UVLDebit",
[code]........        

View 3 Replies View Related

Server Utilities :: SQL Loader Error Message?

Oct 6, 2000

When I try to load a .TXT file into an Oracle table, the following message is given at the command prompt;

SQL*Loader-524: partial record found at end of datafile

and the load is not successful. The control file is as follows;

Load Data
INFILE 'c:spledlsubj.txt'
APPEND
INTO TABLE tblSubjectiveCode

[code]...

Could the .TXT file causing any problems ?

View 7 Replies View Related

Forms :: Error Message - Could Not Reserve Record (2 Tries) Keep Trying

Apr 21, 2011

when i running my form i m receiving this error message Error Message is "Could not reserve record (2 tries) keep trying ? " This is due to multi user Login, How can i avoid from this error message.

View 26 Replies View Related

Error Message When Debugging Dynamic Sql Procedure?

Nov 13, 2007

I get this error message when debugging this dynamic sql procedure:

ORA-00922: missing or invalid option
ORA-06512: at "PLANNING_PWR.RUNNING_TIMES_EXP", line 66
ORA-06512: at line 12

I cannot find where the error is.

CREATE OR REPLACE
procedure running_times_exp(p_table_name IN VARCHAR2,
p_pattern in varchar2,
p_f_date IN DATE,

[code]...

View 6 Replies View Related

Application Express :: How To Make Error Message Red

May 20, 2013

A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,

I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?

View 2 Replies View Related

Server Administration :: Error Message In Oracle Scheduler

Apr 10, 2012

I want to create a schedule as below. But it shows error message which i cant understand.

begin
DBMS_SCHEDULER.CREATE_jOB(
job_name => 'Alert_monitor',

[Code]....

Here is the error message.

Error at line 1
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

View 3 Replies View Related

(failed To Close File) Error Message While Backing Up DB?

May 30, 2012

We have been getting the below error message, while backing up the DB(Full DB backup) via netbackup. The DB version is 10.2.0.3 (64bit). The archive backup goes fine. the problem is with the full backup.

input datafile fno=00241 name=/u106/oradata/iwhdbqa/iwh_mvlog_01x.dbf
channel CH02: starting piece 1 at 29-MAY-12
RMAN-03009: failure of backup command on CH01 channel at 05/29/2012 21:41:28
ORA-19506: failed to create sequential file, name="iwhdbqa_20120529210533_db_ipnc7n6l_1_1", parms=""

[code]...

I came to know that this is a netbackup configuration/client bug. Can we do something from the oracle side.

The RMAN COMMAND STRINGS we use is as follows:

SET SNAPSHOT CONTROLFILE NAME TO '/u101/app/oracle/product/10.2.0.5/db_1/dbs/iwhdbqa_snapshot_db.snap';
RUN {
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1' ;
SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_POLICY=iwh-dbqa_oracle, NB_ORA_CLIENT=iwh-dbqa-bu';
ALLOCATE CHANNEL CH02 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1' ;

[code]...

View 3 Replies View Related

PL/SQL :: Not Getting Error Code And Message Back In Calling Proc?

Sep 19, 2012

create or replace package body test_exp_pkg as

procedure l_test_exp (errcode out Varchar2, errm out varchar2)
as
l_rec zt574%rowtype;
begin

[code]]....

output:
---------
anonymous block completed
in package init
caught in l_test_exp-1422ORA-01422: exact fetch returns more than requested number of rows
caught in l_test_exp errcode and errm set to -1422sqcORA-01422: exact fetch returns more than requested number of rows
caught in test_exp1User-Defined Exception
caught in others errcode and errm

View 8 Replies View Related

SQL & PL/SQL :: Create Test Table - Trigger Throw Error Message

Mar 4, 2010

create table test123 as (unit varchar2(5),qty varchar2(25));
insert into test123('ABC','10,40,50');
insert into test123('PQR','20,30,40,10');
insert into test123('XYZ','20,10,70');

I have a table called test123 which qty field. if the sum of qty is entered more than 100 or less than 100, it should throw error.

I wrote this trigger..but it is not working.

create or replace restrict_sum
after insert or update of qty on test123
for each row
declare
v_sum number;
[code].........

View 5 Replies View Related

Oracle Error Message - Click On (Administration) Login Page Is Opening?

Feb 22, 2013

i have successfully installed Oracle 10g in Windows 7 ultimate but there is one problem after installation of Oracle 10g an Oracle Enterprise Manager 10g have opened immediately after installation.

when i have sign in with
username: sys
passwd: oracle
connect as: SYSDBA

iam getting this error message      
"Error
java.lang.Exception: Exception in sending Request :: null"

& then when i click on "Administration" again the login page is opening.i have tried installing Oracle 10g 4 times this is 5th time .

View 3 Replies View Related

Reports & Discoverer :: Error Message When Passing The Report Parameter From Command Line?

Jan 31, 2012

I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file

REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output

the batch file is as follows

D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'

View 1 Replies View Related

Forms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message

Jan 15, 2013

I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".

I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.

View 2 Replies View Related

Can't Connect To Oracle - Logon Denied

Mar 21, 2011

i installed Oracle 11.2.0 64bit & Oracle SQL developer 2.1.1.64 on Windows-7 64bit

i try to connect to database like this:

username: scott
password: tiger
role : sysdba
hostname: localhost
port : 1521
sid : ORCL

and i got this error: `ora-01017 invalid username/password; logon denied`

View 3 Replies View Related

SQL Query To Grant Permission?

Oct 6, 2012

I want sql querys for following scenarios

Owner of the compant wants to create 5 users,3 in following fashion

1) 2 -Must have authority of admin

2) 2- Normal user

3) 1 - User whose password is blocked for 15 days

View 10 Replies View Related

Finding Permission Tables

May 30, 2011

How to find the list of tables which has permission select only and tables which has both read and write access permission for a particular user.

I'm using ORACLE database.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved