- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- 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
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
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 08:19 PM
10-14-2003 08:19 PM
We have a 2-party cluster with HPD230 servers and Oracle 8.0.4 binaries on each machine. Tablespaces lie on a shared discs box.
root user on machine2 cannot login into ORACLE when machine1´s root can.
Checking up on environment variables was OK (I think so).
Any suggestion on any aditional cheking???
Thanks for your tim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 08:25 PM
10-14-2003 08:25 PM
Re: root user cannot login into ORACLE
What are you using to connect, and what is the error message?
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 08:26 PM
10-14-2003 08:26 PM
Re: root user cannot login into ORACLE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 08:43 PM
10-14-2003 08:43 PM
Re: root user cannot login into ORACLE
if you are using "svmgrl" to connect to the database, your root-User have to be in Database Administrator Group (mostly dba)
Christian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 09:08 PM
10-14-2003 09:08 PM
Re: root user cannot login into ORACLE
If you are using svrmgrl,then this executable has permissions for user oracle and group dba.
The root should be added to the dba group
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 09:28 PM
10-14-2003 09:28 PM
Re: root user cannot login into ORACLE
Just sqlplus for logging.
2 examples, root user and other user:
AS SUPERUSER:
# sqlplus
SQL*Plus: Release 8.0.4.0.0 - Production on Wed Oct 15 11:5:58 2003
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Enter user-name: taller
Enter password:
ERROR:
ORA-12203: TNS:unable to connect to destination
Enter user-name:
AS OTHER USER:
contal2_contal> sqlplus
SQL*Plus: Release 8.0.4.0.0 - Production on Wed Oct 15 11:7:22 2003
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Enter user-name: taller
Enter password:
Connected to:
Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
PL/SQL Release 8.0.4.0.0 - Production
SQL>
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 09:37 PM
10-14-2003 09:37 PM
Re: root user cannot login into ORACLE
Try "echo $TWO_TASK" as OTHER USER.
Then as root, do "export TWO_TASK=VALUE_ABOVE" (no spaces).
Any good ?
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 09:54 PM
10-14-2003 09:54 PM
Re: root user cannot login into ORACLE
Cause: Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems.
Action: Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.
-------------------
Variable TNS_ADMIN shows where your "tnsnames.ora" is located, if the variable does not exist the file is under $ORACLE_HOME/network/admin
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 10:01 PM
10-14-2003 10:01 PM
Re: root user cannot login into ORACLE
Nothing to do with TWO_TASK, neither root user nor OTHER_USER user had this variable set.
Christian:
I can search around tnsnames.ora but if there is any mistake with it, whether root user or the others would be affected ¿?
Thanks guy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2003 10:15 PM
10-14-2003 10:15 PM
Re: root user cannot login into ORACLE
If yo have Oracle as a package you have a name for the package and a IP address for that, then in your tnsnames you must define the connexion to this name and IP in both nodes. If you do this you can connect to the database from the other node.
Regards,
Justo.