1 Reply Latest reply on Apr 29, 2009 1:51 PM by 409817

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

      Hello everyone,

      I've installed 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 - 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:

      STATUS of the LISTENER
      Alias LISTENER
      Version TNSLSNR for MacOS X Server: Version - 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...
      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 - 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 = = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = macora)))
      OK (0 msec)

      Any suggestions? Thank you in advance.