Oracle - TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

PHPMaker General Discussion (PHPMaker)
1

hello …
I am try to develop a project that connected to Oracle Databasei have set all Configuration to my oracle DB and i was ablity to bield the project but i got this error while try browse itC:\xampp\htdocs\oracelproject\vendor\doctrine\dbal\src\Driver\API\OCI\ExceptionConverter.php(72): An exception occurred in the driver: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATAhere the listener.ora Network Configuration

# listener.ora Network Configuration File: C:\instantclient_19_11\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\Users\lilri\Desktop\oracelDB\WINDOWS.X64_213000_db_home)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\Users\lilri\Desktop\oracelDB\WINDOWS.X64_213000_db_home\bin\oraclr.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)) ----- > i have try add this line but still get same error
    )
  )

any idea ?
thanx…

2

rembo wrote:listener.ora Network Configuration File: C:\instantclient_19_11\listener.oravs.(ORACLE_HOME = C:\Users\lilri\Desktop\oracelDB\WINDOWS.X64_213000_db_home)Are you sure you are checking the correct .ora file used by your PHP processor?You install both instant client and oracle, you need to check which .ora is being used, you should also check \NETWORK\ADMIN\tnsnames.ora. Make sure the service name you used in PHPMaker is in the correct .ora file.

3

Thanx to you … i have check the PHPMaker database Configuration … was missing to add DB server Name to the connection data
Now it’s work , I just add the server of DB Name to the TNS name optionsbefore :
localhost:1521after fixed :
localhost:1521/orcl