Solaris client Oracle 8.0.4 [message #71527] |
Tue, 19 November 2002 16:20 |
Angie
Messages: 12 Registered: April 2002
|
Junior Member |
|
|
Dear guru,
Solaris client 8.0.4 connects to server 8.1.7 on w2k. I set a script file esql in bin directory as
$ORACLE_HOME/bin/sqlplus scott/tiger@ORACLE
it works fine when executing esql. But when I do this:
SQL>alter user scott identified by tiger1;
SQL>exit;
and try executing esql again:
>esql
...
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: scott
Enter password: tiger1
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Here's my listener.ora:
LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)
(HOST=ORACLE)
(PORT=1521)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=ORACLE)
(ORACLE_HOME=d:oracleoracle81)
(SID_NAME=(orcl))
)
)
Here's my tnsnames.ora:
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)
(HOST=ORACLE)
(PORT=1521)
)
(CONNECT_DATA = (SID=ORCL))
)
thanks in advance.
Angie
|
|
|
Re: Solaris client Oracle 8.0.4 [message #71530 is a reply to message #71527] |
Wed, 20 November 2002 07:39 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
sure it doesn't work...
U change the password, but U didn't change it in esql .. so INVALID PASSWORD ...
then u should type
Enter user-name: scott@ORACLE
Enter password: tiger1
|
|
|
|
|
Re: Solaris client Oracle 8.0.4 [message #71544 is a reply to message #71527] |
Thu, 21 November 2002 11:53 |
Angie
Messages: 12 Registered: April 2002
|
Junior Member |
|
|
Here's what I did:
Hi,
here's what I did:
>esql
...
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: scott@oracle
Enter password:
ERROR:
ORA-12224: TNS:no listener
thanks for your help.
angie
|
|
|
Re: Solaris client Oracle 8.0.4 [message #71603 is a reply to message #71527] |
Sun, 01 December 2002 13:21 |
Angie
Messages: 12 Registered: April 2002
|
Junior Member |
|
|
Hi B and Mahesh,
Thanks for your kind help, finally I figured the problem out: it has nothing to do with tnsnames.ora or listener.ora files, since I'm connecting to Oracle server from Unix platform with Oracle 8.0.4 client, an environment variable TWO_TASK needs to be set before connection:
TWO_TASK=ORACLE
EXPORT TWO_TASK
Now I'm fine:-)
Hope it's helpful for someone here too.
Angie
|
|
|