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
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