Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or
POOL_SIZE parameter from PRESPAWN_DESC



TNS-01156: Missing or inappropriate PROTOCOL, TIMEOUT or POOL_SIZE parameter from PRESPAWN_DESC..

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

Post New Answer

More Oracle Errors Interview Questions

PLS-00624: USING clause must be used with either aggregate or pipelined functions

1 Answers  


ORA-13240: specified dimensionality greater than that of the query mbr

1 Answers  


TNS-01016: change_password [<listener_name>]: changes the password of the listener

1 Answers  


ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.

1 Answers  


ORA-23607: invalid column "string"

1 Answers  


ORA-06538: statement violates string RESTRICT_REFERENCES pragma

1 Answers  


ORA-40208: duplicate or multiple algorithm settings for function string

1 Answers  


ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context

1 Answers  


PLS-00127: Pragma string is not a supported pragma

1 Answers  


RMAN-06070: DBWR could not identify datafile string

1 Answers  


DRG-50701: error in listener.get_cmd()

1 Answers  


ORA-00910: specified length too long for its datatype

1 Answers  


Categories