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@xxxxxxxxxx> 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@xxxxxxxxxx <sallie.Cottingham@xxxxxxxxxx>*
615-401-7962