-
After restoring my backup I could'nt connect the database from the remote machine, because the restore process does'nt create a windows nt service for my restored database.
How can I create a service on windows nt for my restored database? And how can I link the service to the restored database?
Please help me....
renjith r krishna
-
Try reloading/restarting your listener using 'lsnrctl' utility and try connecting to remote database. If you are sure about recreating service you have to use 'oradim' utility to drop existing link and recreate new one.
You can also try connecting at remote machine prompt
set local=net8_service_name
connect svrmgrl/SQL+