Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC
- 1 Answers
- 3073 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: PRESPAWN_DESC in each SID_DESC does not have required
fields.
Action: Be sure the parameters required for PRESPAWN_DESC
are specified in each SID_DESC. For example,
SID_LIST_LISTENER =
(SID_LIST=(SID_DESC=(SID_NAME=<sid>)(PRESPAWN_MAX=5)(ORACLE_HOME=<oracle_home>)(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=10)(TIMEOUT=30))))
Add or correct these parameters in the LISTENER.ORA file
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-24407: connection pool already exists
ORA-27008: function called with invalid file structure
ORA-30745: error occured while trying to add column "string" in table "string"
ORA-07456: cannot set RESOURCE_MANAGER_PLAN when database is closed
ORA-39703: server version and script version do not match
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
ORA-06812: TLI Driver: could not read the ethernet driver's node address
IMG-00731: specified page could be found in input image
ORA-29394: session id string and serial# string do not exist
ORA-23405: refresh group number string does not exist
ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type
ORA-07569: slspool: $CLOSE failure
Oracle Errors 
