Oracle DS 10g connection to DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter BUSS - 20 Sep 2007 21:12 GMT

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. The connection works fine from my older Oracle DS 10g
installation on my Windows XP SP2 and Hotfixes PC. What is wrong?

Error messages

Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:\Users\Peter>sqlplus hr/hr

SQL*Plus: Release 10.1.0.4.2 - Production on Do Sep 20 22:06:39 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12560: TNS: Fehler bei Protokolladapter -- Error

Benutzernamen eingeben: hr
Kennwort eingeben:
ERROR:
ORA-12560: TNS: Fehler bei Protokolladapter

Benutzernamen eingeben:
ERROR:
ORA-12560: TNS: Fehler bei Protokolladapter

SP2-0157: CONNECT-Versuch zu ORACLE nach 3 Versuchen aufgegeben, SQL*Plus
wird v
erlassen

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@skier3
Kennwort eingeben:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION

SQL>

I recieve the same error messages when using the sqlplus tool.

Thank you for helping,

Reply to this Message

DA Morgan - 20 Sep 2007 23:18 GMT

> Hallo,
>
> I just made myself a Windows Vista Home

You should have stopped right here and read the installation guide.
Not going to happen, if at all, in a supported fashion. Get yourself
a "real" operating system. I'd recommend Oracle Linux.

Signature

Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

Frank van Bortel - 22 Sep 2007 19:28 GMT

> 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
>
[quoted text clipped - 3 lines]
>
> SQL> connect hr@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...

Reply to this Message

Peter BUSS - 22 Sep 2007 21:08 GMT

Yesterday a found an Oracle Client installation for windows Vista. I can now
connect to the database with sqlplus.
File: 10203_client_vista.zip

I can only assume that anything before Windows vista won't work.

Also available is Oracle Data Access Components ODAC which I also installed
into the Oracle client for windows vista installation (for office 2007
installations), according to instructions.
ODAC1020221.exe

But I still can't use Oracle Forms Developer. There doesn't appear to be
anything available yet.

Cheers,
Peter BUSS

Reply to this Message

Frank van Bortel - 23 Sep 2007 12:33 GMT

> Yesterday a found an Oracle Client installation for windows Vista. I can
> now connect to the database with sqlplus.
[quoted text clipped - 12 lines]
> Cheers,
> Peter BUSS

As soon as Vista is available, I'd say...
<grin>

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Reply to this Message

Özen Sercan - 31 Jul 2008 23:05 GMT

Hi Mr BUSS,
It has been a long time that you have entered this post but still I'll try.
I do have a Vista Home Premium desktop PC, I think I use the same PATCH(Feb
2007 10.2.0.3).
But I get ORA-12154 error from SQL plus.
I read, other people had also achieved to connect to Oracle Server from Vista
Home Premium.

I start the SETUP.EXE as an administrator and I checked in the Properties,
second tab, where you say -sorry I cant remember the exact term- consider
similar to XP SP2. My OS is in Turkish?!?!?
Could you please give me any clues about why not I can be successful?

Kind regards,

>Yesterday a found an Oracle Client installation for windows Vista. I can now
>connect to the database with sqlplus.
[quoted text clipped - 12 lines]
>Cheers,
>Peter BUSS

Reply to this Message