Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g and dbca
DA Morgan wrote:
> fmjohnson_at_gmail.com wrote:
> > Sybrand Bakker wrote:
> >> 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
> >
> > Okay, I took a stab a creating the DB without the listener and oracle
> > promptly reported the same issue, TNS-12154, followed by ORA-01031.
> > Thoughts?
>
> Then lets get down to basics.
>
> What operating system and have you verified kernel parameters if not
> Windows?
>
> What is the value of the ORACLE_SID environment variable?
>
> What is the value of the ORACLE_HOME environment variable?
>
> What exact version of the database to at least 4 decimal points.
>
> Can you ping the server?
>
> Can you use TNSPING successfully?
>
> Post your listener.ora, sqlnet.ora, tnsnames.ora
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Okay, I did verify the kernel parameters, which are the standard
parameters for oracle installations.
# Oracle Configurations
kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 262144 net.core.wmem_max = 262144
Oracle recommends that during the creation of the database, not to set ORACLE_HOME. I did set ORACLE_BASE, which is /u01/app/oracle. drwxr-xr-x 3 oracle dba 4096 Aug 19 11:26 u01
My ORACLE_SID, ORACLE_SID=myhome. This is set in my .bash_profile file.
The version of oracle is 10.1.0.3.
I can ping the server. Also would like to point out that during the initial creation of the database, you don't need to create the LISTENER, as mentioned in the earlier post by Sybrand Bakker, Senior Oracle DBA. Received on Sun Aug 20 2006 - 19:48:57 CDT