Home » Infrastructure » Other Operating Systems » ORA errors when coping Virtual Machine (Oracle Linux 4, Oracle 11gR2)
ORA errors when coping Virtual Machine [message #521424] Mon, 29 August 2011 16:08 Go to next message
Mewpher
Messages: 3
Registered: August 2011
Location: Peru
Junior Member
hello,

Well i have a problem with my virtual machine. I copied it from another computer, i start it and everything normal until i want to start oracle.

When i try to start the listener i get this errors:
TNS-12543
TNS-12560
TNS-00513

When i try to start de oracle db i get this errors:
ORA-24324
ORA-24323
ORA-03113

I also get error when i tri to create de pfile from the spfile and start the rmon.

I configured the ip and dns when i started for the first time the virutal machine and changed de tnsnames.ora, but still can't start de db.

Can anybody help me?

Thanks
Re: ORA errors when coping Virtual Machine [message #521433 is a reply to message #521424] Mon, 29 August 2011 20:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
open a Terminal Window & issue following OS commands

id
env | sort
lsnrctl start
lsnrctl status
sqlplus
/ as sysdba
startup
exit
lsnrctl service

COPY commands (above) & results then PASTE all back here
icon5.gif  Re: ORA errors when coping Virtual Machine [message #521434 is a reply to message #521424] Mon, 29 August 2011 21:19 Go to previous messageGo to next message
Mewpher
Messages: 3
Registered: August 2011
Location: Peru
Junior Member
this are the results of the comands, now i have an ORA-01012 error when i try to startup:

[oracle@pcoracle ~]$id
uid=500(oracle) gid=500(oinstall)) groups=500(oinstall),501(dba),502(oper),503(sysasm)

[oracle@pcoracle ~]$env | sort
_=/bin/env
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=pcoraclectg.educa.edu.pe
INPUTRC=/etc/inputrc
KDEDIR=/usr
LANG=/en_US.UTF-8
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=PRSID
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bi:/home/oracle/bin:
/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product-11.2.0/dbhome_1/OPatch
PWD=/home/oracle
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=linux
USER=oracle

[oracle@pcoracle ~]$lsnrctl start
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/pcoraclectg/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pcoraclectg.educa.edu.pe)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 113: No route to host

[oracle@pcoracle ~]$lsnrctl status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 113: No route to host


[oracle@pcoracle ~]$sqlplus / as sysdba
sql>startup
ORA-01012: not logged on


[oracle@pcoracle ~]$lsnrctl service
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 113: No route to host

[Updated on: Tue, 30 August 2011 01:02] by Moderator

Report message to a moderator

Re: ORA errors when coping Virtual Machine [message #521435 is a reply to message #521434] Mon, 29 August 2011 21:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
OS/networking misconfiguration
Oracle is victim; not culprit.
Problem & fix are at OS level & have nothing to do with Oracle configuration

cat /etc/hosts
uname -a

COPY commands & results from above then PASTE all back here
Re: ORA errors when coping Virtual Machine [message #521436 is a reply to message #521435] Mon, 29 August 2011 21:31 Go to previous messageGo to next message
Mewpher
Messages: 3
Registered: August 2011
Location: Peru
Junior Member
ok, thank you for your help:

[oracle@pcoracle ~]$cat /etc/hosts
127.0.0.1	localhost.localdomain	localhost
172.68.1.2	pcoracle.educa.edu.pe		pcoracle
172.68.1.3	pcoraclectg.cibertec.edu.pe	pcoraclectg

[oracle@pcoracle ~]$uname -a
Linux pcoraclectg.educa.edu.pe 2.6.9-89.0.0.0.1.ELsmp #1 SMP 
Tue May 19 04:23:49 EDT 2009 i686 athlon i386 GNU/Linux

[Updated on: Tue, 30 August 2011 01:02] by Moderator

Report message to a moderator

Re: ORA errors when coping Virtual Machine [message #521437 is a reply to message #521436] Mon, 29 August 2011 22:14 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ping 172.68.1.3
ping pcoraclectg.cibertec.edu.pe

COPY commands & results from above then PASTE all back here
Previous Topic: how to create setup in d2k for my project
Next Topic: failed to add Oracle VM Server to Server pool
Goto Forum:
  


Current Time: Thu Mar 28 03:53:04 CDT 2024