Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle DS 10g connection to DB

Re: Oracle DS 10g connection to DB

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 22 Sep 2007 20:28:23 +0200
Message-ID: <fd3ms5$ii7$1@news1.zwoll1.ov.home.nl>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Peter BUSS wrote:
> Hallo,
>
> I just made myself a Windows Vista Home Premium PC, installed Oracle DS
> 10g (newest version) and I am unable to connect to the Oracle 10g
> (10.1.0.2.0) on my Linux server.

[snip]
>
> C:\Users\Peter>sqlplus hr/hr

That would be a local connection - as you have no instance locally, the

> ORA-12560: TNS: Fehler bei Protokolladapter -- Error
is only natural.

>
> C:\Users\Peter>sqlplus /nolog
>
> SQL*Plus: Release 10.1.0.4.2 - Production on Do Sep 20 22:07:03 2007
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> SQL> connect hr_at_skier3

Now - that's a remote connection. Hopefully, you have an Oracle client install, that has a tnsnames.ora file, containing this "skier3" as an alias, that points to your linux machine.

> Kennwort eingeben:
> ERROR:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-02248: invalid option for ALTER SESSION
>

Hmmm - looks like you have an odd environment setting; perhaps language or character set?
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG9V7HLw8L4IAs830RArMsAJ9dknJMJ3ZzNFxCuPBZVq2qn17tYgCgi8p7 KTzB7O4ehr422g04lt+Rm4s=
=FsBy
-----END PGP SIGNATURE----- Received on Sat Sep 22 2007 - 13:28:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US