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

PCC-02447: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers  


NZE-28867: Integer value is too big.

1 Answers  


ORA-15035: no disks belong to diskgroup "string"

1 Answers  


PLS-01913: : instance must of be of type 'string' or one of its subtypes

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  






ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

1 Answers  


ORA-07578: szprv: $FIND_HELD failure

1 Answers  


EXP-00001: data field truncation - column length=number, buffer size=number actual size=number

1 Answers  


NNL-00537: set|show server [<server_name>] : set|show the currently managed server

1 Answers  


ORA-09822: Translation of audit file name failed.

1 Answers  


TNS-12155: TNS:received bad datatype in NSWMARKER packet

1 Answers  


ORA-28591: agent control utility: unable to access parameter file

1 Answers  


Categories