not able to login as oracle on a server !!

[Ravi Kumar Ganti]

I am not able to login a oracle on a HP server. I did su to root from there i tried su - oracle. Its hung for 2 hrs. Can any one suggest

Regards
Amit Manna

[A. Clay Stephenson]

It's difficult to say. I assume that oracle's home directory is a local directory rather than an NFS mount. If not, your problems could well be NFS-related. The most likely culprit is something that oracle's .profile runs so my next step would be to login as root and then "su oracle" (no "-") so that oracle's .profile will not be executed. If that works, you know where to start looking. Don't overlook the obvious so check for full filesystems as well.

[Ravi Kumar Ganti]

HI,
When i login as root and do su to oracle it hangs.

[J. Bravo]

Hi:

Take a look too to the number of process for the user:

ps -fu oracle|wc -l

And compare it with the kernel parameter:

maxuprc (maximum number of simultaneous processes available to each user on the system)

Regards;

J. Bravo.

[Victor Fridyev]

First of all, try to cd ~oracle as user root. If this works, check permissions and ownership of oracle's home directory.

Move .profile, .kshrc ( .cshrc .login ) files and try to use su oracle.

Try to use su for another user in order to understand whether the problem is for oracle user only or the problem is more common.

HTH

[Ravi Kumar Ganti]

We dont have issue with any other user.
only oracle

[RobinKing]

If you turn on inetd logging, does the connection register in the syslog?

inetd -l

[OldSchool]

ok, so the situation is this?

"su - oracle" hangs
"su oracle" hangs
"su - otheruser" works properly
there are no full disks

are there NFS mounted file systems, and are they all mounted / accessible?

is oracle's home directory on an NFS mount?

[Ravi Kumar Ganti]

Yes. Its nfs mounted

Its netapps storage . and storage team says there is no issue with netapps

[Pupil_1]

check the .profile of the oracle user for any unwanted entry !! It's almost always the case with me.

[A. Clay Stephenson]

While the storage people tell you that there is no problem with NFS, I'll bet almost anything that that is exactly where your problems lie. Are you using the automounter (ok autofs now) as well? In conjunction with NIS maps?

Here is how to isolate your problem: On the local machine, create a home directory for oracle (e.g. /tmp/home/oracle) and make sure that it is owned and accessible by user oracle. Copy his .profile or .cshrc to this directory. Finally, change his home directory in /etc/passwd to /tmp/home/oracle. Now try to login as oracle. If that works, you know where the problem lies.

[Steven E. Protter]

Shalom,

Don't try and store keyboard history on NFS. .sh_history or whatever, that causes an automatic hang when the user comes up. Don't set the variable HISTFILE to NFS.

as root.

cd to the home directory of oracle

add a set -x

To the .profile of the oracle user.

su - oracle

look for diagnostics.

SEP

[Dennis Handly]

>SEP: Don't try and store keyboard history on NFS. .sh_history or whatever, that causes an automatic hang when the user comes up.

The only problem is I depend on a common history stack. So years ago before we got all of the proper patches, I had lots of hangs, or I had to have separate history files for "bad" machines.

[whiteknight]

Ganti,

I refer to some Oracle reference, Is the permission correct ?


First, on each node, create the Oracle group. Example:
# groupadd dba -g 501

Next, make the Oracle user's home directory. Example:
# mkdir -p /u01/home/oracle
# useradd -c "Oracle Software Owner" -G dba -u 101 -m -d /u01/home/oracle -s /bin/csh oracle

On each node, Create a mount point for the Oracle software installation (at least 2.5 GB, typically /u01). The oracle user should own this mount point and all of the directories below the mount point. Example:
# mkdir /u01
# chown -R oracle.dba /u01
# chmod -R ug=rwx,o=rx /u01

Once this is done, test the permissions on each node to ensure that the oracle user can write to the new mount points. Example:
# su - oracle

WK