Skip to content

User creation with particular directory access through FTP

Requirements :

Create a user

The user should not able to access through terminal like putty…etc

The user Should able to access his custom report directory path only with ftp client

the user need that directory path read and write permission

OS: Redhat 5.6 64bit

Step 1:

check below package are installed or not
[root@ebsdev ~]# rpm -qa|grep vsftpd

Step2 : If its not installed, install below rpm package

[root@ebsdev install]# ls
[root@ebsdev install]# rpm -ivh vsftpd-2.0.5-16.el5_5.1.x86_64.rpm
warning: vsftpd-2.0.5-16.el5_5.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing… ########################################### [100%]
1:vsftpd ########################################### [100%]
Step 3:

[root@ebsdev install]# service vsftpd restart
Shutting down vsftpd: [FAILED]
Starting vsftpd for vsftpd: [ OK ]

Step 4: User creation

[root@ebsdev install]# useradd -g dba ftpuser
[root@ebsdev install]# passwd ftpuser

Step 5: Provide that directory path only access this to ftp user

[root@ebsdev ~]# chmod o+w /u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US

[root@ebsdev install]# usermod -d /u02/backup/appltrng/apps/apps_st/appl/xxace/12.0.0/reports/US ftpuser

step 6: Disabled signon access for terminals

modified the line

[root@ebsdev install]# vi /etc/passwd




Step 7: allow chroot local user in ftp

[root@ebsdev vsftpd]# pwd
[root@ebsdev vsftpd]# vi vsftpd.conf

Add below Bolded line

# You may specify an explicit list of local users to chroot() to their home
# directory. If chroot_local_user is YES, then this list becomes a list of
# users to NOT chroot().

Step 8: restart vsftpd service

[root@ebsdev vsftpd]#service vsftpd restart

step 9: Try to login with credentials in ftp and also putty terminal

You can’t login in putty but you can able to login FTP with home path which directory you configured, you can’t go other directory. you have only that directory access.



Siebel ERP Integration performance issue

Users are always complaint about siebel erp integration performance issue when they are doing push the approval data to erp r12. It will take approximately 2 to 4 minutes.

So I took the awr reports from both database  and crosschecked both with some interval, the siebel database performance is good but erp database saying there is integration related packages sql elasped time little bit more.

So i just went to siebel application and look the all components group log level ,How about ? Yes I found out there some of the components groups logging was enabled to 5, It should not be like always,  So I have decreased the default log level to 1 and clear that web service cache, and then I tried to push the transaction, it completed within 10 seconds.

And also i have disabled SOA auditing feature from ERP, Now data came within 4 seconds.


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

Oracle 12c forms is released

Oracle 12c forms is released now. Please find the download link here

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object

Please follow the note id

Issue When Trying To Generate The Custom WSDL ServiceGenerationError: Error In Service GenerationJ2T-120, ERROR: Illegal Option “-plsqlname=object (Doc ID 1619940.1)

Generate WSDL Command Errors With Inserted value too large for column (Doc ID 1913216.1)

Note : please check translator.jar file permission ,If It doesn’t have group permission , please

chmod g+w translator.jar

EBS 12.2.5 Release Update Pack Available

EBS 12.2.5 Release Update Pack Available (Patch 1967645

ref link EBS 12.2.5

Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://host.domain:8065/webservices/SOAProvider/EbizAuth?Generate= 3527

I have cloned our production environment (EBS version 12.1.3, DB and then I have upgraded the database from to

and later We have requirement to enable integrate SOA gateway. So We were applied all the applicable patches at Production environment and enabled SOA also. So I thinking I have to enable asadmin and then I can able to generate wsdl through SOA. But When I tried , I am getting below error

“Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://xxxxxxx:8065/webservices/SOAProvider/EbizAuth?Generate=3527&soa_ticket=..’ when attempting to perform ‘GENERATE’. Please view Service Provider logs for more details”


http://xxxxxxxx:8065/webservices/SOAProvider/?testquery also return http 404 error.

Usually If we will get the above error If asadmin inactive or apps schema role are not defined for asadmin, So change the asadmin password and then we added the asadmin password in $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml and then restarted service, It will work.

But My case I did all the steps but Still I am getting error.

Solution :

When i upgraded the database 12c R2,  I was missed to add the below parameter in sqlnet.ora and sqlnet_ifile.ora file


After I have added the parameter in both files and restarted the application and database.

Its working fine

How to assign user management responsibility to user

  1. Log in as sysadmin
  2. Go to User management responsibility
  3. In users tab –> username –> Select your username
  4. Assign role –> Security Administrator
  5. Apply

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)