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

  • From: "Thalis Kalfigopoulos" <t.kalfigopoulos@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Aug 2004 11:17:35 +0300

> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
> Behalf Of gparc@xxxxxxx
> Sent: Thursday, August 12, 2004 10:29 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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:

1. Turn on tracing and repeat the operation.
2. 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@xxxxxxxxxx
Tel:  +30 23410 79300

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: