Cant connect to DB from sqlplus but can from SQL Developer
654546Oct 18 2009 — edited Oct 20 2009I had a hard reboot happen from a power failure on my box at home that I have been learning on. I have Ubuntu 8.04 with 11g. I got everything up and running and was able to connect for weeks and had not rebooted until my power failure. Once that happened I have not been able to connect to the db usqing sqlplus and I also can not connect using the enterprise manager console panel. I CAN however connect across my network to the db using SQLDeveloper.
When I try to connect using sqlplus I always get a "ORA-12162: TNS:net service name is incorrectly specified" error.
So I did this:
seth@whale:~$ echo $ORACLE_HOME
/u01/app/oracle/product/11.1.0/db_1
seth@whale:~$ echo $ORACLE_SID
orcl
ORATAB:
orcl:/u01/app/oracle/product/11.1.0/db_1:Y
Im not real sure what else I need to be checking here. Can anyone tell me which files I should be looking at here. I think I just dont have something configured right.
When I try to connect to the EM console I get this:
Firefox can't establish a connection to the server at 192.168.1.101:1158.
The address im trying to connect to is:
https://192.168.1.101:1158/em/console/logon/logon (that worked earlier today before my reboot)
I did a TNSPING and got this:
seth@whale:~$ tnsping 192.168.1.101
TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 18-OCT-2009 20:38:42
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521)))
OK (0 msec)
Im asking this so I can fix it for myself but im also asking and adding as much info as I can because I have searched and searched for this and have only found pieces of this same problem. Im just trying to get some help and have it out there so others might find it too.
Thanks for any help you can give me.