Database Administration (MOSC)

MOSC Banner

Challenge! how to pass init parameters needing single quotes to dbca.rsp INITPARAMS parameter (silen

edited Jul 31, 2020 5:47AM in Database Administration (MOSC) 3 commentsAnswered

I want to use "dbca -silent -responseFile " command to create a 10g db.

I want to specify the following init parameters in INITPARAMS line in dbca.rsp

INITPARAMS= "db_recovery_file_dest_size=10240000,parallel_max_servers=5,compatible='10.2.0.0.0',nls_language='ENGLISH_UNITED KINGDOM.WE8ISO8859P15'"

The dbca command fails because it does not like single quotes in INITPARAMS value. The error I get is : For input string: "Unexpected error!!!" - that's it. no other error information.

dbca command works if :

1. INITPARAMS has only one value with single quotes e.g. INITPARAMS= "nls_language='ENGLISH_UNITED KINGDOM.WE8ISO8859P15'"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center