ORA-07204: sltln: name translation failed due to lack of output buffer space.

ORA-07204: sltln: name translation failed due to lack of
output buffer space.

Question Posted / guest

2 Answers
4458 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-07204: sltln: name translation failed due to lack of output buffer space...

Answer / garima khosla

This type of Exception occurs when we want to restart the
instance and to get rid of this we need to makesure/confirm
the instance SID. Because there could be confusion if the
Service name would be like SVMASTER.REFLEXISCHENNAI OR need
to clarify the tnsnames.ora tag name for that instance.

In Linux we can do
ORACLE_SID = <SID>
export ORACLE_SID

Is This Answer Correct ?

0 Yes

0 No

ORA-07204: sltln: name translation failed due to lack of output buffer space...

Answer / guest

Cause: The sltln routine is given a maximum length buffer to
expand the name into. An overflow of this buffer occurred.

Action: Possible internal error. Check output buffer length
stored in sercose[0]. Pathnames are limited to 255 characters.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

1 No

Post New Answer