Home » RDBMS Server » Security » Insufficient privileges (oracle RDBMS 9.2.0.5 on RH enterprise Linux ES4)
Insufficient privileges [message #351511] Wed, 01 October 2008 04:26 Go to next message
laksha
Messages: 42
Registered: June 2006
Member
I have two machines on RH linux abc and xyz.
Database resides on abc and uses password file authentication.

The machine xyz is client machine.

DATABASE MACHINE ABC

[orasam@abc ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.5.0 - Production on Wed Oct 1 14:34:38 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn sys/1234@sam
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper


SQL> conn sys/1234@sam as sysdba
Connected.
SQL> show parameter remote_login_passwordfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE


as shown here i can connect to the database as sysdba from the same machine.

But as shown below from remote machine I get the following errors

REMOTE MACHINE XYZ

SQL> !tnsping sam

TNS Ping Utility for Linux: Version 8.0.6.3.0 - Production on 01-OCT-2008 22:47:08

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=tcp)(HOST=abc.panaji.com)(PORT=1531))
OK (220 msec)

SQL> conn sys/1234@sam
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper


SQL> conn sys/1234@sam as sysdba
ERROR:
ORA-01031: insufficient privileges




How can i connect as sysdba remotely? Please help

[Updated on: Wed, 01 October 2008 04:30]

Report message to a moderator

Re: Insufficient privileges [message #351517 is a reply to message #351511] Wed, 01 October 2008 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I wonder if 8.0.6 client is able to connect as sysdba to 9.2 database. Net security was greatly improve between these 2 versions and maybe database rejects sysdba connection from a so old version.

Regards
Michel

[Updated on: Wed, 01 October 2008 05:35]

Report message to a moderator

Re: Insufficient privileges [message #351521 is a reply to message #351517] Wed, 01 October 2008 05:54 Go to previous message
laksha
Messages: 42
Registered: June 2006
Member
Thanks for the reply.
Previous Topic: oracle sys authentication
Next Topic: DENY over other rights
Goto Forum:
  


Current Time: Fri Mar 29 10:46:06 CDT 2024