Recently I moved from Fedora 13 to Ubuntu 10.04 on my work laptop. So, I faced again with problem to setup Oracle PHP interface. Oracle provides RPMs only and not DEBs. So, to install the client RPMs should be converted to the DEBs. It can be done easily using utility alien: sudo alien oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm sudo alien oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm sudo alien oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm They can be installed then […]
Add history and auto-complete to the SQL*Plus
I was very surprised how pure the Oracle’s command line utility SQL*Plus. Comparing with mysql it lack history, completion and doesn’t allow even edit query. To fix that the utility rlwrap can be used. I installed it via yum under Fedora 11 and run like that: rlwrap sqlplus db_user@db To have auto-complete feature you should find file SQL.dict somewhere (drop the comment, please, if you […]
Oracle date format and Perl
Oracle has its own date format – DD-MM-YY (24-sep-09). So, to insert a value into Oracle date field you should somehow convert date from your format. Sure it can be done using some date/time module or your own function. But there are two simpler ways – set desire date/time format for session or use Oracle date conversion function. To set specific date/time format for the […]
Connect to Oracle DB from Perl script
After successful installation of DBD::Oracle it’s time to use it. The connection string is the same as for he rest DB: my $dbi = DBI->connect(“dbi:Oracle:$db_name:$db_host:$db_port”, $db_user, $db_pass); As result of running code above I got following error: Couldn’t connect to database db_name: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) After googling I found that the problem was that. I tried to […]
Installing DBD::Oracle under Fedora 11
Recently I got a task which needs to communicate with database Oracle from Perl. Perl has an excellent database abstraction interface DBI. But for specific database it needs a driver – DBD module. To install DBD::Oracle you have to perform following simple steps: Download and install oracle-instantclient11.2-basic and oracle-instantclient11.2-devel RPMs from Instant Client Downloads for Linux x86 page. Export ORACLE_HOME: export ORACLE_HOME=/usr/lib/oracle/11.2/client/ Install DBD::Oracle using […]