Re: SYS login issue thru TOAD but not SQLPLUS

Sallie,
Can you please have a quick look for db-name & db-unique-name?

They might be needed to interpret ASM path.

Martin

^∆x

Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov> schrieb am Do., 11. Juli 2019, 17:54:

> I recently upgraded my databases from 12.1 to 12.2. After the upgrade to
> 12.2, everything is working well with the exception of using TOAD for a SYS
> login for just one (of 18) of the upgraded databases. I can login fine
> thru SQLPlus both local and remote, but when I try the login thru TOAD I
> get this error:
>
>
>
>
>
> ORA-17503: ksfdopn:2 Failed to open file +DAT/*IMPTEST*/PASSWORD/pwd
> imptest7.269.911482457
>
> ORA-15173: entry 'IMPTEST' does not exist in directory '/'
>
> ORA-06512: at line 4
>
> ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 665
>
> ORA-06512: at line 2
>
> 2019-07-11T10:09:51.258290-05:00
>
> Errors in file /u01/app/oracle/diag/rdbms/imptest7
> /imptest71/trace/imptest71_ora_21438.trc:
>
>
>
> What’s weird about this is the instance name in the error text – as I’ve
> highlighted in yellow. The name of the instance is IMPTEST7, but somewhere
> Oracle is thinking that it should be looking for IMPTEST.
>
>
>
>
>
> I really don’t know where to head with the problem since it is a problem
> with a third party product and I have not contacted Quest for support in
> the past for TOAD so not sure about that either. So I thought I’d see if
> anybody on the Oracle-L list may have experienced something like this and
> could provide insight. It’s not a showstopper since I can use SQLPlus,
> just annoying not to also be able to use TOAD.
>
>
>
> Any help will be appreciated!
>
>
>
> Thanks –
>
>
>
> *Sallie Cottingham*
>
> Database Administrator
>
> Comptroller of the Treasury
>
> Technology Solutions
>
> 425 Fifth Avenue North
>
> Nashville, TN 37243-34001
>
> *sallie.Cottingham_at_cot.tn.gov <sallie.Cottingham_at_cot.tn.gov>*
> 615-401-7962
>
>
>
>
>
>
>
>
>
>
>
>
>

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