OraFAQ Forum: Server Utilities » Solaris client Oracle 8.0.4

Home » RDBMS Server » Server Utilities » Solaris client Oracle 8.0.4

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Report message to a moderator

Re: Solaris client Oracle 8.0.4 [message #71533 is a reply to message #71527]

Wed, 20 November 2002 14:41

Angie
Messages: 12
Registered: April 2002

Junior Member

Hi I tried your way, it's not working. I'm thinking that could it be possible that the listener.ora file is not accurate.

Thanks anyway.

Angie

Report message to a moderator

Re: Solaris client Oracle 8.0.4 [message #71539 is a reply to message #71527]

Thu, 21 November 2002 02:48

B
Messages: 327
Registered: August 1999

Senior Member

Like Mahesh an me said ... U did forgot the connect string...

I'll try and it works ... May be U should post again what U type now...

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic:	dbms_pipe
Next Topic:	OCP papers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 06:01:28 CDT 2024