| ORA errors when coping Virtual Machine [message #521424] |
Mon, 29 August 2011 16:08  |
 |
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 #521434 is a reply to message #521424] |
Mon, 29 August 2011 21:19  |
|
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 #521436 is a reply to message #521435] |
Mon, 29 August 2011 21:31 |
|
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
