Re: ORA-7320: smsget: shmat error when trying to attach sga

dsacks_at_getnet.com wrote in article <5u4sca$igl$1_at_news.getnet.com>...
> Now I have the /oracle directory nfs mounted to another machine and am
> trying to run sqlplus from there.

Huh? Oracle is client-server - I doubt that using NFS mounts of Oracle databases and software will work. And even if it works, NFS will slow it down a lot. :-)

> ERROR: ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> SVR4 Error: 2: No such file or directory

To run an Oracle client utility you need the following: - SQL*Net correct installed with a valid TNSNAMES.ORA (see $ORACLE_HOME/network/admin)
- PATH variable must include $ORACLE_HOME/bin - ORACLE_SID variable should contain the Oracle Database's SID

> Also, can someone explain to me how tnsping works?

It's checks if a listener is running for a SID (Oracle Instance) on a specific IP. But remember, it only checks the Oracle listener on the server and not the database (i.e. the db instance may be down). Check your TNSNAMES.ORA file - let's say you use the default orcl.world connection string:
# tnsping orcl
If it returns ok, it means that the Oracle listener is running and accepting client connections. If not, logon into oracle on the server and start the listener using 'lnsrctl start'.

> Support Linux!

Slak rules! :-)

regards,
Billy Received on Tue Sep 02 1997 - 00:00:00 CDT