Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logon to sqlplus failed because of second environment Var value

Status
Not open for further replies.

liliya13

Technical User
Aug 5, 2004
44
US
I work in SunOS 5.9

I have a problem with TWO instances of the Databases
1st TWO_TASK value is ISY01B
2nd TWO_TASK value is LIS01A

I appended LIS01A DATABASE part exactly under ROSIE database PART

ROSIE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(HOST = Newton)(PORT =1521))
)
(CONNECT_DATA =
(SERVER_DEDICATED)
(SERVICE_NAME = ISY01B)
)
)

LIS01A =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(HOST = Watson)(PORT =1521))
)
(CONNECT_DATA =
(SERVER_DEDICATED)
(SERVICE_NAME = LIS01A)
)
)

After I setenv TWO_TASK LIS01B and was able to echo it under my network directory I tried the following command:
sqlplus userME@LIS01A
It asked me a password which I was able to use for ROSIE instance but I got a message:
ORA-01017: INVALID USER PASSWORD; LOGON DENIED
***********************************************************************
What I did wrong?
Why I was able to logon with Rosie and failed with LIS01B?
DID I DO smth wrong in tnsnames.ora syntax (appending LIS to the end of ROSIE fragment ?)
OR
Is it an issue of ANOTHER password For LIS01A than for ROSIE?

Thank You in advance,

Liliya


 
an Oracle-related forum might be more useful.
try forum759

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top