Re: No local connection via sqlplus (TNS:lost contact)

Thorsten:

You may want to check the OS user's .profile between your oracle OS user and the oraload OS user giving you the issue. The areas that you should check are $PATH, all $ORA****** enovironment variables, $LIBPATH, etc... These environment variables' values in both .profile should be identical. You should also check to see whether the OS user, "oraload", is in the OS "dba" group. It seems to me that the file group ownership of the Oracle software installed are oracle:dba. If OS user "oraload" is not in the "dba" group. It may generate the errors that you encountered.

Per OFA, the file group ownership of Oracle SW should be oracle:dbop where oracle belongs to both the dba and dbop groups. The dbop groups is used for creating OS ids for database operators and database administrators should be in the dba group instead.

Hope this help.

Regards,
Stephen Lee Received on Tue Nov 22 2005 - 11:53:07 CST