permission issue

classic Classic list List threaded Threaded
40 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
/u01/oracle/PREPROD/fs2/FMW_Home/webtier/instances/EBS_web_PREPROD_OHS1/diagnostics/logs/OHS/EBS_web_PREPROD/console~OHS~1.log
console~OHS~1.log

EBS_web_PREPROD.rar
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
In reply to this post by Roshan
Hello Erman,

I am gald to inform you the issue got solved. The problem was with the hosts file. I We created the virtual machine from a template in HyperV. I do not know how they configured the network. The localhost was not configured. I entered it manually and I was able to execute adapcctl.sh.

I reconfigured the entire apps tier and it was o.k

Many Thanks!
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Good Roshan.
It was already suspicious,  it was failing "failed to get an IP for the hostname" .
apache's http 204 is a little generic error, it can be throwed:

wallet problems(ssl enabled where it should be disabled)
Permission related (in case of using privileged port in SSL
after an unclean shutdown(httpd.pid permission))
httpd file corruption
disk size problem(when the filesystem is full, even an rpm problem--missing softlink libdb.so.2)
hostname problem(yours)

This issue attacted my attention. Good for you , as you have created this issue :)
You may find further analysis about Apache/OHS used in Oracle EBS 12.2

A little further details show;

The conf file: /u01/install/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1/config/OHS/EBS_web_CLONE

# OHS Listen Port
Listen 8000

The Listen directive tells the server to accept incoming requests only on the specified port(s) or address-and-port combinations. If only a port number is specified in the Listen directive, the server listens to the given port on all interfaces.

[applmgr@demoorcl EBS_web_CLONE]$ netstat -tulpn |grep 8000
tcp        0      0 :::8000                     :::*                        LISTEN      130292/httpd.worker

So, in ipv6 :: means listen to all interfaces (shortway of 0.0.0.0) and the third column seperates the address from listen port.
So our apache listen all interfaces, including localhost, and all of those ip address associated with  these interfaces must be resolvable for starting apache.

So apache listens on IPV6 all addresses:

[root@demoorcl ~]# lsof -Pn | grep LISTEN|grep 8000
httpd.wor 130292   applmgr    4u     IPv6            2013759        0t0        TCP *:8000 (LISTEN)
httpd.wor 130304   applmgr    4u     IPv6            2013759        0t0        TCP *:8000 (LISTEN)
httpd.wor 130450   applmgr    4u     IPv6            2013759        0t0        TCP *:8000 (LISTEN)
httpd.wor 130478   applmgr    4u     IPv6            2013759        0t0        TCP *:8000 (LISTEN)
httpd.wor 130479   applmgr    4u     IPv6            2013759        0t0        TCP *:8000 (LISTEN)

So, Apache listens on Ipv6 but also ,handles ipv4 connections.
"This is done IPv4-mapped IPv6 addresses."

Lets prove it with a little more investigation;

[applmgr@demoorcl bin]$ strings httpd|grep -i ipv6
Oralog API: using low-order bits of IPv6 address as if they were unique
 -D APR_HAVE_IPV6 (IPv4-mapped addresses
make_sock: for address %pI, apr_socket_opt_set: (IPV6_V6ONLY)


strings output:

Server compiled with....
 -D APACHE_MPM_DIR="server/mpm/worker"
 -D APR_HAS_SENDFILE
 -D APR_HAS_MMAP
 -D APR_HAVE_IPV6 (IPv4-mapped addresses
enabled)
 -D APR_USE_SYSVSEM_SERIALIZE
 -D APR_USE_PTHREAD_SERIALIZE
 -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
 -D APR_HAS_OTHER_CHILD
 -D AP_HAVE_RELIABLE_PIPED_LOGS
 -D DYNAMIC_MODULE_LIMIT=%ld
 -D HTTPD_ROOT="$(APACHE2_HOME)"
 -D SUEXEC_BIN="$(APACHE2_HOME)/bin/suexec"
 -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
 -D DEFAULT_ERRORLOG="logs/error_log"
 -D AP_TYPES_CONFIG_FILE="conf/mime.types"
 -D SERVER_CONFIG_FILE="conf/httpd.conf"


Lets look at the httpd binary with -V option.
But in order to do that, we need to set our environment, by learning the environment variables of a running httpd.worker process using /proc filesystem.

export COMPONENT_LOG_PATH=/u01/install/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1/diagnostics/logs/OHS/EBS_web_CLONE/
export COMPONENT_NAME=EBS_web_CLONE
export ORACLE_CONFIG_HOME=/u01/install/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1
export SHELL=/bin/bashNLS_LANG=American_America.AL32UTF8
export COMPONENT_TYPE=OHS
export PERL5LIB=/u01/install/fs2/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi:/u01/install/fs2/FMW_Home/webtier/perl/lib/5.10.0:/u01/install/fs2/FMW_Home/webtier/perl/lib/site_perl/5.10.0:
export PROCESS_INDEX=1
export ORACLE_ADMIN_USERNAME=weblogic
export LD_LIBRARY_PATH=/u01/install/fs2/FMW_Home/webtier/ohs/lib:/u01/install/fs2/FMW_Home/webtier/opmn/lib:/u01/install/fs2/FMW_Home/webtier/lib:/u01/install/fs2/FMW_Home/webtier/opmn/lib:/u01/install/fs2/FMW_Home/webtier/lib
export TEMP=/tmp
exprot EXE_EXT=ORACLE_
export ADMIN_PORT=7001
export OPMN_UID=1254917442
export COMPONENT_CONFIG_PATH=/u01/install/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1/config/OHS/EBS_web_CLONE
export TNS_ADMIN=/u01/install/fs2/FMW_Home/webtier/network/admin
export INSTANCE_NAME=EBS_web_CLONE_OHS1
export SHELL_EXT=.sh
export ORACLE_ADMIN_HOST=demoorcl
export OPMN_INDEX=1
export LANG=en_US.UTF-8
exportPROCESS_UID=1254917442
export COMMON_COMPONENTS_HOME=/u01/install/fs2/FMW_Home/oracle_commonSHLVL=0
export ORACLE_ADMIN_REGISTERED=true
export X_LD_LIBRARY_PATH_64=/u01/install/fs2/FMW_Home/webtier/libINSTANCE_UID=1254917442@EBS_web_CLONE_OHS1TMP=/tmp
export ORACLE_INSTANCE=/u01/install/fs2/FMW_Home/webtier/instances/EBS_web_CLONE_OHS1BAT_EXT=
export ORA_NLS33=/u01/install/fs2/FMW_Home/webtier/nls/data
export STARTEDBYOPMN=true
export ORACLE_HOME=/u01/install/fs2/FMW_Home/webtier
export ORACLE_ADMIN_PROTOCOL=t3SO_EXT=.so

[applmgr@demoorcl bin]$ ./httpd -V
Server version: Oracle-HTTP-Server/2.2.21 (Unix)
Server built:   Mar 26 2013 16:53:37
Server Label:   APACHE_11.1.1.6.0_LINUX.X64_RELEASE
Server's Module Magic Number: 20051115:30
Server loaded:  APR 1.4.5, APR-Util 1.3.12
Compiled using: APR 1.4.5, APR-Util 1.3.12
Architecture:   64-bit
Server MPM:     Worker
  threaded:     yes (fixed thread count)
    forked:     yes (variable process count)
Server compiled with....
 -D APACHE_MPM_DIR="server/mpm/worker"
 -D APR_HAS_SENDFILE
 -D APR_HAS_MMAP
 -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled)
 -D APR_USE_SYSVSEM_SERIALIZE
 -D APR_USE_PTHREAD_SERIALIZE
 -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
 -D APR_HAS_OTHER_CHILD
 -D AP_HAVE_RELIABLE_PIPED_LOGS
 -D DYNAMIC_MODULE_LIMIT=128
 -D HTTPD_ROOT="$(APACHE2_HOME)"
 -D SUEXEC_BIN="$(APACHE2_HOME)/bin/suexec"
 -D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
 -D DEFAULT_ERRORLOG="logs/error_log"
 -D AP_TYPES_CONFIG_FILE="conf/mime.types"
 -D SERVER_CONFIG_FILE="conf/httpd.conf"

So, as seen apache compiled with (IPv4-mapped addresses enabled).. This proves the comment hat I have made for ":::8000"
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
Thanks for the info. I have updated the hosts file as shown below:

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

172.25.43.147  ERPPREP.sunresort.local ERPPREP


#127.0.0.1 ERPPREP.sunresort.local ERPPREP localhost
#::1 ERPPREP.sunresort.local ERPPREP ip6-localhost

The first 2 lines I added.

The 2 lines I have commented(#) was initially in the hosts file. There was no localhost at first.  Do you think I unhash it as you said? What does ip-6 localhost mean?

Thanks,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
make it like this. Only two lines, that's it:

127.0.0.1   localhost.localdomain localhost
172.25.43.147  ERPPREP.sunresort.local ERPPREP
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
The system is now up and running. When users are executing request for customized report it is completing normal with no errors in the log file.

The output is blank screen on browser.

I have cleared the cache.
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Custom report may not return any outputs/ any data?
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Check OPP logs as well.
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
There were no errors in the logs
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Output Post Processor logs?
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
FNDOPP18437.txt

I have just executed the report ID 1449691. Attached the log
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
No errors at all.

[3/24/16 3:31:57 PM] [OPPServiceThread1] Post-processing request 1449691.
[3/24/16 3:31:57 PM] [18437:RT1449691] Executing post-processing actions for request 1449691.
[3/24/16 3:31:57 PM] [18437:RT1449691] Starting XML Publisher post-processing action.
[3/24/16 3:31:57 PM] [18437:RT1449691]
Template code: SRL_AP_INVOICE
Template app:  SQLAP
Language:      en
Territory:     00
Output type:   EXCEL
[3/24/16 3:31:58 PM] [18437:RT1449691] XML Publisher post-processing action complete.
[3/24/16 3:31:58 PM] [18437:RT1449691] Completed post-processing actions for request 1449691.
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Check the output of concurrent request from the Application Tier filesystem, if it is empty and if the seeded/standard XML publisher based reports are able to produce outputs;

transfer this to developer for further diagnostics.
Also , check Oracle® XML Publisher Administration and Developer's Guide
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
Yes I can view the output in the filesystem. You mean it is a developer's issue and not a dba?
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
output is generated ?
I mean when you open the output file using "vi", can you see the output?
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
Yes. In the output folder:

/u01/oracle/PREPROD/fs_ne/inst/PREPROD_ERPPREP/logs/appl/conc/out

The output for request 1449691 is attached.

SRL_AP_INVOICE_1449691_1.xls
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
How did you deployed this report?
Which template did you used?
What did you do for getting concurrent output in excel?
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Create a new issue for this.
This is not related with this issue.
If you need further assistance, create a new issue for this specific concurrent output problem.
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

Roshan
In reply to this post by ErmanArslansOracleBlog
Hi,

are you sure I do not put:

::1 localhost6.localdomain6 localhost6?
Reply | Threaded
Open this post in threaded view
|

Re: permission issue

ErmanArslansOracleBlog
Administrator
Yes.
It is for ipv6.
We have lots of 12.2 customer, not using it , also our /etc/hosts file doesnt include it 

2016-03-29 15:50 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:
Hi,

are you sure I do not put:

::1 localhost6.localdomain6 localhost6?


If you reply to this email, your message will be added to the discussion below:
http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/permission-issue-tp753p848.html
To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML



--

Erman Arslan 

Applications and Database Operations Manager


Oracle Certified Expert

Certified Exadata Administrator

Certified Linux Administrator

Author for Apress

MBA


Blog:      ermanarslan.blogspot.com

Forum:  http://ermanarslan.blogspot.com/p/forum.html

 

M: 05301567803

12