SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: php with oracle tips enquiry
-
May 13, 2009, 19:52 #1
- 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 identifierLast edited by falconlee; May 13, 2009 at 23:13.
-
May 13, 2009, 21:24 #2
- 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
-
May 13, 2009, 23:32 #3
- 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)
)
)
-
May 13, 2009, 23:54 #4
- 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