ORA-07202: sltln: invalid parameter to sltln

Posted in: Technical Track

I hit this issue today while creating a new 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!

Interested in working with Alex? Schedule a tech call.

About the Author

What does it take to be chief technology officer at a company of technology experts? Experience. Imagination. Passion. Alex Gorbachev has all three. He’s played a key role in taking the company global, having set up Pythian’s Asia Pacific operations. Today, the CTO office is an incubator of new services and technologies – a mini-startup inside Pythian. Most recently, Alex built a Big Data Engineering services team and established a Data Science practice. Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the OakTable.

4 Comments. Leave new

Syed Jaffar Hussain
January 21, 2007 12:01 pm

I thought experts love to work with command line utility rather than GUI.
Interesting move Alex.


Alex Gorbachev
January 21, 2007 2:47 pm

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
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.



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.


Leave a Reply

Your email address will not be published. Required fields are marked *