dbTalk Databases Forums  

Oracle DS 10g connection to DB

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Oracle DS 10g connection to DB in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter BUSS
 
Posts: n/a

Default Oracle DS 10g connection to DB - 09-20-2007 , 03:12 PM






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 With Quote
  #2  
Old   
DA Morgan
 
Posts: n/a

Default Re: Oracle DS 10g connection to DB - 09-20-2007 , 05:18 PM






Peter BUSS wrote:
Quote:
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.
--
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 With Quote
  #3  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle DS 10g connection to DB - 09-22-2007 , 01:28 PM



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

Peter BUSS wrote:
Quote:
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

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

Quote:
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
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.

Quote:
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)

iD8DBQFG9V7HLw8L4IAs830RArMsAJ9dknJMJ3ZzNFxCuPBZVq 2qn17tYgCgi8p7
KTzB7O4ehr422g04lt+Rm4s=
=FsBy
-----END PGP SIGNATURE-----


Reply With Quote
  #4  
Old   
Peter BUSS
 
Posts: n/a

Default Re: Oracle DS 10g connection to DB - 09-22-2007 , 03:08 PM



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 With Quote
  #5  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Oracle DS 10g connection to DB - 09-23-2007 , 06:33 AM



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

Peter BUSS wrote:
Quote:
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

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

- --
Regards,
Frank van Bortel

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

iD8DBQFG9k8hLw8L4IAs830RAiX3AJ41YZCbDYs4WTKonMC2s2 qWakRRzACfQSm5
4HoCAHExJSxFsa47R+bevnA=
=/Lp2
-----END PGP SIGNATURE-----


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.