1 Reply Latest reply: Apr 29, 2009 8:51 AM by 409817 RSS

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

    409817
      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.