This discussion is archived
1 Reply Latest reply: Apr 29, 2009 6:51 AM by 409817 RSS

After installing oracle 10gr2 on Leopard, got ORA-12547

409817 Newbie
Currently Being Moderated
Hello everyone,

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
ERROR:
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
------------------------
Alias 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
SNMP OFF
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...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services 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:
/Users/oracle/oracle/product/10.2.0/network/admin/sqlnet.ora
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)

Any suggestions? Thank you in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points