Hi Martin –
Thanks for your response!
Here are the values (I am able to login thru TOAD with DBA privs):
Also, here are a few other params that I checked to make sure they have correct
Also, the error makes it seem that it is looking for a password file of some
sort. I’m not using a password file, so I’m not sure what’s up with that.
From: Martin Berger <martin.a.berger@xxxxxxxxx>
Sent: Thursday, July 11, 2019 12:06 PM
To: Sallie Cottingham <Sallie.Cottingham@xxxxxxxxxx>
Cc: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: Re: SYS login issue thru TOAD but not SQLPLUS
Can you please have a quick look for db-name & db-unique-name?
They might be needed to interpret ASM path.
<Sallie.Cottingham@xxxxxxxxxx<mailto: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
ORA-17503: ksfdopn:2 Failed to open file
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
Errors in file
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!
Comptroller of the Treasury
425 Fifth Avenue North
Nashville, TN 37243-34001