dbTalk Databases Forums  

Error REP-0501/ORA-12637 connecting to DB

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


Discuss Error REP-0501/ORA-12637 connecting to DB in the comp.databases.oracle.tools forum.



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

Default Error REP-0501/ORA-12637 connecting to DB - 06-08-2007 , 12:18 AM






Hi to all,

I have installed Oracle Devsuite 10.1.2.0.2 on my computer.
After the installation, without the rebuild of server, all work fine;
I am able to connect to DB without problem.

If I restart the computer and I use for example the Report builder,
when I try to establish a connection with DB, this error are
displayed:
REP-0501: Unable to connect to the specified database
ORA-12637: Packet receive failed

But if I try to connect to DB (with the same ID, pwd and service) with
Datbase control or I run my Applications all work fine.

I have controlled the TNSNAMES and is correct:

================================================== ===================
# tnsnames.ora Network Configuration File: C:\Oracle\DevHome10\network
\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SOFTBLUE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.mydomain.lan)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = softblue)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.mydomain.lan)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
================================================== =======================

Have You an idea in order to resolve this problem ?

Thank You and Best Regards
Gaetano


Reply With Quote
  #2  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Error REP-0501/ORA-12637 connecting to DB - 06-08-2007 , 01:56 PM






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

nick048 wrote:
Quote:
Hi to all,

I have installed Oracle Devsuite 10.1.2.0.2 on my computer.
After the installation, without the rebuild of server, all work fine;
I am able to connect to DB without problem.

If I restart the computer and I use for example the Report builder,
when I try to establish a connection with DB, this error are
displayed:
REP-0501: Unable to connect to the specified database
ORA-12637: Packet receive failed

But if I try to connect to DB (with the same ID, pwd and service) with
Datbase control or I run my Applications all work fine.

I have controlled the TNSNAMES and is correct:

================================================== ===================
# tnsnames.ora Network Configuration File: C:\Oracle\DevHome10\network
\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SOFTBLUE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.mydomain.lan)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = softblue)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.mydomain.lan)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
================================================== =======================

Firewalls in place? Not every port open?
- --
Regards,
Frank van Bortel

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

iD8DBQFGaaZiLw8L4IAs830RAuIsAJ92qYZmFvmVIsY2bMsax7 BDn7HxeACfc7sY
Fnuq4s/WzEvH33ZzFPaJYVY=
=nU9O
-----END PGP SIGNATURE-----


Reply With Quote
  #3  
Old   
nick048
 
Posts: n/a

Default Re: Error REP-0501/ORA-12637 connecting to DB - 06-09-2007 , 10:24 AM



On 8 Giu, 20:56, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com> wrote:
Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1





nick048 wrote:
Hi to all,

I have installed Oracle Devsuite 10.1.2.0.2 on my computer.
After the installation, without the rebuild of server, all work fine;
I am able to connect to DB without problem.

If I restart the computer and I use for example the Report builder,
when I try to establish a connection with DB, this error are
displayed:
REP-0501: Unable to connect to the specified database
ORA-12637: Packet receive failed

But if I try to connect to DB (with the same ID, pwd and service) with
Datbase control or I run my Applications all work fine.

I have controlled the TNSNAMES and is correct:

================================================== ===================
# tnsnames.ora Network Configuration File: C:\Oracle\DevHome10\network
\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SOFTBLUE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.mydomain.lan)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = softblue)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = softblue01.sede.mydomain.lan)
(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
================================================== =======================

Firewalls in place? Not every port open?
- --
Regards,
Frank van Bortel

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

iD8DBQFGaaZiLw8L4IAs830RAuIsAJ92qYZmFvmVIsY2bMsax7 BDn7HxeACfc7sY
Fnuq4s/WzEvH33ZzFPaJYVY=
=nU9O
-----END PGP SIGNATURE------ Nascondi testo tra virgolette -

- Mostra testo tra virgolette -
Hi,

I have modified sqlnet.ora in this way

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

and all work fine.

Best Regards
Gaetano



Reply With Quote
  #4  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Error REP-0501/ORA-12637 connecting to DB - 06-10-2007 , 04:56 AM



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

nick048 wrote:
Mostra testo tra virgolette -

Quote:
Hi,

I have modified sqlnet.ora in this way

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

and all work fine.

Best Regards
Gaetano
Thanks for the feedback - appreciate it.

Odd... I would have expected an 'Insufficient
privileges' error in that case.

- --
Regards,
Frank van Bortel

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

iD8DBQFGa8qwLw8L4IAs830RAgzHAKCXtlWi01IH31ecjXYK4F LJMhXFgQCgjFp5
ZOEPBHnFarJgaoNTGYWOcjI=
=Rp5k
-----END PGP SIGNATURE-----


Reply With Quote
  #5  
Old   
Rick Wessman
 
Posts: n/a

Default Re: Error REP-0501/ORA-12637 connecting to DB - 07-03-2007 , 07:40 AM



In article <f4ghrf$b81$2 (AT) news1 (DOT) zwoll1.ov.home.nl>, Frank van Bortel says...
Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

nick048 wrote:
Mostra testo tra virgolette -

Hi,

I have modified sqlnet.ora in this way

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

and all work fine.

Best Regards
Gaetano

Thanks for the feedback - appreciate it.

Odd... I would have expected an 'Insufficient
privileges' error in that case.

- --
Regards,
Frank van Bortel

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

iD8DBQFGa8qwLw8L4IAs830RAgzHAKCXtlWi01IH31ecjXYK4F LJMhXFgQCgjFp5
ZOEPBHnFarJgaoNTGYWOcjI=
=Rp5k
-----END PGP SIGNATURE-----
Without a trace file, it's hard to know for sure, but it looks like ASO was
trying to do authentication and it failed while trying to receive a packet from
the other side.

Rick


--
Rick Wessman
Oracle Corporation
The opinions expressed above are mine and do not necessarily reflect
those of Oracle Corporation.


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.