Home » RDBMS Server » Server Administration » ORA-03114 error while creating DB using DBCA (Oracle Enterprise 11.1.0.7, RHEL 5)
ORA-03114 error while creating DB using DBCA [message #584648] Thu, 16 May 2013 09:31 Go to next message
rcct
Messages: 18
Registered: May 2013
Location: Ottawa, ON
Junior Member
I am getting a ORA-03114 (not connected to Oracle) error when I am creating a DB using DBCA. Here are the steps that I do:

1) Log onto the server remotely, using Exceed Query
2) Connect as the oracle user (Oracle)
3) set ORACLE_HOME, PATH
4) Run DBCA, give parameters

At around 12% and again at 19%, I get the error (see screenshot). I also tried to generate the scripts and run them remotely, and the steps run successfully upto & including the step " startup nomount pfile="/oracle/admin/<dbname>/scripts/init.ora"; ". After that, when I try to run the script specified in rmanRestoreDatafiles.sql from SQL> prompt, the error appears, and connection to ORACLE is lost.

Googling the error shows that it is a connectivilty issue, and Oracle says that it is usually caused by user scripts. But I am not running any user-created scripts as part of the DBCA process. Somehow, the instance is timing out immediately after doing the "startup nomount".


Any ideas? Thanks, Roy.
  • Attachment: 03114.JPG
    (Size: 93.46KB, Downloaded 59 times)

[Updated on: Thu, 16 May 2013 09:32]

Report message to a moderator

Re: ORA-03114 error while creating DB using DBCA [message #584649 is a reply to message #584648] Thu, 16 May 2013 09:38 Go to previous messageGo to next message
BlackSwan
Messages: 21966
Registered: January 2009
Senior Member
>3) set ORACLE_HOME, PATH

post URL to documentation that says to do above.

post results from following OS commands

id
env | sort
uname -a
hostname
cat /etc/hosts
/sbin/ifconfig

COPY the results from commands above then PASTE all back here
Re: ORA-03114 error while creating DB using DBCA [message #584661 is a reply to message #584649] Thu, 16 May 2013 10:16 Go to previous messageGo to next message
rcct
Messages: 18
Registered: May 2013
Location: Ottawa, ON
Junior Member
For the URL, I dont remember exactly where I had seen it, I did it so that the DBCA command is set up automatically. I guess I could have also gone to ORACLE_HOME/bin and run it.

[oracle@roytest ~]$ id
uid=504(oracle) gid=502(dba) groups=502(dba)

[oracle@roytest ~]$ env | sort
_=/bin/env
CVS_RSH=ssh
DISPLAY=10.1.106.145:0.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/oracle
HOSTNAME=roytest.privatedomain.ca
INPUTRC=/etc/inputrc
KDEDIR=/usr
KDE_IS_PRELINKED=1
KDE_NO_IPV6=1
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
PATH=/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/oracle/bin:/oracle/scripts
PWD=/oracle
QTDIR=/usr/lib64/qt-3.3
QTINC=/usr/lib64/qt-3.3/include
QTLIB=/usr/lib64/qt-3.3/lib
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
USER=oracle
XAUTHORITY=/oracle/.xauthcqoYqH

[oracle@roytest ~]$ uname -a
Linux roytest.privatedomain.ca 2.6.18-308.11.1.el5 #1 SMP Fri Jun 15 15:41:53 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

[oracle@roytest ~]$ hostname
roytest.privatedomain.ca

[oracle@roytest ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 roytest.privatedomain.ca roytest localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

[oracle@roytest ~]$ /sbin/ipconfig
-bash: /sbin/ipconfig: No such file or directory
Re: ORA-03114 error while creating DB using DBCA [message #584662 is a reply to message #584661] Thu, 16 May 2013 10:25 Go to previous messageGo to next message
BlackSwan
Messages: 21966
Registered: January 2009
Senior Member
>[oracle@roytest ~]$ /sbin/ipconfig
>-bash: /sbin/ipconfig: No such file or directory


it appears that COPY & PASTE are broken for you since that is NOT what I requested.
Re: ORA-03114 error while creating DB using DBCA [message #584663 is a reply to message #584662] Thu, 16 May 2013 10:28 Go to previous message
rcct
Messages: 18
Registered: May 2013
Location: Ottawa, ON
Junior Member
Sorry, my mistake:

[oracle@roytest ~]$ /sbin/ifconfig
eth0 Link encap:Ethernet HWaddr 00:21:5A:5E:02:C6
inet addr:10.1.2.4 Bcast:10.0.22.255 Mask:255.255.255.0
inet6 addr: fe80::221:5aff:fe5e:2c6/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1971428656 errors:0 dropped:0 overruns:0 frame:0
TX packets:10065351471 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:401272606612 (373.7 GiB) TX bytes:14486360270740 (13.1 TiB)
Interrupt:169 Memory:f8000000-f8012800

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:125281239 errors:0 dropped:0 overruns:0 frame:0
TX packets:125281239 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:29414914686 (27.3 GiB) TX bytes:29414914686 (27.3 GiB)
Previous Topic: back track os processes to rdbms
Next Topic: ORA-01034 received when to install
Goto Forum:
  


Current Time: Wed Apr 23 16:36:05 CDT 2014

Total time taken to generate the page: 0.10113 seconds