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 (more...)
2 3 4
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 (more...)
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.
Oracle 12c forms is released now. Please find the download link here
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 (Patch 1967645
ref link EBS 12.2.5
I have cloned our production environment (EBS version 12.1.3, DB 22.214.171.124) and then I have upgraded the database from 126.96.36.199 to 188.8.131.52.
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 (more...)
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.
support id : Flash Recovery Area Full – Database Fails to Open ORA-16038 (Doc ID 337258.1)
There are three ways of creating a pluggable database from an existing non-CDB:
• Using the DBMS_PDB package to generate metadata and then creating the pluggable database
with CREATE PLUGGABLE DATABASE SQL statement
• Data Pump (using the transportable tablespace feature)
• GoldenGate replication
When using the DBMS_PDB package to convert a non-CDB to a pluggable database, the non-CDB must be Oracle12c or higher.
Take care of your Non CDB and CDB chraceter set (more...)