Re: What to do if a logon trigger get invalidated ?

From: Hans Erik Busk <tbf_at_cn.stam.dk>
Date: Sun, 03 Nov 2002 10:45:15 +0100
Message-ID: <nlr9su8ef1fre0j8v1mnhpb5rtj2kaiajv@4ax.com>

On 31 Oct 2002 10:08:53 -0800, Pete Sharman <peter.sharman_at_oracle.com> wrote:

>You should ALWAYS be able to log on as SYSDBA to fix this. Can you post the
>results of trying to connect as SYSDBA with an invalid logon trigger?
>

I might have a problem as the "connect / as sysdba" does not work, butwithout the logon trigger I can "connect sys/password as sysdba" and also startup and shutdown the database I have the "remote_login_passwordfile=SHARED" and is a member of the ORA_DBA group

C:\WINNT>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Sat Nov 2 18:29:36 2002

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

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> connect sys/password as sysdba
Connected to an idle instance.
SQL> startup nomount pfile="d:\oracle\ADMIN\Mads9\pfile\init.ora"; ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown

ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

SQL> startup nomount pfile="d:\oracle\ADMIN\Mads9\pfile\init.ora"; ORA-01031: insufficient privileges

Hans Erik Busk Received on Sun Nov 03 2002 - 03:45:15 CST