SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    May 2009
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    php with oracle tips enquiry

    my oracle already install into my pc and its also can use. But i cannot connect with php. Why?

    my code:
    $c = oci_connect('****', '****', '****');

    Error:
    ORA-12154: TNS:could not resolve the connect identifier
    Last edited by falconlee; May 13, 2009 at 23:13.

  2. #2
    SitePoint Addict
    Join Date
    Jul 2008
    Posts
    213
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I hope those aren't the actual user name and password for the whole world to see.

    The 'ORCL' must not be the correct value for that parameter. See the 'db' parameter for oci_connect

  3. #3
    SitePoint Member
    Join Date
    May 2009
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST=192.168.1.10)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

  4. #4
    SitePoint Member
    Join Date
    May 2009
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When i restart oracle
    root@u804d:~# /etc/init.d/oracledb restart
    Shutdown Oracle:
    LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-MAY-2009 14:48:53

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS: protocol adapter error
    TNS-00511: No listener
    Linux Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1521)))
    TNS-12532: TNS: invalid argument
    TNS-12560: TNS: protocol adapter error
    TNS-00502: Invalid argument
    Linux Error: 101: Network is unreachable
    Processing Database instance "orcl": log file /u01/app/ubs/product/11.1.0/db_1/shutdown.log
    OK
    Starting Oracle:
    LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-MAY-2009 14:49:21

    Copyright (c) 1991, 2007, Oracle. All rights reserved.

    Starting /u01/app/ubs/product/11.1.0/db_1/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.1.0.6.0 - Production
    System parameter file is /u01/app/ubs/product/11.1.0/db_1/network/admin/listener.ora
    Log messages written to /u01/app/ubs/diag/tnslsnr/u804d/listener/alert/log.xml
    Error listening on: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    TNS-12546: TNS: permission denied
    TNS-12560: TNS: protocol adapter error
    TNS-00516: Permission denied
    Linux Error: 13: Permission denied

    Listener failed to start. See the error message(s) above...

    Processing Database instance "orcl": log file /u01/app/ubs/product/11.1.0/db_1/startup.log
    OK

    It come out these msg, what does it mean? not connected? So my solution is???


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •