10g InstantClient SQL*Plus problem [used to be: SQL*Plus startup commands]

From: Thalis Kalfigopoulos <t.kalfigopoulos_at_alumil.com>
Date: Thu, 12 Aug 2004 11:17:35 +0300
Message-ID: <ONEEIIPGMICHDHGFMDJOGEBPCAAA.t.kalfigopoulos@alumil.com>

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of gparc_at_free.fr
> Sent: Thursday, August 12, 2004 10:29 AM
> To: oracle-l_at_freelists.org
> Subject: RE: SQL*Plus startup commands
>
>
> Thalis,
>
> You can also download Oracle 10g Instant Client
> at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
>
> For documentation, see also
> http://www.oracle.com/technology/docs/tech/sql_plus/10102/readme_ic.htm
>
> HTH
>

Thanks, I just downloaded instantclient-basic and instantclient-sqlplus (thankfully i'm not on dialup ;-) In the sqlplus package there is sqlplus.exe and also a glogin.sql. When I run a diff between the new glogin.sql and my current one (from Release 9.2.0.1.0), I get the following differences:

[New Lines in instaclient-sqlplus's glogin.sql] COLUMN units_col_plus_show_sga FORMAT a15

COLUMN origname_plus_show_recyc   FORMAT a16 HEADING 'ORIGINAL NAME'
COLUMN objectname_plus_show_recyc FORMAT a30 HEADING 'RECYCLEBIN NAME'
COLUMN objtype_plus_show_recyc    FORMAT a12 HEADING 'OBJECT TYPE'
COLUMN droptime_plus_show_recyc   FORMAT a19 HEADING 'DROP TIME'

[Lines in my current glogin.sql which are missing from the instant client's glogin.sql] SET PAGESIZE 14
SET SQLPLUSCOMPATIBILITY 8.1.7 I'm guessing the additional COLUMN lines are innocuous. But how about missing the two SET directives (esp. the 2nd one)? Is it safe to overwrite my existing glogin.sql with the new one?

Even so, I cannot login with the new sqlplus client :( Upon authentication I get an error:

ORA-12560: TNS:protocol adapter error

I looked it up and it says to take the following steps:

Turn on tracing and repeat the operation.
Evaluate the contents of the trace file to diagnose the problem.

How can I turn on tracing if I haven't logged in yet (I repeat: do not shoot the novice user)

Any ideas?

TIA. ps. At least I saw that I'm using the new sqlplus client [Release 10.1.0.2.0] 8-)

Thalis Kalfigopoulos
IT Department
Alumil S.A.
Kilkis Industrial Area
61100, Greece
E-mail: t.kalfigopoulos_at_alumil.com
Tel: +30 23410 79300

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Aug 12 2004 - 03:10:18 CDT