SYS login issue thru TOAD but not SQLPLUS
Date: Thu, 11 Jul 2019 15:53:05 +0000
Message-ID: <BL0PR0901MB23056745817DB91F15F9F27DDEF30_at_BL0PR0901MB2305.namprd09.prod.outlook.com>
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/pwdimptest7.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<mailto:sallie.Cottingham_at_cot.tn.gov>
615-401-7962
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 11 2019 - 17:53:05 CEST