Re: Oracle 10g and dbca

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Aug 2006 20:21:30 -0700
Message-ID: <1156130490.978737@bubbleator.drizzle.com>

fmjohnson_at_gmail.com wrote:
> 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
> fs.file-max = 65536
> 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.

I normally use this:

net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1

but I don't see that leading to where you are.

How about the equivalents of these?
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF cat >> /etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so session required pam_limits.so
EOF cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then

   if [ \$SHELL = "/bin/ksh" ]; then

     ulimit -p 16384
     ulimit -n 65536
   else
     ulimit -u 16384 -n 65536

   fi
   umask 022
fi
EOF Though again I don't see them as the cause.

You can post your .bash_profile, I use generally use .bash_rc but again I don't see it as the issue.

what is the result of tnsping?
and are you sure ORACLE_HOME and your oinstall and dba groups are correctly assigned?

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

Received on Sun Aug 20 2006 - 22:21:30 CDT