I've installed 10.2.0.4 on Leopard 10.5.6. Once I created a database, I connected to it and then logged out successfully. But after a reboot, I cannot connect to it anymore.
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Apr 26 22:30:02 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
ORA-12547: TNS:lost contact
Here's lsnrctl output:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
STATUS of the LISTENER
Version TNSLSNR for MacOS X Server: Version 10.2.0.4.0 - Production
Start Date 26-APR-2009 16:39:24
Uptime 0 days 6 hr. 6 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File /Users/oracle/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /Users/oracle/oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
And tnsping is OK:
bash-3.2$ tnsping macora
TNS Ping Utility for MacOS X Server: Version 10.2.0.4.0 - Production on 26-APR-2009 22:46:41
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = macora)))
OK (0 msec)