Install 8.1.5 client

[marist89]

When you say:
$ sqlplus system/manager@orcl

you are using sql*net to get to the database.

When you say:
$ sqlplus system/manager

you are bypassing sql*net and going directly to the database. In this case, you must make sure the $ORACLE_SID is set to the correct instance name.

[rpardip]

ORACLE_SID is set right. I think I may be missing some previliges to one of the executables in $ORACLE_HOME/bin of the client software.

Any thought ???

[Prof]

I think, what when you connect in database without alias, sqlplus connecting in database using ipc. Also equvivalent version of client and database is requed, because runing oracle server process $ORACLE_HOME/bin/oracle.

[marist89]

Yup, The Prof is right. I forgot you had 815 client going against 816 database.

[Edited by marist89 on 12-01-2000 at 04:38 PM]

[rpardip]

>>>> Is TWO_TASK set by chance?

I have no idea how to check this :-) Sorry

[marist89]

The environment variable TWO_TASK.
$ echo $TWO_TASK

[rpardip]

Nope. It is not set.

[marist89]

As the Prof pointed out, since you don't have an 8.1.5 database, you won't be able to connect natively. However, if you set the environment variable TWO_TASK to your alias, it will appear as though you have connected natively. For example,
$ export TWO_TASK=orcl
$ sqlplus system/manager

[rpardip]

marist89, thanks for all your help. I have to leave now. I will try this on Monday and will let you know.

Thanks again

[Prof]

I think, what when you used TWO_TASK variable you connecting through TCP/IP. If you comment alias in tnsnames.ora you don't have connect in database.
Maybe I am wrong.