-
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.
Jeff Hunter
-
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 ???
-
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.
-
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]
Jeff Hunter
-
>>>> Is TWO_TASK set by chance?
I have no idea how to check this :-) Sorry
-
The environment variable TWO_TASK.
$ echo $TWO_TASK
Jeff Hunter
-
-
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
Jeff Hunter
-
marist89, thanks for all your help. I have to leave now. I will try this on Monday and will let you know.
Thanks again
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|