RE: SYS login issue thru TOAD but not SQLPLUS

From: Sallie Cottingham <Sallie.Cottingham@xxxxxxxxxx>
To: Martin Berger <martin.a.berger@xxxxxxxxx>
Date: Thu, 11 Jul 2019 18:09:50 +0000

Hi Martin –

Thanks for your response!

Here are the values (I am able to login thru TOAD with DBA privs):

[cid:image001.png@01D537E9.754B8990]

Also, here are a few other params that I checked to make sure they have correct
values:

[cid:image002.png@01D537E9.EB696C00]

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.

Sallie

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

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

References:
- SYS login issue thru TOAD but not SQLPLUS
  - From: Sallie Cottingham
- Re: SYS login issue thru TOAD but not SQLPLUS
  - From: Martin Berger

RE: SYS login issue thru TOAD but not SQLPLUS

Other related posts: