VMware free self paced e-learning course
https://mylearn.vmware.com/mgrReg/plan.cfm?plan=33611&src=so_5a314d05ddb83&cid=70134000001SkJd
Posts from the ‘Uncategorized’ Category
Jul 3
Can’t locate ADX/util/Sysutil.pm in @INC
When I am trying to change hostname for EBS environment, I used below command to remove server, I am getting below issues
[oraprod@ebsprodcl appsutil]$ ls
bin html install java LEBPROD_ebsprodleb.xml log media out perl scripts sql temp template
[oraprod@ebsprodcl appsutil]$ perl ./bin/adgentns.pl appspass=hqa523AceGr0uP contextfile=/u01/app/oracle/db/tech_st/12c/appsutil/LEBPROD_ebsprodleb.xml -removeserver
Can’t locate ADX/util/Sysutil.pm in @INC (@INC contains: /u01/app/oracle/db/tech_st/12c/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi /u01/app/oracle/db/tech_st/12c/perl/lib/site_perl/5.14.1 /u01/app/oracle/db/tech_st/12c/perl/lib/5.14.1/x86_64-linux-thread-multi /u01/app/oracle/db/tech_st/12c/perl/lib/5.14.1 .) at ./bin/adgentns.pl line 82.
BEGIN failed–compilation aborted at ./bin/adgentns.pl line 82.
Solution :
Please check the perl path
& Environment also was set.
.bash_profile
PATH=$HOME/bin:/u01/app/oracle/db/tech_st/12c/perl/bin:$PATH
export PATH
. /u01/app/oracle/db/tech_st/12c/EBSPROD_ebsprodleb.env
Maintenance Mode enabled in obiee
Maintenance Mode enabled in obiee using runcat.sh
[oracle@obidev catalogmanager]$ ./runcat.sh -cmd maintenanceMode -on -online http://10.1.x.xxx:9704/analytics/saw.dll -credentials /u01/oracle/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/login.txt
BIFNDN_LABEL =BIFNDN_11.1.1.7.0_LINUX.X64_130303.2025
Maintenance Mode is now ON
Change hostname in OEL 7
Method 1 : nmtui tool on terminal
Method 2 : [root@EDB-LEB-4-53 ~]# hostnamectl status
Static hostname: EDB-LEB-4-53.ace-ins.com
Icon name: computer-vm
Chassis: vm
Machine ID: 11cc4d26c75c476db3fa89a66a0fcae9
Boot ID: afc4b181973e40b9ab46ca774e6130c4
Virtualization: vmware
Operating System: Oracle Linux Server 7.0
CPE OS Name: cpe:/o:oracle:oracle_linux:7.0:GA:server
Kernel: Linux 3.8.13-35.3.1.el7uek.x86_64
Architecture: x86_64
[root@EDB-LEB-4-53 ~]# hostnamectl set-hostname ezylebuatdb.damana.com
[root@EDB-LEB-4-53 ~]# hostnamectl status
Static hostname: ezylebuatdb.damana.com
Icon name: computer-vm
Chassis: vm
Machine ID: 11cc4d26c75c476db3fa89a66a0fcae9
Boot ID: afc4b181973e40b9ab46ca774e6130c4
Virtualization: vmware
Operating System: Oracle Linux Server 7.0
CPE OS Name: cpe:/o:oracle:oracle_linux:7.0:GA:server
Kernel: Linux 3.8.13-35.3.1.el7uek.x86_64
Architecture: x86_64
ezyconnect error ORA-12504
[premiadb:oracle:oradb]$ sqlplus apps@”ebsuat.xxxx.com:1586/ebsuat”
SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 11 11:04:08 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Cause :
Syntax issue
Solution :
[premiadb:oracle:oradb]$ sqlplus apps@\”ebsuat.xxxx.com:1586/ebsuat\”
SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 11 11:04:30 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
EBS 12.1.3 Data masking issue with 11.2.0.2
I tried to data mask the EBS 12.1.3 data with database version 11.2.0.2. but After i masked, I can’t open the application because of SYSADMIN and Guest user was missed. So I raised SR, As per support we need to upgrade database version to 11.2.0.3 otherwise we need to do backport activity. If your database version is 11.2.0.2, you need to check with Oracle support before you do data masking.
I upgraded to 12c, it’s working fine.
toad and oracle client are getting ora-12560 tns protocol adapter error after upgraded windows 10
Yesterday morning I came to office, One of my colleague complaint, My toad not working , I am getting “ora-12560 tns protocol adapter error” while connecting to target database through toad.
I asked him when was this issue started , He said, After upgraded my pc to windows 10. I am getting this issue. I told him, My pc also upgraded to windows 10 but I am not getting this issue. I can able to connect target database through toad and Oracle Client too.
Now I am started to fix his pc tns protocal adapter issue. I thought It might be a ORALCE_HOME AND TNS_ADMIN path issue because He installed lot of Oracle Client software like (Dev Suite and Oracle Client and Oracle instant Client) on his pc.
So I just tried change ORACLE_HOME AND TNS_ADMIN path and I tried to open target database through toad, I am getting same issue.
And then I added sqlplus binaries in Oracle instant client and I tried to open, I am getting same issue.
And then I am tried to open through direct connection, I am getting issue.
And then I installed Oracle 12c client, I tried to created tns name using netca, It says ” sgslunUDPNew: unable to create communication endpoint” and getting tns protocol issue.
So I had decided, That issue was not related with Oracle Client, That issue might be due to network problem. So I tried to open that target database with appropriate port using telnet. It says ” telnet could not open connection to port. A system call has failed”.
I checked His PC firewall is blocking or not. But His PC firewall was off. OOPS then I am thinking What is the problem?.
Finally I got the solution from the below link. Please refer here.
Enable DDL logging
Enable DDL Logging:
ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log.
SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean FALSE
SQL> alter system set enable_ddl_logging=TRUE scope=both;
System altered.
SQL> show parameter enable_ddl_logging
NAME TYPE VALUE
———————————— ———– ——————————
enable_ddl_logging boolean TRUE
SQL> select value from v$diag_info where name=’ADR Home’;
VALUE
——————————————————————————–
/premia/app/12c/oracle/diag/rdbms/oradb/oradb
SQL>
SQL> select value from v$diag_info where name=’ADR Home’;
VALUE
——————————————————————————–
/premia/app/12c/oracle/diag/rdbms/oradb/oradb
SQL> conn test/test123
Connected.
SQL> create table invoicenum(invoice number);
Table created.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options
[premiadb:oracle:oradb]$ pwd
/premia/app/12c/oracle/diag/rdbms/oradb/oradb/log/ddl
[premiadb:oracle:oradb]$ cat log.xml
<msg time=’2017-02-21T15:25:47.163+03:00′ org_id=’oracle’ comp_id=’rdbms’
msg_id=’opiexe:4383:2946163730′ type=’UNKNOWN’ group=’diag_adl’
level=’16’ host_id=’premiadb’ host_addr=’10.1.4.66′>
<txt>create table invoicenum(invoice number)
</txt>
</msg>
Reference :
https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302
Listener Exception : Could not create listener: TNS-04414: File error
When I tried to add listner using netca for my test database, I am getting below issue
“Listener Exception : Could not create listener: TNS-04414: File error’
It could be possible ” Listener file having some wrong entries, so you need to check” or renaming current listener and tried to add (Here Please be note, your current listener configuration will be removed).
Nov 22
Configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6
Here I am going to explain how to configure Oracle EBS integrated soa gateway for SOAP services on 12.2.6.
The E business suite integrated soa gateway configuration require a Oracle SOA suite with weblogic on separate server.
Refer the document for how to install
Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)
In this note, Go to
Section 1: Configuring Oracle E-Business Suite Integrated SOA Gateway for SOAP Services on a New Installation of Release 12.2.3 or Higher
In this section , They mentioned to install oracle SOA suite server as per section 4
Here I had chosen the below version of Oracle SOA suite to install on the separate server
- For Oracle SOA Suite 11g and Oracle Applications Adapter 11g on Oracle WebLogic Server 11g
How to Install Oracle SOA Suite:
Download Oracle SOA Suite software from edelivery.oracle.com
Prepare a new linux server for Oracle SOA Suite
Complete all the prerequisites on this server. (See my OBIEE installation guide for complete prerequisites activities)
Install Oracle Database software and create a database for SOA Suite.
Install Jdk (jdk-7u79-linux-x64.rpm)
Create repository creation for SOA
Select the below component while creating repository
–> AS Common Schemas –> Metadata Services
–> SOA and BPM infrastructure –> SOA Infrastructure & Business Activity Monitoring & User Messaging Service
https://docs.oracle.com/cd/E21764_01/doc.1111/e14259/rcu.htm#RCUUG268
Install Oracle weblogic Server 10.3.6
Install Oracle SOA suite
http://docs.oracle.com/cd/E28280_01/install.1111/e13925/install.htm#INSOA209
Configure Oracle SOA Suite
http://docs.oracle.com/cd/E28280_01/install.1111/e13925/configure.htm#INSOA212
Integartion SOA gateway :
Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)
Go to Section 1.1: Setup Tasks on Oracle E-Business Suite Release 12.2.3 or Higher
Here you noted : ASADMIN password change, Try to change user management If you can’t see reset password field , change password using secutiry – users -define.
And also Weblogic and SOA gateway server address should be you mentioned which you are installed Oracle SOA suite server and weblogic server address and ipaddress.
Section 1.2: Configuration Steps on Oracle SOA Suite to Integrate with Oracle E-Business Suite
Once done the above steps, you may go to Integrated SOA responsibility–> select your interface name or internal name and regenerate the wsdl and deploy the SOAP service. please verify can you able to view wsdl file or not. If you can able to view wsdl with soa suite server address, the SOAP service is working fine.
DBA 