Welcome, Guest
Please Login or Register.    Lost Password?

I can´t connect with a oracle db
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottomPage: 1234
TOPIC: I can´t connect with a oracle db
#271
Re: I can´t connect with a oracle db 6 Months, 4 Weeks ago Karma: 0
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??
giorgiosks
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#272
Re: I can´t connect with a oracle db 6 Months, 4 Weeks ago Karma: 1
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_con...ew=article&id=53

Best regards,
Viljem
viljem
Admin
Posts: 153
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#273
Re: I can´t connect with a oracle db 6 Months, 4 Weeks ago Karma: 0
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
rajnvr
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#274
Re: I can´t connect with a oracle db 6 Months, 4 Weeks ago Karma: 0
The first time I also worked, I tasted since I bought it.

The Oracle database to which it connects on port 1525.
giorgiosks
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#275
Re: I can´t connect with a oracle db 6 Months, 4 Weeks ago Karma: 0
thanks for your response.

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

appreciated
rajnvr
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#276
Re: I can´t connect with a oracle db 6 Months, 4 Weeks ago Karma: 1
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.
viljem
Admin
Posts: 153
graph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/12 14:00 By viljem.
The administrator has disabled public write access.
 
Go to topPage: 1234
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting