I hit this issue today while creating a new 10.2.0.3 database using DBCA. Recently, I’ve started to use DBCA more often and I try to use its template management capabilities. It looks like templates is not the most robust feature of Database Configuration Assistant. Sometimes, there are issues when I want to reuse template.
Today was no exception. I saved template earlier and tried to reuse it today. However, CREATE DATABASE failed with ORA-07202: sltln: invalid parameter to sltln.
I reviewed the parameters and found that control_files is set to an empty string. Checked Metaclick and, indeed, this error is related to empty control_files parameter. After I fixed that – DBCA continue flawlessly. I can’t believe I’m getting used to the GUI!
4 Comments. Leave new
I thought experts love to work with command line utility rather than GUI.
Interesting move Alex.
Jaffar
Well, I doubt that “expertness level” has much to do with whether you use GUI or not.
An expert should understand how the GUI works behind the scene and should be able to get the job done even if GUI tools are not available.
By the way, I’m sure there are many people using GUI (including DBCA) and you can call them experts with much more confidence than me. ;)
Just hit the same thing using DBCA / templates in 10.2.0.3
I’m glad this blog entry popped up first in google search :-)
100% agree on GUI. Use it as a shortcut for frequently used and well understood functionality.
Sergey
I use the DBCA a lot to create and save the db creation script, although I feel I should start using templates and give it a shot. I have heard that when you have to do a whole bunch of installs the templates come real handy. Any input you can give us on using templates will definitely be of great benefit to us.