- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: root user cannot login into ORACLE
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
тАО10-14-2003 10:17 PM
тАО10-14-2003 10:17 PM
Re: root user cannot login into ORACLE
can you attach your tnsnames and an output of cmviewcl -v command?
Regards,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 10:19 PM
тАО10-14-2003 10:19 PM
Re: root user cannot login into ORACLE
-Database is running on machine a
-User root and taller have the same environment on both machines
This connections should work:
machine a:
- both user can connect with sqlplus
- both user can connect with sqlplus@
machine b:
- both user have to connect to the database with sqlplus@
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 10:20 PM
тАО10-14-2003 10:20 PM
Re: root user cannot login into ORACLE
Try "env|grep -e ORA -e SQL -e TNS" from both accounts and compare results.
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 11:30 PM
тАО10-14-2003 11:30 PM
Re: root user cannot login into ORACLE
-Database is running on machine a
-User root and taller have the same environment on both machines
This connections should work:
machine a:
- both user can connect with sqlplus
DOESN├В┬┤T WORK WITH root USER
- both user can connect with sqlplus@
WORK WITH both USER
machine b:
- both user have to connect to the database with sqlplus@
WORK WITH both USER
Justo & Graham:
I├В┬┤m working with your suggestio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 11:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 01:12 AM
тАО10-15-2003 01:12 AM
Re: root user cannot login into ORACLE
This is the entry on my tnsnames.ora:
SRP5 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SRP5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SRP5)
)
)
Note that SRP5 is the name of the database (SID), this is defined as well in the /etc/hosts file with his own IP address, and the package name is pkgSRP5.
hope this helps,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 01:14 AM
тАО10-15-2003 01:14 AM
Re: root user cannot login into ORACLE
You can probe your tnsnames.ora file with the tnsping command.
Regards,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 01:55 AM
тАО10-15-2003 01:55 AM
Re: root user cannot login into ORACLE
We have almost the same setting as u do. Generally, root don't have ORACLE/BIN in the PATH therefore we can logging from root directly, but I think know the problem.
1) Make sure $ORACLE_HOME/bin is in the PATH
2) Make sure root is in the same group as oracle, generally group name is dba.
3) before logging to svrmgrl or sqlplus, just export the ORACLE_SID
eg. export ORACLE_SID=ORCL
Since I have almost the same configuration, please let me know if this works or not.
Thanks
Sushil Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 03:17 AM
тАО10-15-2003 03:17 AM
Re: root user cannot login into ORACLE
Don├В┬┤t understand anything, but your last TWO_TASK suggestion worked. Any technical explanation?????
There is some things I still don├В┬┤t understand:
We have machine1 and machine2 both with same user and Oracle config, root user on machine1 doesn├В┬┤t have set variable TWO_TASK and can do sqlplus taller/control.
Why is needed TWO_TASK on machine2??????
Ghosts?????
Thanks all for your resp
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2003 03:36 AM
тАО10-15-2003 03:36 AM
Re: root user cannot login into ORACLE
It has the potential to make shared memory inaccessible, and cause all kinds of other nasty issues.
You should immediatly migrate your procedures and practices to use the user that owns the oracle binaries for these operations. If the binaries are owned by root, that setup is NOT supported by Oracle.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com