Skip to content
Advertisements

Why EBS URL not working after changed IP Address

Why EBS URL not working after changed IP Address?

 

Your system was configured using HOSTNAME of the machine, you plan to change the IP address of that machine, you changed and restarted the application also, Still Application URL not working, Why?

Stop the application & run autoconfig on the system and start the application, it will work.

Advertisements

Capture FND log error message

Step 1:

select max(log_sequence) from fnd_log_messages

Note the sequence number

Step 2:

Log in as a system administator

Profile –> System

FND: Debug Log Enabled –> Yes

FND: Debug Log Level  –> Statement or options

FND: Debug Log Module –> %

 

Step 3:

Reproduce the issue

 

Step 4:

select max(log_sequence) from fnd_log_messages

 

Step 5:

select * from fnd_log_messages where log_sequence between “first one” and ” last sequence”

 

Spool the file and analyze the log file if you can able to find any issue with this file.

 

RC-00203 RC-50004 AC-00005

I am trying to clone one of our production machines after I upgraded the database to 12.1.0.2.  This clone machine prepared by Veeam Backup. I think the below solution is applicable for VM clone also. Here While I am doing adcfgclone.pl steps, I am getting below issue

done: Port Pool 65 is free
Report file located at /appsutil/out/portpool.lst
RC-00203: Unable to create/write to file /appsutil/out/portpool.lst.
Complete port information available at /appsutil/out/portpool.lst
RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file – /appsutil/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Check Clone Context logfile /u01/app/oracle/db/tech_st/12c/appsutil/clone/bin/CloneContext_0220023028.log for details.

ERROR: Context creation not completed successfully.
For additional details review the file /tmp/adcfgclone_23246.err if present.

 

Solution :

What I did

 

  1. I run adpreclone.pl on both application & database tier
  2. System Team Clone the machine using Veeam Backup
  3. Then I restored the database using backup copy, then I rename the database.
  4. Now I ran adcfgclone.pl steps, I am getting above issue.

On Database Tier node,

1. Set the ORACLE_HOME Path  environment on database tier, Database SID should be a new SID (renamed one)

2. Change hostname & IP address on new server

3. Set TNS_ADMIN Path –>

(copy the Production TNS _ADMIN path, to New path & modify the tnsnames.ora & listener.ora with new SID & hostname)

4. Start the listener

5. Once listener started, create a context file using by

perl adbldxml.pl

6. run auto config

perl adconfig.pl

7. Database configuration part finished

8. Go to application tier,

perl adcfgclone.pl appsTier

 

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

 

ORA-19963 ORA-27041 OSD-04002

While doing restore controlfile to new host in windows server, getting below issue

ORA-19963: error getting logical block size of file F:\BACKUP\O1_MF_S_966071800_
F6C0G8CF_.BKP
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Solution :

Windows, you need to give full permission of directory to users which contents of backup files.

ORA-27102 OSD-00026 O/S-Error: (OS 1455)

I am trying to restore the database to new host, While doing the first step, I try to start the database,

SQL> startup nomount pfile=’F:\backup\init.ORA’;
ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated

ORA-00600: internal error code, arguments: [kmgs_component_init_5], [15], [], []
, [], [], [], [], [], [], [], []

 

Solution :

The below error message appeared in the alert log file.

ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete.
Mon Jan 22 14:21:37 2018
Error: Failed to allocate SGA start_addr 00000007D0000000 size 134217728

It seems to be a Memory issue on the server. I have crosschecked the server RAM and init.ora file Memory target size.  The Server RAM size is lesser than memory target size. so I have adjusted the memory target size in init.ora file according to the Server RAM and tried to start the database as a nomount stage, its okay.

Or you need to increase RAM on the server if you need more.

Oracle 12c SE2 installation guide on OEL 7.4

Please find the document here

Oracle 12c SE2 installation guide on OEL 7

Start and stop firewall OEL 7

Check the status

[root@ezylebuat ~]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2018-01-17 06:37:59 EST; 24min ago

Stop the firewall

[root@ezylebuat ~]# systemctl  firewalld stop

[root@ezylebuat ~]# systemctl status firewalld
● firewalld.service – firewalld – dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Wed 2018-01-17 07:04:09 EST; 3s ago
Docs: man:firewalld(1)

Disable the firewall( After reboot,It will not enable automatically)

[root@ezylebuat ~]# systemctl disable firewalld

Enable the firewall

[root@ezylebuat ~]# systemctl enable firewalld

Start the firewall

[root@ezylebuat ~]# systemctl  firewalld start

The security token could not be authenticated or authorized

Client received SOAP Fault from server: The security token could not be authenticated or authorized Please see the server log to find more detail regarding the exact cause of the failure.Error while calling Oracle web service.

Solution:

SOAP Wsdl granted user password might be changed. Please check

 

12c SQL loader express mode

In Oracle Database12c, SQL*Loader has a new feature called express mode that makes loading CSV files faster and easier. With express mode, there is no need to write a control file for most CSV files you load. Instead, you can load the CSV file with just a few parameters on the SQL*Loader command line.

Example :

SQL> create table dept(deptno number,deptname varchar2(20),deptlocation varchar2(20));

Table created.

SQL> desc dept;
Name Null? Type
—————————————– ——– —————————-
DEPTNO NUMBER
DEPTNAME VARCHAR2(20)
DEPTLOCATION VARCHAR2(20)

oracle:oradb]$ cat testload.dat
001,IT Dept,Riyadh
002,Accounting,Riyadh
003,HR Dept,Bahrain

 

[premiadb:oracle:testdb]$ sqlldr userid=testme data=testload.dat table=dept
Password:

SQL*Loader: Release 12.1.0.2.0 – Production on Mon Jan 15 09:28:42 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Express Mode Load, Table: DEPT
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO

Table DEPT:
3 Rows successfully loaded.

Check the log files:
dept.log
dept_%p.log_xt
for more information about the load.
[premiadb:oracle:testdb]$ sqlplus testme

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 15 09:28:58 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Enter password:
Last Successful login time: Mon Jan 15 2018 09:28:45 +03:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select * from dept;

DEPTNO DEPTNAME DEPTLOCATION
———- ——————– ——————–
1 IT Dept Riyadh
2 Accounting Riyadh
3 HR Dept Bahrain

 

For more detail, Please refer

http://www.oracle.com/technetwork/database/enterprise-edition/learnmore/sqlldr-express-mode-wp-1991038.pdf