-none-

Mailing List

Home

Forum Home

Oracle List - by freelists.org

Oracle on SUSE Linux - Runing Oracle on SUSE Linux

Oracle database error code ...

www.freelists.org

Subjects

•	ORA 12540: TNS:internal limit restriction exceeded
•	ORA 12838 please : Is possible to append two times to the same table befo
•	ORA 12838 please : Is possible to append two times to the same table before
•	ora 04031
•	ora 12500 on windows
•	ORA 32004: obsolete and/or deprecated parameter(s) specified
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ora 12500 on windows
•	ORA 01650, one idea
•	ORA 01650
•	ORA 4030
•	ORA 12838 please : Is possible to append two times to thesametable before do
•	ORA 12838 please : Is possible to append two times to thesame table before d
•	ORA 01536
•	ORA 03113 end of file on communication channel
•	ORA 32004: obsolete and/or deprecated parameter(s) specified
•	ORA 00600:
•	ORA 00020: maximum number of processes (%s) exceeded
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
•	ora 12500 on windows
•	ora 12500 on windows
•	ora 12500 on windows
•	ORA 01650, one idea
•	ora 12500 on windows
•	ora 12500 on windows
•	ora 12500 on windows
•	ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
•	ORA 01650, one idea
•	ORA 01650, one idea
•	ORA 01650, one idea
•	ORA 01650
•	ORA 01650
•	ORA 01031
•	ORA 4030
•	ORA 4030
•	ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
•	ORA 01722 invalid number

-none-

-none-

2007-08-13 - By Ted Coyle

Back
Set your TNS_ADMIN director to a single place with valid TNSNames and
SQLNET.ora files or,

You could always hardcode the connect descriptor in the link thus removing
TNS as an issue.

This gets confusing late at night if not noted primarily because altering
the TNS has no effect on hard coded links. :-)

Syntax:

create public database link TNSBYPASS

connect to system identified by manager42

using
'(DESCRIPTION=(ADDRESS=(HOST=YOURMACHINE.COM)(PROTOCOL=TCP)(PORT=1521))(CONN
ECT_DATA=(SERVICE_NAME=YOURSERVICE.NAME.COM)))'

Obviously there are security issues with this approach as well.

Also I've run 8.1.7.4, 9.2.0.4, 9.2.0.7, 10.1.0.4, 10.2.0.2 and 10.2.0.3
listeners simultaneously on the same machine.

It's not fun, but it was for testing various issues between systems.

Main issue we had was with auto registration and crashing listeners when 9
and 10 local_listeners were not set and 8.1.7.4 listener was defaulted to
1521.

-Ted

__ __

From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of David Sharples
Sent: Monday, August 13, 2007 2:21 PM
To: mccdba1@(protected)
Cc: Niall Litchfield; oracle-l@(protected)
Subject: Re: dblink problem on two verion of ORACLE DB

its NOTHING to do with your listener and EVERYTHING to do with your tnsnames
setup

On 13/08/07, dba1 mcc <mccdba1@(protected)> wrote:

I knew that is problem, but based on ORACLE say you
can Only turn on one listener which is highest version
of ORACLE.

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

Set your TNS_ADMIN director to a single
place with valid TNSNames and SQLNET.ora files or,<o:p></o:p>

<o:p> </o:p>

You could always hardcode the connect
descriptor in the link thus removing TNS as an issue.<o:p></o:p>

This gets confusing late at night if not
noted primarily because altering the TNS has no effect on hard coded links&
#8230;
J<o:p></o:p>

<o:p> </o:p>

Syntax:<o:p></o:p>

create public database link TNSBYPASS<o:p>
</o:p>

   connect to system identified
by manager42<o:p></o:p>

   using
'(DESCRIPTION=(ADDRESS=(HOST=YOURMACHINE.COM)(PROTOCOL=TCP)(PORT=1521))(CONNECT
_DATA=(SERVICE_NAME=YOURSERVICE.NAME.COM)))'<o:p></o:p>

<o:p> </o:p>

Obviously there are security issues with
this approach as well.<o:p></o:p>

<o:p> </o:p>

Also I’ve run 8.1.7.4, 9.2.0.4,
9.2.0.7, 10.1.0.4, 10.2.0.2 and 10.2.0.3 listeners simultaneously on the same
machine.<o:p></o:p>

It’s not fun, but it was for testing
various issues between systems. <o:p></o:p>

Main issue we had was with auto
registration
and crashing listeners when 9 and 10 local_listeners were not set and 8.1.7.4
listener was defaulted to 1521.<o:p></o:p>

<o:p> </o:p>

-Ted<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

<div>

<div class=MsoNormal align=center style='text-align:center'>

<hr size=2 width="100%" align=center tabindex=-1>

</div>

From:
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of David Sharples 
Sent: Monday, August 13, 2007 2:21
PM 
To: mccdba1@(protected) 
Cc: Niall Litchfield;
oracle-l@(protected) 
Subject: Re: dblink problem on two
verion of ORACLE DB<o:p></o:p>

</div>

<o:p> </o:p>

its NOTHING to do with
your listener and EVERYTHING to do with your tnsnames setup<o:p></o:p>

<div>


On 13/08/07, dba1
mcc <<a href="mailto:mccdba1@(protected)">mccdba1@(protected)</a>>
wrote: <o:p></o:p>

I knew that is problem, but based on ORACLE say you 
can Only turn on one listener which is highest version 
of ORACLE.<o:p></o:p>

</div>

</div>

</body>

</html>