[Tora-develop] Problems connecting to Oracle

Hi all,
I'm having problems connecting to Oracle databases using Tora 1.13.16 compiled
against Oracle 10.1.0.3.0 on SuSE 9.2.
Every time I try to create a new connection I get a message box saying
Unable to connect to the database
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
The puzzling part is that I'm able to connect to the database using SQL*Plus
just fine from the same workstation.
Any ideas?
Kind regards
Jacob

Thread view

Hi all,
I'm having problems connecting to Oracle databases using Tora 1.13.16 compiled
against Oracle 10.1.0.3.0 on SuSE 9.2.
Every time I try to create a new connection I get a message box saying
Unable to connect to the database
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
The puzzling part is that I'm able to connect to the database using SQL*Plus
just fine from the same workstation.
Any ideas?
Kind regards
Jacob

I'm having the same problem with Tora 1.3.16, Oracle 10.1.0.2.0, on Gentoo.
/mark
On Wednesday May 11 2005 11.06, Jacob Lauem=F8ller wrote:
> Hi all,
>
> I'm having problems connecting to Oracle databases using Tora 1.13.16
> compiled against Oracle 10.1.0.3.0 on SuSE 9.2.
>
> Every time I try to create a new connection I get a message box saying
>
> Unable to connect to the database
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
> The puzzling part is that I'm able to connect to the database using
> SQL*Plus just fine from the same workstation.
>
> Any ideas?
>
> Kind regards
> Jacob
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7393&alloc_id=3D16281&op=3Dclick
> _______________________________________________
> Tora-develop mailing list
> Tora-develop@...
> https://lists.sourceforge.net/lists/listinfo/tora-develop

On 13:03 Wed 11 May , Mark Tombs wrote:
>=20
> I'm having the same problem with Tora 1.3.16, Oracle 10.1.0.2.0, on Gento=
o.
> On Wednesday May 11 2005 11.06, Jacob Lauem=C3=B8ller wrote:
> > Unable to connect to the database
> > ORA-01034: ORACLE not available
> > ORA-27101: shared memory realm does not exist
> > Linux Error: 2: No such file or directory
This is exactly the problem I've had and reported since last month (I'm
on Gentoo as well). SQL*Plus, DBD::Oracle, and OJDBC work perfectly
fine. I know of one user on the same version of TOra on Gentoo that it
works for.
I'm on Oracle 9.2.0.4.
--=20
Don Seiler
don@...
Public Key: http://pgp.mit.edu:11371/pks/lookup?op=3Dget&search=3D0xFC87F041
Fingerprint: 0B56 50D5 E91E 4D4C 83B7 207C 76AC 5DA2 FC87 F041

On Wed, May 11, 2005 at 08:15:29AM -0500, Don Seiler wrote:
> On 13:03 Wed 11 May , Mark Tombs wrote:
> >
> > I'm having the same problem with Tora 1.3.16, Oracle 10.1.0.2.0, on Gentoo.
>
> > On Wednesday May 11 2005 11.06, Jacob Lauem??ller wrote:
> > > Unable to connect to the database
> > > ORA-01034: ORACLE not available
> > > ORA-27101: shared memory realm does not exist
> > > Linux Error: 2: No such file or directory
>
> This is exactly the problem I've had and reported since last month (I'm
> on Gentoo as well). SQL*Plus, DBD::Oracle, and OJDBC work perfectly
> fine. I know of one user on the same version of TOra on Gentoo that it
> works for.
>
> I'm on Oracle 9.2.0.4.
Such a bug is usualy caused due loosing ORACLE_HOME or TNS_ADMIN
environment variable. Please try to:
1. run Tora using strace
strace -o /tmp/tora.log -f -e trace=file tora
strace -o /tmp/tora.log -f -e trace=process tora
Then investigate logfile - Tora(oracle client library) should find,open,parse
sqlnet.ora(tnsnames.ora).
2. add getenv+printf somewhere into tora source code or run tora inside gdb.
You can also access processes env. through /proc
3. Look into sqlnet.log file
I saw simmilar problem, when connecting from apache+php into oracle.
One of aplications on different virtual server cleared env. variables.
libcntsh could not locate+parse sqlnet.ora and as the result default
connect string was used. As far as i remember default connect
string connects to database(SID) oracle1 using beq protocol.
If you find in strace log, that tora tries to execute program called oracle
whith parameter beq=yes, you definitely lost our oracle envoronment variables
somewhere.
"ORA-27101: shared memory realm does not exist" -> oracle could not find
specific segment of shared memory. You are connecting to the databaze
on different server, you have configured your oracle client wrong way.
Such a problem can be cased by:
1. Badly written shell wrapper for executing tora application.
2. Wrong permissions on oracle configuration files
3. Memory corruption, compiller error, ...
Ivan Brezina