| Configuratin Issue [message #611748] |
Tue, 08 April 2014 07:00  |
musomasu
Messages: 8
Registered: July 2007
|
Junior Member |
|
|
Hi
I am trying to install Oracle xe in Redhat Linux 5.3 ( Tikanga)
Oracle XE 11.2
I installed the user as root in RHEL.
The DB is up. I verified this using ps-ef | grep pmon
[oracle@localhost admin]$ ps -ef | grep pmon
oracle 5584 1 0 15:28 ? 00:00:02 xe_pmon_XE
oracle 20324 5108 0 17:27 pts/1 00:00:00 grep pmon
TNS listerner is up. I verified
[oracle@localhost admin]$ tnsping xe
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 08-APR-2014 17:26:24
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (10 msec)
But when i tried to login using sqlplus
[oracle@localhost admin]$ sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 8 17:28:05 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: system/smk@xe
ERROR:
ORA-12537: TNS:connection closed
Tried with out DB instance name :
Enter user-name: system/smk
ERROR:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 501 (oinstall), current egid
= 502 (dba)
hope i miss some configuration here. I have done the xe installation in centos i did worked with out any issue.
Any suggestions please.
Muthu
|
|
|
|
| Re: Configuratin Issue [message #611752 is a reply to message #611748] |
Tue, 08 April 2014 08:47  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
This will be an issue with file ownership and access modes. Did you run your root.sh script? Set your umask correctly? Logon as a member of the OSDBA group? What is the ownership and modes of the oracle executable?
|
|
|
|
|
|
|
|
|
|
| Re: Configuratin Issue [message #611842 is a reply to message #611835] |
Wed, 09 April 2014 06:25 |
musomasu
Messages: 8
Registered: July 2007
|
Junior Member |
|
|
Hi
Issue resolved after adding the below in /etc/sysctl.conf
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
Thanks for your response
Muthu
|
|
|
|
| Re: Configuratin Issue [message #611844 is a reply to message #611842] |
Wed, 09 April 2014 06:33 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Interesting. I can see no reason why those kernel parameters would have any effect on your problem. The issue you had appears to have been to do with launching server processes, and these parameters are for tuning the network and asynchronous I/O. I usually don't bother to change them from default.
But thankyou for the feedback.
|
|
|
|
| Re: Configuratin Issue [message #611867 is a reply to message #611844] |
Wed, 09 April 2014 09:26 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>Issue resolved after adding the below in /etc/sysctl.conf
I seriously doubt that values below had any impact on the connection failures.
>net.core.rmem_default = 262144
>net.core.wmem_default = 262144
>net.core.rmem_max = 4194304
>net.core.wmem_max = 1048576
>fs.aio-max-nr = 1048576
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
