Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 10g - Only root and oracle can connect

Mark_Windish
Occasional Visitor

Oracle 10g - Only root and oracle can connect

Hello,

Running HP-HX PARISC 64bit. Recently upgraded from Oracle 8.1.7 to 9.2.0.8 with no issues. Now, for various reasons, we have a need to upgrade to 10g. The database is running, and everything seems to be fine, except when users attempt a connection. The connection fails with a generic 366 error on the application end, with nothing in the Oracle logs.

However, when I connect from the local machine or a client machine, as root or oracle, everything works as expected. Obviously I could add users to the dba group so that they can connect...but I know better. If I open permissions up on the oracle directories (755), I can no longer connect as root, nor can I connect with SQL Plus.

Any insight would be appreciated.

Mark
4 REPLIES
Mark_Windish
Occasional Visitor

Re: Oracle 10g - Only root and oracle can connect

Nevermind...the answer was, in case anyone else runs into this:

chmod 755 on the following directories in $ORACLE_HOME:

/bin
/lib
/oracore (including subdirectories and mesg files)
/sqlplus (including subdirectories and mesg files)

Thanks,
Mark

Re: Oracle 10g - Only root and oracle can connect

Mark,

There is also a script in $ORCACL_HOME/install called changePerm.sh which relaxes permissions on some of the Oracle files to allow non-root/oracle users to use sqlplus, etc.

Regards,
Rich
Mark_Windish
Occasional Visitor

Re: Oracle 10g - Only root and oracle can connect

Rich,

Thanks for that information. While I do see that script in my 9i home, I do not see it anywhere in 10g. Although, if I had known about it, I would have modified it for 10g, and gave it a try :)

Thanks again,
Mark
Eric Antunes
Honored Contributor

Re: Oracle 10g - Only root and oracle can connect

Hi Mark,

You need to check with your application vendor if it is certified for Oracle 10g.

Web applications usually connects to the Oracle database trought Oracle Application Server (OAS), so it may be your OAS version isn't compatible with the apps and/or the database. So, if your apps uses OAS, what OAS version do you have?

Best Regards,

Eric Antunes
Each and every day is a good day to learn.