I'm running Toad 12.6.0.53 and I'm working on two databases which contain the same setup - but are not clones as the schemanames vary between the two databases.
As in 99% of the time it is NOT important to which database you acctually log in, but only the schemaname is important i tried to setup my local tnsnames like the follwoing:
MYDataBase=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=MyIP1)
(PORT=MyPort1)
)
(CONNECT_DATA=
(SERVICE_NAME=DatabaseName)
)
)
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=MyIP2)
(PORT=MyPort2)
)
(CONNECT_DATA=
(SERVICE_NAME=DatabaseName)
)
)
)
So now I can logon to the two database by only giving the right schemaname and password for that schema. Only that I cannot. Toad will eventually give me an "ORA-01017: invalid username/password; logon denied". After trying it a couple of times, Toad will then be able to connect without prompting for a password anymore.
Do you guys now why that might be?
Kind regards
Aucun commentaire:
Enregistrer un commentaire