- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9.2.0 - insufficient privileges (sysdba...
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
тАО02-19-2006 09:58 PM
тАО02-19-2006 09:58 PM
Oracle 9.2.0 - insufficient privileges (sysdba)
My environment is as follows
HP-UX 11.00 2-node cluster. Oracle 9.2.0 installed in the cluster.
Firstly, I must say, I'm a novice to dbs, as I only interact with them when the frontend has issues.
The front end here is data protector, and I'm integrating Oracle to take the backup - had issues there with the connect string - went to the OS and DB to investigate.
Apparently there's no svrmgrl now - I connect to sqlplus. But I cannot connect as sysdba using any of the users.
The following basically explains the scenario
________________________________________
#sqlplus
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Feb 20 13:45:48 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production
SQL> connect system/manager@ov_remote
Connected.
SQL> connect system/manager@ov_remote as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL>
___________________________________________
So I'm unable to connect as sysdba. Thats what Data Protector wants to do as well. I have an oracle user, a sys user and this system user all with dba as their primary groups - but none of them connects with full privileges - why?
How can I change that?
On investigation I found people talking about the following
set the database parameter remote_login_passwordfile to
either "exclusive" or "shared"
Now, I don't have this parameter in my init.ora file. Only thing close to this is "remote_os_authent = true". Don't know whether the above parameter applies in my case or not.
Really appreciate any assistance.
Thanks and Regards,
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 10:22 PM
тАО02-19-2006 10:22 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
try
in init.ora file
remote_login_passwordfile=EXCLUSIVE
then
# sqlplus /nolog
SQL> connect sys/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 10:47 PM
тАО02-19-2006 10:47 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
what was the password you used when you created the password file and have you tried that?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 10:57 PM
тАО02-19-2006 10:57 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
As for the variable, I would be willing to add once I know its effects, and whether it needs the DB to be reinitiated or what. Production environment this one is.
The password file you mean /etc/passwd - don't remember the first passwords when creating the user, but I suspect at least for system that "manager" is the default passwd.
Appreciate your swift responses.
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 11:00 PM
тАО02-19-2006 11:00 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
the password file is created during the installation of the Oracle software.
you will need to alter the sys password so that they become in sync...
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 11:01 PM
тАО02-19-2006 11:01 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
# orapwd file=orapw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 11:04 PM
тАО02-19-2006 11:04 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
i had a similar problem long time back. Let me see if i can provide you with a solution with an example.
i have to get back to my notes...
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 11:09 PM
тАО02-19-2006 11:09 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
this is how you create your password file:
$ orapwd file=orapw password=foobar entries=40
and when you alter the sys password this file is modified accordingly.... Most probably it has never been done at your site...
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 11:13 PM
тАО02-19-2006 11:13 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
orapwd, never touched such a file - went in with the defaults. Actually even for scripts never needed to use the as sysdba privilege. Its just that the DP integration works with full privileges.
btw, I see that the other two users -members of dba-, oracle and sys can't connect to sql with even non sysdba priviledges
__________________________________
SQL> connect sys/manager@ov_remote
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> connect oracle/oracle@ov_remote
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> connect system/manager@ov_remote
Connected.
SQL>
_____________________________________
Again, really appreciate the assistance.
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2006 11:14 PM
тАО02-19-2006 11:14 PM
Re: Oracle 9.2.0 - insufficient privileges (sysdba)
Note that the sysdba trick is generally used to allow other NON-SYS users to connect. By the way, it is best to use your OWN account that has been granted sysdba!
Hope this is not confusing to you, anyway, this is how this works:
$ orapwd file=orapw password=foobar entries=40
Here, a password file with a password foobar has been created. Note that my sys password is NOT foobar.
=======================================
$ sqlplus /nolog
SQL> connect internal
Connected.
SQL> startup
ORACLE instance started.
Total System Global Area 1395673576 bytes
Fixed Size 104936 bytes
Variable Size 574263296 bytes
Database Buffers 819200000 bytes
Redo Buffers 2105344 bytes
Database mounted.
Database opened.
SQL> connect sys/change_on_install@ora817
Connected.
=======================================
that works OK.
Now, let us try as sysdba:
=======================================
SQL> connect sys/change_on_install@ora817 as sysdba;
ORA-01017: invalid username/password; logon denied
=======================================
This is the same error that you are getting! My SYS password is change_on_install but the password file has foobar in it. SYS is special -- sys connecting as sysdba is like internal -- you have to use the password file password!
Now, if we try this:
==========================================
SQL> connect sys/foobar@ora817 as sysdba;
Connected.
SQL> grant sysdba to scott;
Grant succeeded.
==========================================
You will observe that this does not hold true for other users:
==========================================
SQL> connect scott/tiger@ora817 as sysdba;
Connected.
==========================================
That worked great, and now if we just modify sys's password (not really, didn't change it but Oracle won't notice that)
==========================================
SQL> alter user sys identified by change_on_install;
User altered.
SQL> connect sys/change_on_install@ora817 as sysdba;
Connected.
SQL>
==========================================
You will observe now that we can use change_on_install -- that is because altering SYS's password will sync up the password in the password file -- sys is a very very close cousin of INTERNAL. sys's password will be burned into the password file now. The password foobar is now obsolete and no longer applicable.
==========================================
SQL> connect sys/foobar@ora817 as sysdba;
ORA-01017: invalid username/password; logon denied
SQL>
==========================================
hope this helps!
kind regards
yogeeraj