If you have those problem, follow this intruction :
Solution A. Set Database and restart listener
– open cmd command ( start menu > run > type “cmd” <enter>)
– C:\> set ORACLE_SID=YOUR_ORACLE_DB
– C:\>lsnrctl stop
– C:\>lsnrctl start
– open windows service and starting Service[YOUR_ORACLE_SERVICE]
start menu > run > type “services.msc” <enter>
Solution B. Delete service and create new service
– Open Net Manager, if use Oracle 10g, Start Menu > Oraclexxx > Configuration and Migration Tools > Net Manager
– delete Service Naming accordance your database name
– create new service naming and save through File Menu and Save.
– C:\> set ORACLE_SID=YOUR_ORACLE_DBNAME
– C:\>lsnrctl stop
– C:\>lsnrctl start
– open windows service and starting Service[YOUR_ORACLE_SERVICE]
start menu > run > type “services.msc” <enter>
Discussion
No comments yet.