| Taqi |
Posted: May 05, 2008 04:01:43 PM |
Total Post: 6
Joined: Apr, 2008
|
Hi,
I lost system datafile of my prod DB, I tried recovering it through RMAN, I have two databases one is tha prod and the other is catalog. I was connected to rman at the time when the database was running fine, suddenly I got the error at the prod database regarding the lost datafile. So, first I tried to shutdown the databse from rman, it got down, then when I tried to startup the database in nomount stage I got this error...
ORA-03002: failure of startup command at 05/05/2008 and the time,
ORA-28547: connection to server failed, probable Oracle Net admin error
then I exited from RMAN...
Again tried to connect to rman using this..
rman catalog user_rman/passwd target sys/passwd@to_rman and got the following errors
RMAN-00554:initialization of internal recovery manager package failed
RMAN-04005:error from target database
ORA-28547: connection to server failed, probable Oracle Net admin error
PLEASE help me guys...
Thanks and Regards
Taqi
|
|
|
 Mohammed Taj |
| Posted: May 06, 2008 12:49:34 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
First tell us where you see and come to know is your datafile is lost?
it is just NETWORK error
read this
ORA-28547: connection to server failed, probable Oracle Net admin error
Cause: A failure occurred during initialization of a network connection from a client process to the Oracle server: The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, usually due to use of different network protocols by opposite sides of the connection. This usually is caused by incorrect Oracle Net administrative setup for database links or external procedure calls. The most frequent specific causes are: -- The connection uses a connect string which refers to a Heterogeneous Services agent instead of an Oracle server. -- The connection uses a connect string which includes an (HS=) specification.
Action: Check Oracle Net administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client connection to the ORACLE server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID refers to the correct server. -- Confirm in TNSNAMES.ORA or the equivalent service definition that the connect string does NOT contain (HS=).
|
|
|
|
|
| Taqi |
| Posted: May 06, 2008 08:28:11 AM | |
|
Total Post: 6
Joined: Apr, 2008
|
when I tried to query some databse view, it gives me error message that the system datafile is missing...
the listener's and the Tnsnames.ora's sid is same
TNSNAMES_to_rman =
(DESCRIPTION =
(ADDRESS =(PROTOCOL=TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
|
|
|
|
|
| Taqi |
| Posted: May 06, 2008 08:33:46 AM | |
|
Total Post: 6
Joined: Apr, 2008
|
the file continues...
(SERVICE_NAME =Taqi)
)
)
and the listener.ora file read as this...
SID_LIST_LISTENER_rman =
(SID_LIST=
(SID_DESC =
(SID_NAME = Taqi)
(ORACLE_HOME =/oraeng/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
)
listener_RMAN =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = PROTOCOL =TCP)(HOST = localhost.localdomain)(PORT =1521))
)
)
|
|
|
|
|
| Taqi |
| Posted: May 06, 2008 08:33:57 AM | |
|
Total Post: 6
Joined: Apr, 2008
|
the file continues...
(SERVICE_NAME =Taqi)
)
)
and the listener.ora file read as this...
SID_LIST_LISTENER_rman =
(SID_LIST=
(SID_DESC =
(SID_NAME = Taqi)
(ORACLE_HOME =/oraeng/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
)
listener_RMAN =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = PROTOCOL =TCP)(HOST = localhost.localdomain)(PORT =1521))
)
)
|
|
|
|
|
| Taqi |
| Posted: May 06, 2008 08:34:36 AM | |
|
Total Post: 6
Joined: Apr, 2008
|
sorry for pasting it twice......
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
