> -- --Original Message-- --
> From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of gparc@(protected)
> Sent: Thursday, August 12, 2004 10:29 AM
> To: oracle-l@(protected)
> 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 (See ORA-12560.ora-code.com): 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@(protected)
Tel: +30 23410 79300
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
