I can´t connect with a oracle db

I try it anothe one but i can't it.

I install oci8 to PHP but i have problems to connect.

This is the steps:

1. STEP
apt-get install php5-common php5 php5-dev libapache2-mod-php5 php5-cli

2. STEP

apt-get install build-essential php-pear

3. STEP

apt-get install libaio1

4. STEP - Download SDK an basic from:

www.oracle.com/technology/software/tech/...antclient/index.html

5. STEP

mkdir /opt/oracle

6. STEP

mv /ruta/archivos/zip/Basic.zip /opt/oracle
mv /ruta/archivos/zip/SDK.zip /opt/oracle

7. STEP

cd /opt/oracle

8. STEP

unzip \*.zip

9. STEP

mv instantclient_11_2 instantclient

10. STEP

cd instantclient

11. STEP

ln -s libclntsh.so.11.1 libclntsh.so
ln -s libocci.so.11.1 libocci.so

12. STEP

mkdir /opt/oracle/src

13. Download oci8-1.4.1.tgz from pecl.php.net/package/oci8

cd /opt/oracle/src



14. STEP

tar xzvf /opt/oracle/src/oci8-1.2.4.tgz

15. STEP

cd /opt/oracle/src/oci8-1.2.4

phpize

16. STEP

export ORACLE_HOME=/opt/oracle/instantclient

17. STEP

./configure --with-oci8=share,instantclient,/opt/oracle/instantclient

18. STEP

make

19. STEP

make install

20. add this line in /etc/php5/apache2/php.ini

extension=oci8.so

21 STEP:

echo /opt/oracle/instantclient >> /etc/ld.so.conf

ldconfig

22. STEP

/etc/init.d/apache2 restart

23. Verify in backend of joomla in php info OCI8 or create a phpinfo.php.

<?php
phpinfo();
?>



this is rigth??

Hi,

so, on one machine it is ok, on another it is not?

I suggest you to take the same steps as you did for the first machine. Just to be sure everything is ok, install the same version of TableJX as you did on the first machine, so probably this is TableJX version 4 (if I remember correctly).

Besides that if you are connecting remotely, be sure that correct port on firewall and router is opened.(normally this is port 1521) - if this is a network with more than one computer also be sure if port-forwarding to correct local IP is set (comp. where oracle db is).

These are ours detailed instructions for Oracle, Apache, Linux:
www.toolsjx.com/index.php?option=com_content&view=article&id=53

Best regards,
Viljem

Hi,

I purchased TableJX couple of days back only because it clearly mentioned in joomla extension directory as it supports master detail page and easy connect with oracle. But I'm unable to connect with oracle and couldn't able to generate master detail report because of inadequate documentation related to them.

Please help us to fix this problem or kindly refund the product value.

Appreciated.

Regards,
Raja

The first time I also worked, I tasted since I bought it.

The Oracle database to which it connects on port 1525.

thanks for your response.

could you please provide me the details about oracle configuration if you use wamp server in windows?

appreciated

If you have XAMPP (Windows) and localhost Oracle DB:

1. Download Instant Client zip from Oracle site (e.g.
www.oracle.com/technology/software/tech/...antclient/index.html)
2. Extract content of entire zip folder into xampp\apache\bin
3. Uncomment extensions in php.ini file:

extension=php_oracle.dll
extension=php_oci8.dll

4. Restart Apache

*I have tried this with TableJX version 4 (you can download it in Customer area)
** I used Oracle 10g XE
***I did't try with Wamp, but I think it should be the same.