Home » RDBMS Server » Networking and Gateways » Configuratin Issue (11 G Express Edition )
Configuratin Issue [message #611748] Tue, 08 April 2014 07:00 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #611754 is a reply to message #611752] Tue, 08 April 2014 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Logon as a member of the OSDBA group?
not Windows so above not relevant.
OS user should be member of "dba" group.
Re: Configuratin Issue [message #611830 is a reply to message #611754] Wed, 09 April 2014 05:25 Go to previous messageGo to next message
musomasu
Messages: 8
Registered: July 2007
Junior Member
Thanks for your response This issue got resolved by added few system level parameters in sysctl.conf
Re: Configuratin Issue [message #611835 is a reply to message #611830] Wed, 09 April 2014 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Can you tell us which ones.

Re: Configuratin Issue [message #611842 is a reply to message #611835] Wed, 09 April 2014 06:25 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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 Go to previous message
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
Previous Topic: HA Question
Next Topic: connect sql database from oracle
Goto Forum:
  


Current Time: Thu Mar 28 03:55:47 CDT 2024