Skip to content

Posts from the ‘Uncategorized’ Category

ORA-24247: network access denied by access control list (ACL)


SQL> begin
2 3 4
5 /
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 19
ORA-06512: at “SYS.UTL_TCP”, line 280
ORA-06512: at “SYS.UTL_SMTP”, line 163
ORA-06512: at “SYS.UTL_SMTP”, line 199
ORA-06512: at “SCOTT.SEND_MAIL”, line 8
ORA-06512: at line 2

This error message means that no access control list has been assigned to the host you (your application) are trying to access, or no required privileges have been granted to the user by adding user to the ACL.

Solution :

Step 1:

SQL> grant execute on utl_http to scott;

Grant succeeded.

Step 2:  Conn as sysdba

acl => ‘scottdev.xml’,
description => ‘Permissions to access  mail’,
principal => ‘SCOTT’,
is_grant => TRUE,
privilege => ‘connect’,
start_date => SYSTIMESTAMP,
end_date => NULL);

PL/SQL procedure successfully completed.

Step 3:

SQL> begin
3 acl => ‘scottdev.xml’,
4 principal => ‘SCOTT’,
5 is_grant => true,
6 privilege => ‘resolve’
7 );
9 END;
10 /

PL/SQL procedure successfully completed.

Step 4:

acl => ‘scottdev.xml’,
host => ‘*’);


Step 5:

select acl , host , lower_port , upper_port from DBA_NETWORK_ACLS;

select acl , principal , privilege , is_grant from DBA_NETWORK_ACL_PRIVILEGES

Step 6: Send mail as scott user

SQL> begin
end; 2 3
4 /

PL/SQL procedure successfully completed.


Drop ACL :

acl => ‘scottdev.xml”);


failed to create user while installing oracle 12c in windows server 2012 R2

When  I am trying to install oracle 12c software in windows server 2012 r2, Its asking the windows user credentials. So I had given the windows new user “Test” and password like ” Test@123″ . Oracle installer accepted this password but windows not accepted this password because of password poilcy.

  • Atleast 8 characters inlcude letter, number, symbol
  • Also Don’t put your password letter as same like user name. It should not be identical.

Example :

User : Test

password : P@ssw0rd

ORA-16038 ORA-19809 ORA-00312

Database startup fails:

ORA-16038: log one sequence 3144 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312 online log 1 thread 1 <path to redo log file>

In the alert.log:
ORA-16014 signalled during: ALTER DATABASE open …
ORA-19815: WARNING: db_recovery_file_dest_size of xxx bytes is 100.00% used, and has 0 remaining bytes available.

solution :

support id : Flash Recovery Area Full – Database Fails to Open ORA-16038 (Doc ID 337258.1)

Linux shell script to monitor space usage and send email


LC_ALL=C df -hP | column -t | grep -vE ‘^Filesystem|tmpfs|cdrom’ | awk ‘{ print $5 ” ” $1 }’ | while read output;
echo $output
usep=$(echo $output | awk ‘{ print $1}’ | cut -d’%’ -f1 )
partition=$(echo $output | awk ‘{ print $2 }’ )
if [ $usep -ge 90 ]; then
echo “Running out of space \”$partition ($usep%)\” on $(hostname) as on $(date)” |
mailx -s “Alert: Almost out of disk space $usep%”

Disable cache obiee 11g

You can able to disable the cache from Fusion middleware enterprise manager console. No need to manul edit in NQSConfig.ini file


Go to :

Business Intelligence –> coreapplication –> select Capacity Management tab –> Select Performance tab –> click “Lock and Edit configuration”  –> deselect the cache enabled –> apply –> activate changes

Restart the BI services

Enterprise Manager is not able to connect to the database instance

Solution :

check the sysman and dbsnmp account status, If expired, please activate
SQL> select username,account_status from dba_users where username =’SYSMAN’;

—————————— ——————————–

SQL> select username,account_status from dba_users where username =’DBSNMP’;

—————————— ——————————–


So sysman account has been expired.  Please activate with old password and also Please check if this account has been locked, please unlock this account.


SQL> alter user sysman identified by Admin123;

User altered.

SQL> select user,account_status from dba_users where username=’SYSMAN’;

—————————— ——————————–

SQL> alter user sysman account unlock;

User altered.


It will work after start the dbconsole



No Oracle instances were discovered do you want to enter one

While try to configure Backup exec agent in database server

“No Oracle instances were discovered do you want to enter one”


add the instance value in /etc/oratab

Oracle 12c ( database step by step installation guide on redhat linux 5.6


Download Document here

Oracle 12c database installation guide on redhat linux 5.6

Is any email configuration required for Oracle Alert manager?

Yes. If once you email configured on workflow notification mailer, It will automatically send alert mail to you .No need to configure in oracle alert manager mail server options.

So please check it, Whether workflow notification mailer running or not.

Increase space in Linux Volumegroup while running linux in vmware

If you like to increase space in linux volume group, you can do it on while machine up.

Afer added harddisk on existing hard disk. you can’t identify that hard disk on machine. So in this case you need to rescan the hard disk using below command.

$echo ‘1’  > /sys/class/scsi_disk/0:0:2:0/device/rescan

Suppose to be you’re added that hard disk after shutdown the machine. No need to rescan that harddisk

My case I shutdown the machine and added that hard disk in vmware workstation ( note: I think workstation you can’t expand hard disk while machine running)

Step 1:

Check Hard disk and space

[root@localhost dev]# df -h

Filesystem Size Used Avail Use% Mounted on
23G 2.9G 19G 14% /
/dev/sda1 99M 13M 82M 14% /boot
tmpfs 502M 0 502M 0% /dev/shm

Step 2:

[root@localhost dev]# fdisk sda

The number of cylinders for this disk is set to 3916.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs

Command (m for help): p

Disk sda: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot Start End Blocks Id System
sda1 * 1 13 104391 83 Linux
sda2 14 2610 20860402+ 8e Linux LVM
sda3 2611 3263 5245222+ 8e Linux LVM

Step 4:

Here Note the Last Cyclinder value is 3263. So your new partition should be start from Last Cyclinder value + 1 like 3264

Command (m for help): n
Command action
e extended
p primary partition (1-4)
Selected partition 4
First cylinder (3264-3916, default 3264):
Using default value 3264
Last cylinder or +size or +sizeM or +sizeK (3264-3916, default 3916):
Using default value 3916

Command (m for help): t
Partition number (1-4): 4
Hex code (type L to list codes): 8e
Changed system type of partition 4 to 8e (Linux LVM)

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.

WARNING: Re-reading the partition table failed with error 16: Device or resource busy.
The kernel still uses the old table.
The new table will be used at the next reboot.
Syncing disks.

Step 6:

No need to reboot If you use this below command

[root@localhost dev]# partprobe -s

/dev/sda: msdos partitions 1 2 3 4

Step 7:

[root@localhost dev]# vgextend VolGroup00 /dev/sda4
No physical volume label read from /dev/sda4
Physical volume “/dev/sda4” successfully created
Volume group “VolGroup00” successfully extended
[root@localhost dev]# lvextend /dev/VolGroup00/LogVol00 /dev/sda4
Extending logical volume LogVol00 to 27.91 GB
Logical volume LogVol00 successfully resized
[root@localhost dev]# resize2fs /dev/VolGroup00/LogVol00
resize2fs 1.39 (29-May-2006)
Filesystem at /dev/VolGroup00/LogVol00 is mounted on /; on-line resizing required
Performing an on-line resize of /dev/VolGroup00/LogVol00 to 7315456 (4k) blocks.
The filesystem on /dev/VolGroup00/LogVol00 is now 7315456 blocks long.

Step 8: Check the hard disk size now

[root@localhost dev]# df -h
Filesystem Size Used Avail Use% Mounted on
28G 2.9G 23G 12% /
/dev/sda1 99M 13M 82M 14% /boot
tmpfs 502M 0 502M 0% /dev/shm