setuporacle

Oracle Setup

Setting up Oracle might be a bit tricky. Important is to define a new user and assign a schema to this user so that the PHsPeed IDE will only retrieve data from the user's schema. If you have a database administrator on company sites then it might be that Oracle has been setup differently. But for a local oracle instance (developer edition) this is the case.

As we run the Oracle instance in a Virtual Machine, we were not able to connect as localhost, but needed to use the IP. In the above screenshot, there is an iso characterset, but you can use UTF8 as well. After clicking on test/show databases,you can select the required database and schema.

PDO String

On local instances, the pdo string is very simple:

oci:dbname={%dbname%}

On remote database instances, the connection is more complex:

oci:dbname=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={%host%})(PORT={%port%))(CONNECT_DATA=(SERVICE_NAME=XE)))

If in doubt, contact your data base administrator to setup the correct parameters.

  • setuporacle.txt
  • Last modified: 2020/11/03 15:12
  • by aducomadmin