- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 10g - Only root and oracle can connect
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2009 05:27 AM
тАО04-23-2009 05:27 AM
Oracle 10g - Only root and oracle can connect
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2009 11:18 AM
тАО04-23-2009 11:18 AM
Re: Oracle 10g - Only root and oracle can connect
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2009 12:28 PM
тАО04-23-2009 12:28 PM
Re: Oracle 10g - Only root and oracle can connect
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-23-2009 12:51 PM
тАО04-23-2009 12:51 PM
Re: Oracle 10g - Only root and oracle can connect
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2009 03:15 AM
тАО04-24-2009 03:15 AM
Re: Oracle 10g - Only root and oracle can connect
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