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
Printable View
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
I hope those aren't the actual user name and password for the whole world to see.:eek:
The 'ORCL' must not be the correct value for that parameter. See the 'db' parameter for oci_connect
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=192.168.1.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
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???