|
|
| Re: Tns protocol adapter error [message #62870 is a reply to message #62791] |
Fri, 20 August 2004 20:34  |
Balaji
Messages: 102
Registered: October 2000
|
Senior Member |
|
|
1 . TNS protocl error is flashed if the user is not able to connect to the database from a client machine for several reasons the simplest is that the connect string is not among the valid names tnsnames.ora available on the client machine for the protocol used .
2.If you find a datafile missing then
a.make the datafile offline
b.copy the same from the latest available backup
c.restore using the archive logs
if your database is in noarchivelog mode then
you can restore the database using the full coldbackup or an export which ever is the latest.forget about the changes made to the database after the export/coldbackup date/time.
with best wishes
balaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
