From oracle-l-bounce@freelists.org Thu Nov 17 21:44:25 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jAI3iP2c023273 for ; Thu, 17 Nov 2005 21:44:25 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jAI3i5AX023234 for ; Thu, 17 Nov 2005 21:44:17 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C939123009B; Thu, 17 Nov 2005 21:42:38 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18636-05; Thu, 17 Nov 2005 21:42:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47923230192; Thu, 17 Nov 2005 21:42:38 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 17 Nov 2005 21:40:42 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F22FB23006B for ; Thu, 17 Nov 2005 21:40:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18117-07 for ; Thu, 17 Nov 2005 21:40:41 -0500 (EST) Received: from agminet01.oracle.com (agminet01.oracle.com [141.146.126.228]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6214523005B for ; Thu, 17 Nov 2005 21:40:41 -0500 (EST) Received: from rgmgw2.us.oracle.com (rgmgw2.us.oracle.com [138.1.186.111]) by agminet01.oracle.com (Switch-3.1.7/Switch-3.1.7) with ESMTP id jAI2rWnD029335 for ; Thu, 17 Nov 2005 20:53:32 -0600 Received: from localhost (localhost [127.0.0.1]) by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with SMTP id jAI2edL7032496 for ; Thu, 17 Nov 2005 19:40:39 -0700 Received: from us.oracle.com (dhcp-amer-csvpn-gw2-141-144-73-168.vpn.oracle.com [141.144.73.168]) by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id jAI2eU96032115; Thu, 17 Nov 2005 19:40:30 -0700 From: "Pete Sharman" To: "oracle-l@freelists.org" Cc: "Peter Ross Sharman" Subject: FW: connect as sysdba ora-1031 Date: Fri, 18 Nov 2005 13:40:29 +1100 Message-ID: <20051118134029372.00000003756@psharman-au> X-Accept-Language: en-au, en MIME-Version: 1.0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-Brightmail-Tracker: AAAAAQAAAAIX-Whitelist: TRUE X-archive-position: 28464 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: peter.sharman@oracle.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00,HTML_70_80, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,MIME_HTML_ONLY,TO_ADDRESS_EQ_REAL autolearn=no version=2.63

Rassifrassing reply all button missed again. L

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

From: Pete Sharman [mailto:peter.sharman@oracle.com]
Sent: Friday, 18 November 2005 1:33 PM
To: fuadar@yahoo.com
Cc: Peter Ross Sharman
Subject: RE: connect as sysdba ora-1031

How are you testing the password file is not corrupted? I hit a corrupt password file just today and had to recreate it. Not enough time to debug the problem when it happened, so recreating was the easiest answer for me.

Remember if you take this route you need to restart the database for it to be effective.

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Fuad Arshad
Sent: Friday, 18 November 2005 2:23 AM
To: oracle-l@freelists.org
Subject: Re: connect as sysdba ora-1031

opracle versionj 9.2.0.4

oracle software owner is oracle

and group is dba and all the permissions seem fine

i am logged in directly thru the account owner
os is aix 5.4 ml05
Paul Drake <bdbafh@gmail.com> wrote:

On 11/17/05, Fuad Arshad wrote:
> We're having this issue which started today and we cant get ot the bottom
> of it
>
>
> looged in as the oracle owner TWO_TASK is unset
> SQL> connect sys@dbname as sysdba
> Enter password:
> Connected.
> SQL> connect / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Warning: You are no longer connected to ORACLE.
>
> now the user i'm using is the oracle software owner
> password file is not corrupted remote_login_password is also set to
> exclusive.
>
>
> what steps can i take to further debug this. i"m thinking about oradebug
> but then since i'm disconnected how would oradebug capture anything .
> need some advice before i brave the tar and all the same questions with
> oracle.

Please repost listing your Oracle version, operating system version
and the account that you are logged onto the server as and its group
membership.

Paul

--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today

-- http://www.freelists.org/webpage/oracle-l