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

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

More Oracle Errors Interview Questions

TNS-00279: Navigator: Failed to Start Tracing

1 Answers  


SQL-02111: Heap consistency error

1 Answers  


ORA-39143: dump file "string" may be an original export dump file

1 Answers  


ORA-19999: skip_row procedure was called

1 Answers  


AMD-00114: PROCEDURE string, internal error

1 Answers  






RMAN-06583: at least 1 channel of TYPE DISK must be allocated to use AS COPY option

1 Answers  


ORA-03212: Temporary Segment cannot be created in locally-managed tablespace

1 Answers  


TNS-02515: Encryption/crypto-checksumming: unknown control type

1 Answers  


ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.

1 Answers  


ORA-12634: Memory allocation failed

1 Answers  


ORA-31670: Username argument must be specified and non-null.

1 Answers  


TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener

1 Answers  


Categories