Home » RDBMS Server » Server Administration » URGENT NEED tO RESTORE (oracle 8i,windows 2000 server)
URGENT NEED tO RESTORE [message #393266] Sat, 21 March 2009 00:23 Go to next message
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
Re: URGENT NEED tO RESTORE [message #393279 is a reply to message #393266] Sat, 21 March 2009 01:25 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
sqlplus
/ as sysdba
startup
exit
Re: URGENT NEED tO RESTORE [message #393281 is a reply to message #393266] Sat, 21 March 2009 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: URGENT NEED tO RESTORE [message #393298 is a reply to message #393281] Sat, 21 March 2009 02:55 Go to previous messageGo to next message
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

Re: URGENT NEED tO RESTORE [message #393300 is a reply to message #393266] Sat, 21 March 2009 02:55 Go to previous messageGo to next message
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
Re: URGENT NEED tO RESTORE [message #393302 is a reply to message #393300] Sat, 21 March 2009 03:04 Go to previous messageGo to next message
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
Re: URGENT NEED tO RESTORE [message #393307 is a reply to message #393302] Sat, 21 March 2009 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you set ORACLE_HOME and ORACLE_SID?

Regards
Michel
Re: URGENT NEED tO RESTORE [message #393329 is a reply to message #393307] Sat, 21 March 2009 11:41 Go to previous messageGo to next message
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............
Re: URGENT NEED tO RESTORE [message #393331 is a reply to message #393266] Sat, 21 March 2009 11:47 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>now oracle service OracleServiceORCL could not start.

Then check your event log.

Babu
Re: URGENT NEED tO RESTORE [message #393419 is a reply to message #393343] Sun, 22 March 2009 14:34 Go to previous messageGo to next message
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...
Re: URGENT NEED tO RESTORE [message #393420 is a reply to message #393266] Sun, 22 March 2009 14:40 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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/
Re: URGENT NEED tO RESTORE [message #393451 is a reply to message #393420] Sun, 22 March 2009 23:03 Go to previous messageGo to next message
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
Re: URGENT NEED tO RESTORE [message #393453 is a reply to message #393266] Sun, 22 March 2009 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: URGENT NEED tO RESTORE [message #393475 is a reply to message #393453] Mon, 23 March 2009 00:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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
Re: URGENT NEED tO RESTORE [message #393544 is a reply to message #393475] Mon, 23 March 2009 05:32 Go to previous messageGo to next message
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.
Re: URGENT NEED tO RESTORE [message #393547 is a reply to message #393477] Mon, 23 March 2009 05:36 Go to previous messageGo to next message
ramoradba
Messages: 2454
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?
Re: URGENT NEED tO RESTORE [message #393548 is a reply to message #393547] Mon, 23 March 2009 05:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The OP posted his error. What does version of exp have to do with 12560 error?
Re: URGENT NEED tO RESTORE [message #393551 is a reply to message #393548] Mon, 23 March 2009 05:47 Go to previous messageGo to next message
ramoradba
Messages: 2454
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?


Re: URGENT NEED tO RESTORE [message #393559 is a reply to message #393551] Mon, 23 March 2009 06:31 Go to previous messageGo to next message
ramoradba
Messages: 2454
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.
Re: URGENT NEED tO RESTORE [message #393560 is a reply to message #393559] Mon, 23 March 2009 06:33 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: URGENT NEED tO RESTORE [message #393574 is a reply to message #393560] Mon, 23 March 2009 07:34 Go to previous messageGo to next message
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>


Re: URGENT NEED tO RESTORE [message #393575 is a reply to message #393574] Mon, 23 March 2009 07:37 Go to previous messageGo to next message
babuknb
Messages: 1734
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

exp username/password@sid ....



Else

set ORACLE_SID=8i


Try to export (your own way)

PS: Please start new thread for export problem; Don't continue this thread.

Babu

[Updated on: Mon, 23 March 2009 07:42]

Report message to a moderator

Re: URGENT NEED tO RESTORE [message #393581 is a reply to message #393574] Mon, 23 March 2009 07:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
sameer_2230 wrote on Mon, 23 March 2009 08:34
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>


And YET you still fail to set ORACLE_SID as suggested days ago ??

I keep hitting my head into the wall...why does it hurt ? ./fa/1620/0/
Re: URGENT NEED tO RESTORE [message #393667 is a reply to message #393581] Tue, 24 March 2009 00:44 Go to previous messageGo to next message
sameer_2230
Messages: 19
Registered: March 2009
Location: India
Junior Member

thanks to all....
now everything is fine.
Re: URGENT NEED tO RESTORE [message #393668 is a reply to message #393266] Tue, 24 March 2009 00:46 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Posting Guideline state that you should post solution so others can benefit!
Previous Topic: Validity of DBMS_RANDOM
Next Topic: Available disk space
Goto Forum:
  


Current Time: Thu Dec 08 04:08:58 CST 2016

Total time taken to generate the page: 0.13141 seconds