Re: sqlnet problem? not sure.

From: Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl>
Date: Wed, 28 Aug 2002 22:22:18 +0200
Message-ID: <d4cqmu4nh065asuqsc0d3248ssec1o9c69@4ax.com>

On Wed, 28 Aug 2002 21:29:06 +0200, "nexus" <nexus1001_at_free.fr> wrote:

>Hello all,
>
>Here's my problem:
>
>2 db instances on 1 SOlaris machine,
>ORACLE_SID has been exported to the db I wish to connect to.
>listener.ora and tnsnames and sqlnet.ora are in /var/opt/oracle (as symlinks
>to $ORACLE_BASE/network/admin/...)
>
>when typing the full login (i.e: user/login_at_dbsid) I get in with both DBs
>when simply typing sqlplus, I get a prompt but I can log in (not even with
>system/manager) I get a ORACLE not available message.
>
>Can someone help?
>

Incorrect ownership of files
Incorrect protection
Oracle not running using the correct user The Oracle executable doesn't have the suid bit set. To mention only a *few* causes.

Nothing to do with sqlnet, and you also don't need the symlinks.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 28 2002 - 15:22:18 CDT