//
you're reading...
Database, IT-Center, Oracle

Oracle, TNS Listener Error in Windows

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>

About berbagisolusi

Berbagi merupakan sebuah bentuk simbol keikhlasan untuk membantu dan menolong, sedangkan solusi adalah cara menyelesaikan masalah. Setiap manusia pasti mengalami masalah, tetapi kita tidak perlu mengalami masalah yang sama jika orang lain pernah mengalami dan kita tahu hal tersebut.

Discussion

No comments yet.

Leave a comment

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 10 other subscribers
December 2011
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

Archives

Web Statistic

Blog Stats

  • 187,032 hits