Re: Oracle 10g and dbca

On 20 Aug 2006 11:08:23 -0700, fmjohnson_at_gmail.com wrote:

>I've encountered an unusual problem creating a new database using
>Oracle 10g dbca. Whenever I attempt to create the first and only
>database using dbca, it reports TNS 12154, and ORA-01031 errors. I have
>been using several resources on the web to perform this procedure to
>include Dizwell and Puschitz's sites to ensure that I have the precise
>procedures, and have shared this problem with my company's Oracle DBA.
>I am also a pretty experienced system administator and oracle
>administrator, but have been unable to resolve this problem. I have a
>new installation of CentOS 4.3, on a Dell 4100 dimension with 512MB
>memory. I successfully installed only the oracle software, Oracle
>10.1.0.3. I then created the listener using netca, and then attempted
>to create the database using dbca. It immediately reported the
>TNS-12154 error, which I selected to ignore, but it is then followed by
>the ORA-01031-insufficient privileges error. Moreover, I have performed
>this operation succesfully on another machine. Any suggestions would be
>welcomed. What could I be missing?

Usually one creates the database prior to setting up the listener. The errors you are getting now, you are getting *because* the database doesn't exist.

--
Sybrand Bakker, Senior Oracle DBA