Re: sqlnet.log file growing with this error.

Pete Sharman wrote:
>
> The error stack you're getting is:
>
> Error: ORA 12206
> Text: TNS:received a TNS error during navigation
> -------------------------------------------------------------------------------
> Cause: Internal navigation error because of an unexpected TNS error.
> Action: Look at the log file to find the TNS error. If necessary, turn
> on tracing and repeat the operation.
>
> OK, so what's further down the stack?
>
> Error: ORA 12545
> Text: TNS:name lookup failure
> -------------------------------------------------------------------------------
> Cause: A protocol specific ADDRESS parameter cannot be resolved.
> Action: Ensure the ADDRESS parameters have been entered correctly;
> The most likely incorrect value is the node name.
>
> Error: ORA 12560
> Text: TNS:protocol adapter error
> -------------------------------------------------------------------------------
> Cause: A generic protocol adapter error occurred.
> Action: Check addresses used for proper protocol specification. Before
> reporting this error, look at the error stack and check for lower level
> transport errors.For further details, turn on tracing and reexecute the
> operation. Turn off tracing when the operation is complete.
>
> Error: TNS 00515
> Text: Connect failed because target host or object does not exist
> -------------------------------------------------------------------------------
> Cause: The address specified is not valid, or the program being connected to does
> not exist.
> Action: Ensure the ADDRESS parameters have been entered correctly; the
> most likely incorrect parameter is the node name. Ensure that the
> executable for the server exists (perhaps "oracle" is missing.)
>
> The last three all point to address parameter issues. Can you post the tnsnames.ora
> so we can see that?
>
> HTH.
>
> Pete
>

Here it is.

insp =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= i3107ps3)(Port= 1521))     (CONNECT_DATA = (SID = insp))
  )

ps3insp =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= i3107ps3)(Port= 1521))     (CONNECT_DATA = (SID = insp))
  )

wrjinsp =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= wrj2483)(Port= 1521))     (CONNECT_DATA = (SID = insp))
  )

ps1insp =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= i3107ps1)(Port= 1521))     (CONNECT_DATA = (SID = insp))
  )

testprod =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= i3107ps2)(Port= 1521))     (CONNECT_DATA = (SID = testprod))
  )

--
Michael A. Rothwell
Oracle DBA/Oracle Web Applications Developer

Views expressed here are not those of my company No - Actually - Since I am independent, They are the views of my company. Received on Thu Apr 22 1999 - 16:00:32 CDT