Re: HELP! connect ORACLE7 with TCP/IP by SQL*Plus
Date: 28 Aug 1993 19:24:20 GMT
Message-ID: <25obd4INNi4_at_gap.caltech.edu>
cs5087_at_mbox.ee.ncu.edu.tw (Paul) writes:
>I WAS TRYING TO CONNECT ORACLE SERVER WITH SQL*PLUS BY TCP/IP
>BUT FAILED, THE FOLLOWING COMMANDS WERE ENTERED IN THE SYSTEM
>PROMPT.
> tcpctl start
> sqlplus user/password _at_T:netid:test
>THE ERROR I GOT WAS
> ERROR:ORA-06401........
>AND I COULDN'T FIND THE ERROR MESSAGE IN RELATED MANUALS.
>THIS HAPPENED IN
>
> NCR/3000 MODEL 3345
> AT/T UNIX SVR 4
> ORACLE 7 engine 7.0.12
> SQL*Plus release 3.1.1.9.1
>IF YOU HAVE ANY SOLUTION OR EXPLAINATION ABOUT THIS PROBLEM,
>PLEASE MAIL TO ME.
>I DEEPLY APPRECIATE FOR ANY HELP YOU OFFER.
Paul,
I ran oerr to get a clue:
ava2-dan-% oerr ORA 06401
06401, 00000, "NETCMN: invalid driver designator"
// *Cause: The login (connect) string contains an invalid driver designator.
// *Action: Correct the string and re-submit.
ava2-dan-%
Here's my wild guess:
The connect string you specified is a sqlnet V1 string. You are probably running sqlnet V2 on your server.
Here is my sqlnet V2 connect string:
which I keep in $ORACLE_HOME/network/admin/tnsnames.ora
on the client
ava2_x7 =
(DESCRIPTION =
(ADDRESS_LIST =
(PROTOCOL = TCP)
(HOST = ava2)
(PORT = 2525)
)
)
(CONNECT_DATA =
(SID = x7)
)
)
I use it like this:
sqlplus scott/tiger_at_ava2_x7
I go into greater detail than this in my book:
"Dan's Guide to Oracle7"
Let me know if you want to be put on my mailing list.
-Dan
Daniel B. Bikle
Independent Oracle Consultant
dbikle_at_alumni.caltech.edu
415/854-9542
Received on Sat Aug 28 1993 - 21:24:20 CEST