Skip to content
Advertisements

Archive for

Master Note for Handling Oracle Database Corruption Issues

Very useful document

 

Master Note for Handling Oracle Database Corruption Issues (Doc ID 1088018.1)
Advertisements

Enable SOA Log for EBS 12.1 and 12.2

EBS 12.1

$INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties

Add the lines

SOA_ENABLE_STANDALONE_LOGGING=TRUE

 

Bounce the adoafmctl.sh

and then log file will generate $INST_TOP/soa/SOALog.log

 

EBS 12.2 :

How to Generate File ISGLog.log for SOAP Services in Release 12.2.X? (Doc ID 2008707.1)

Please be note, you need to see the logfile when the transaction are incoming to server

/u01/EBSLEBUAT/fs2/FMW_Home/user_projects/domains/EBS_domain_LEBDEV/servers/oafm_server1/logs

 

 

Database Security Assessment Tool

The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations, users, their entitlements, security policies and identifies where sensitive data resides to uncover security risks and improve the security posture of Oracle Databases within your organization.

You can use DBSAT report findings to:

  • Fix immediate short-term risks
  • Implement a comprehensive security strategy
  • Support your regulatory compliance program
  • Promote security best practices

Download

Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

Installation and test

[orauat@ebsuat dbsat]$ unzip dbsat.zip

Check python installed or not

 

[orauat@ebsuat dbsat]$ python -V
Python 2.7.6

you should install latest version 2.6 or later

Collect :

[orauat@ebsuat dbsat]$ ./dbsat collect system@EBSUAT EBSUAT_OUTPUT

Database Security Assessment Tool version 2.0.2 (May 2018)

This tool is intended to assist in you in securing your Oracle database
system. You are solely responsible for your system and the effect and
results of the execution of this tool (including, without limitation,
any damage or data loss). Further, the output generated by this tool may
include potentially sensitive system configuration data and information
that could be used by a skilled attacker to penetrate your system. You
are solely responsible for ensuring that the output of this tool,
including any generated reports, is handled in accordance with your
company’s policies.

Connecting to the target Oracle database…

SQL*Plus: Release 11.2.0.2.0 Production on Sun Oct 7 14:39:12 2018

Copyright (c) 1982, 2010, 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

Setup complete.
SQL queries complete.
OPatch cannot find a valid oraInst.loc file to locate Central Inventory.
Warning: Exit status 26624 from OS rule: opatch_inventory
OS commands complete.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
DBSAT Collector completed successfully.

Calling /u01/EBSUAT/db/tech_st/11.2.0/bin/zip to encrypt EBSUAT_OUTPUT.json…

Enter password:
Verify password:
adding: EBSUAT_OUTPUT.json (deflated 90%)
zip completed successfully.

 

Report

 

[orauat@ebsuat dbsat]$ ./dbsat report EBSUAT_OUTPUT

Database Security Assessment Tool version 2.0.2 (May 2018)

This tool is intended to assist in you in securing your Oracle database
system. You are solely responsible for your system and the effect and
results of the execution of this tool (including, without limitation,
any damage or data loss). Further, the output generated by this tool may
include potentially sensitive system configuration data and information
that could be used by a skilled attacker to penetrate your system. You
are solely responsible for ensuring that the output of this tool,
including any generated reports, is handled in accordance with your
company’s policies.

Archive: EBSUAT_OUTPUT.zip
[EBSUAT_OUTPUT.zip] EBSUAT_OUTPUT.json password:
inflating: EBSUAT_OUTPUT.json
Traceback (most recent call last):
File “/u01/EBSUAT/dbsat/./sat_reporter.py”, line 6372, in <module>
fn()
File “/u01/EBSUAT/dbsat/./sat_reporter.py”, line 444, in user_section
user_login(profile_dict, acct_profiles)
File “/u01/EBSUAT/dbsat/./sat_reporter.py”, line 1036, in user_login
profile_unset(profiles, users, ‘PASSWORD_LOCK_TIME’, (‘day’, ‘days’))
File “/u01/EBSUAT/dbsat/./sat_reporter.py”, line 1157, in profile_unset
value = sing_plural(int(value), units[0], units[1])
ValueError: invalid literal for int() with base 10: ‘.0416’

Traceback (most recent call last):
File “/u01/EBSUAT/dbsat/./sat_reporter.py”, line 6378, in <module>
sat.end_report()
File “/u01/EBSUAT/dbsat/sat_analysis.py”, line 625, in end_report
xls_book.close()
File “/u01/EBSUAT/dbsat/xlsxwriter/workbook.py”, line 310, in close
self._store_workbook()
File “/u01/EBSUAT/dbsat/xlsxwriter/workbook.py”, line 624, in _store_workbook
allowZip64=self.allow_zip64)
File “/usr/local/lib/python2.7/zipfile.py”, line 732, in __init__
“Compression requires the (missing) zlib module”
RuntimeError: Compression requires the (missing) zlib module
Error: Unexpected error occurred while running DBSAT Reporter.

(The above error occurred when i try to take the report of which i collected json file, But i am not sure why the above error occurred, But the report output created. I need to check this error with oracle support).

 

Refer :

https://docs.oracle.com/cd/E93129_01/

 

ORACLE E-BUSINESS SUITE 12.2.8 RELEASE UPDATE

Oracle is pleased to announce the availability of Oracle E-Business Suite 2018 innovations, which include Oracle E-Business Suite 12.2.8 and other 2018 updates delivered prior to 12.2.8

Refer  :

http://www.oracle.com/us/products/applications/ebs-2018-innovations-5119373.pdf

https://community.oracle.com/thread/4176619

http://learn.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=904&get_params=cloudId:243,objectId:22957

 

ons port connection refused

When I try to open forms, I am getting the below issue

 

FRM-92102: A network error has occurred.
The Forms Client has attempted to reestablish its connection to the Server 1 time(s) without success.
Please check the network connection and try again later.

Details…
Java Exception:
java.io.FileNotFoundException: http://ebsuat.xxx.xx:8005/foms/x

 

So I checked the logfile in opmn.log, it shows

” [ons-connect] Connection e5e,ebsuat.xxxx.xxx,6265 connect (Connection refused) ‘

[appluat@ebsuat scripts]$ netstat -anp | grep 6265
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:6265 0.0.0.0:* LISTEN 1213/opmn

 

Solution :

Please check the hostname entry with localhost, If its, Please remove the hostname entry line on localhost

restart application

[appluat@ebsuat scripts]$ netstat -anp | grep 6265
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 10.1.xxx.xx:6265 0.0.0.0:* LISTEN 1213/opmn

 

Now I can able to open the forms