My sequence of steps for troubleshooting
1. Is the listener resolvable? C:\>tnsping MYDB (Confirms: the database listener is running on serverside)
2. Is there a firewall issue? C:\>telnet hostname 1521
3. Can I login? C:\>sqlplus system/pass@MYDB or C:\>sqlplus system/pass@hostname:1521/MYDB (Confirms: The database is open)
4. Finally, chances of having a successful login with your favorite dev-tool has increased by 100%
1. Is the listener resolvable? C:\>tnsping MYDB (Confirms: the database listener is running on serverside)
2. Is there a firewall issue? C:\>telnet hostname 1521
3. Can I login? C:\>sqlplus system/pass@MYDB or C:\>sqlplus system/pass@hostname:1521/MYDB (Confirms: The database is open)
4. Finally, chances of having a successful login with your favorite dev-tool has increased by 100%
No comments:
Post a Comment