OraFAQ Forum: Server Administration » URGENT NEED tO RESTORE

Home » RDBMS Server » Server Administration » URGENT NEED tO RESTORE (oracle 8i,windows 2000 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT NEED tO RESTORE [message #393266]

Sat, 21 March 2009 00:23

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

Hi
my system reboot because of power faliure.
now oracle service OracleServiceORCL could not start.
so my dtabase can not up
i have all controlfiles,datafiles and redo log .
how i start now my database

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393279 is a reply to message #393266]

Sat, 21 March 2009 01:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus
/ as sysdba
startup
exit

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393281 is a reply to message #393266]

Sat, 21 March 2009 01:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at alert.log file and Windows event log to know the problem.
Post the error you get when you try to start the database.

Regards
Michel

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393298 is a reply to message #393281]

Sat, 21 March 2009 02:55

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

TNS ORA-12560 is my error

when i use svrmgrl commond

D:\>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12560: TNS:protocol adapter error
SVRMGR>

all services are up

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393300 is a reply to message #393266]

Sat, 21 March 2009 02:55

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 21-MAR-2009 13:19:
28

(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Produc
tion
Start Date 21-MAR-2009 12:25:51
Uptime 0 days 0 hr. 53 min. 37 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\Oracle\Ora81\network\admin\listener.ora
Listener Log File D:\Oracle\Ora81\network\log\listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
orcl has 1 service handler(s)
The command completed successfully

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393302 is a reply to message #393300]

Sat, 21 March 2009 03:04

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

SQL*Plus: Release 8.1.6.0.0 - Production on Sat Mar 21 13:24:30 2009

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393307 is a reply to message #393302]

Sat, 21 March 2009 04:50

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you set ORACLE_HOME and ORACLE_SID?

Regards
Michel

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393329 is a reply to message #393307]

Sat, 21 March 2009 11:41

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

yes i had set both ORACLE_SID and ORACLE_HOME bt still not working............

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393331 is a reply to message #393266]

Sat, 21 March 2009 11:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Post output of
$ SET

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 21 March 2009 11:49]

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393343 is a reply to message #393331]

Sat, 21 March 2009 16:06

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>now oracle service OracleServiceORCL could not start.

Then check your event log.

Babu

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393419 is a reply to message #393343]

Sun, 22 March 2009 14:34

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

i had now delete my SID with

ORADIM -DELETE -SID ORCL and then recreate it
ORADIME -NEW -SID ORCL

then service of oracle started bt
when i connect by sqlplus

connect / as sysdba same ORA-12560 returns...

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393420 is a reply to message #393266]

Sun, 22 March 2009 14:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Post output of
$ SET

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393451 is a reply to message #393420]

Sun, 22 March 2009 23:03

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
CLASSPATH=D:\Oracle\Ora81\orb\classes\yoj.jar;D:\Oracle\Ora81\orb\classes\share.
zip
CLIENTNAME=BAJAJCAP-79A1EA
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=ERPSERVER
ComSpec=C:\WINNT\system32\cmd.exe
DIRCMD=/O
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
LOGONSERVER=\\ERPSERVER
NUMBER_OF_PROCESSORS=2
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;
Path=D:\Oracle\Forms6i\bin;D:\Oracle\Ora81\;D:\Oracle\Ora81\bin;C:\Program Files
\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;D:\Oracl
e\Ora81\orb\bin;D:\Oracle\Forms6i\jdk\bin;\;\DOS;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 3 Stepping 4, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0304
ProgramFiles=C:\Program Files
PROMPT=$p$g
SESSIONNAME=RDP-Tcp#1
SystemDrive=C:
SystemRoot=C:\WINNT
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1
USERDOMAIN=ERPSERVER
USERNAME=Administrator
USERPROFILE=C:\Documents and Settings\Administrator
windir=C:\WINNT
wv_gateway_cfg=D:\Oracle\Forms6i\listener\cfg\wdbsvr.app

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393453 is a reply to message #393266]

Sun, 22 March 2009 23:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>yes i had set both ORACLE_SID and ORACLE_HOME
I'd like to point out that neither ORACLE_SID nor ORACLE_HOME are SET as you can see in your most recent post.

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393475 is a reply to message #393453]

Mon, 23 March 2009 00:29

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

Thanks A lot BlackSwan
now i had set both and it works.
when i go for export
then same error
ora 12560 come
i am not able to export please help.........

[Updated on: Mon, 23 March 2009 00:30]

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393477 is a reply to message #393266]

Mon, 23 March 2009 00:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't know what you are seeing.
I don't know what you are doing.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

I believe you have a problem, but you provide no useful information to assist you.

>now i had set both and it works.
So you say.

>when i go for export then same error
So you say

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393544 is a reply to message #393475]

Mon, 23 March 2009 05:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If this is the only (or primary) database on this server, make sure the ORACLE_SID value is set in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME, otherwise you will have to set the ORACLE_SID each time you execute a command prompt or you will have to define the value in your environment variables settings.

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393547 is a reply to message #393477]

Mon, 23 March 2009 05:36

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

please post/print your Error here .
And read the forum guide lines.
http://www.orafaq.com/forum/t/88153/0/.

whats your export version?

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393548 is a reply to message #393547]

Mon, 23 March 2009 05:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

The OP posted his error. What does version of exp have to do with 12560 error?

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393551 is a reply to message #393548]

Mon, 23 March 2009 05:47

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

when i go for export
then same error
ora 12560 come
i am not able to export please help.........

i thought that if DB version,exp version are diff?

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393559 is a reply to message #393551]

Mon, 23 March 2009 06:31

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1237807727550+28353475&threadId=117296

there you can find the valuble solutions.....provided.

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393560 is a reply to message #393559]

Mon, 23 March 2009 06:33

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

please post/print your Error here .

i mean...what exactly he did ...post the screen here...insted of saying...

thanks & regards

SRIRAM

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393574 is a reply to message #393560]

Mon, 23 March 2009 07:34

sameer_2230
Messages: 19
Registered: March 2009
Location: India

Junior Member

D:\Oracle\Ora81\BIN>sqlplus /nolog

SQL*Plus: Release 8.1.6.0.0 - Production on Mon Mar 23 17:55:48 2009

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> conn / @8i as sysdba
Connected.
SQL>

D:\>cd oracle\ora81\bin

D:\Oracle\Ora81\BIN>exp

Export: Release 8.1.6.0.0 - Production on Mon Mar 23 17:57:33 2009

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Username: system
Password:

EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully

D:\Oracle\Ora81\BIN>

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393575 is a reply to message #393574]

Mon, 23 March 2009 07:37

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

SQL> conn / @8i as sysdba
Connected.
SQL>

EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully

Try