- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: svrmgrl and root user
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
тАО05-01-2002 09:21 AM
тАО05-01-2002 09:21 AM
Re: svrmgrl and root user
su - orausr -c orascr.sh
Just make sure that the orascr.sh have rx permissions also for the orausr
...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2002 10:52 PM
тАО05-02-2002 10:52 PM
Re: svrmgrl and root user
Can you check these two things.
1. Have you got a local .tnsnames.ora file in the Oracle user home directory.
2. Please set the TNS_ADMIN variable for the root user to the directory where tnsnames.ora is residing.
Just my two cents.
-Sukant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 02:32 AM
тАО05-03-2002 02:32 AM
Re: svrmgrl and root user
the
connect internal
will only succeed, if the user issuing it belongs to the "dba" group that was linked into the oracle executables upon installation.
So if this is "dba" you may try to add root to this group.
The other option would be to
connect user as sysdba
which may require a password.
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 03:29 AM
тАО05-03-2002 03:29 AM
Re: svrmgrl and root user
This game you play is very dangerous.
I can tell you from long hours of restoring after starting jobs as 'root', which then killed my production databases.
DO yourself a favour and keep root as far away as possible from playing around with Oracle stuff. I know, that it looks like a piece of cake handling all Oracle things from root, but don't fall for it.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 03:37 AM
тАО05-03-2002 03:37 AM
Re: svrmgrl and root user
I want to second the "motion" that Alexander made. As an ex-DBA I still occasionaly help out the DBA's, but I never use my "new powers" (root access) to do so. One day you'll accidently have a database that gets started as both root and oracle ... and I once saw the result from something like that :-( ... it's not pretty.
Change the script to do a "su - oracle" before svrmgrl !
Regards,
Tom
P.S. N/A for this please. I just wanted to enforce what others already said. You'll make me very happy if you just don't use root :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 04:50 AM
тАО05-03-2002 04:50 AM
Re: svrmgrl and root user
And if a script running svrmgrl have broken a database it would have break it even if it was running under Oracle user.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2002 05:20 AM
тАО05-03-2002 05:20 AM
Re: svrmgrl and root user
For what it's worth, I've never had any trouble running Oracle databases from root. The main trick is to change root's primary group to dba.
When run as root, Oracle switches all the database processes to run as 'daemon' so they are not privileged.
I've also alternated starting databases as root and oracle - again with no problems.
Oracle won't let you run an instance more than once - even from different users.
svrmgrl (and sqlplus for that matter) should be capable of being run from root using the bequeath protocol. It might be worth relinking svrmgrl and sqlplus, what version of Oracle are you using?
Regards,
John
- « Previous
-
- 1
- 2
- Next »