Re: using sqlplus nolog

From: No Spam <nospam_at_home.com>
Date: Fri, 9 Jan 2004 17:38:59 -0000
Message-ID: <fHBLb.442$uj3.203@news-binary.blueyonder.co.uk>

ps ef|grep ora gave:

oracle    1769  1759  0 16:04 ?        00:00:01 /usr/bin/gnome-session
oracle    1812  1769  0 16:04 ?        00:00:00 /usr/bin/ssh-agent

/etc/X11/xini
t/Xclients

oracle    1817     1  0 16:04 ?        00:00:01 /usr/libexec/gconfd-2 11
oracle    1819     1  0 16:04 ?        00:00:00

/usr/libexec/bonobo-activation-s
erver --ac-activate --ior-output-fd=16
oracle 1821 1 0 16:04 ? 00:00:00 gnome-settings-daemon --oaf-acti
vate-iid=OAFIID:GNOME_SettingsDaemon --oaf-ior-fd=14

oracle    1826  1566  0 16:04 ?        00:00:00 [fam]
oracle    1831     1  0 16:04 ?        00:00:00 xscreensaver -nosplash
oracle    1834     1  0 16:04 ?        00:00:03

/usr/bin/metacity --sm-client-id
=default1
oracle 1838 1 0 16:04 ? 00:00:08 gnome-panel --sm-client-id defau
lt2
oracle 1840 1 0 16:04 ? 00:00:03 nautilus --no-default-window --s
m-client-id default3
oracle 1842 1 0 16:04 ? 00:00:00 magicdev --sm-client-id default4
oracle 1844 1 0 16:04 ? 00:00:00 eggcups --sm-client-id default6
oracle 1846 1 0 16:04 ? 00:00:00 pam-panel-icon --sm-client-id de
fault0
oracle 1848 1 0 16:04 ? 00:00:11 /usr/bin/python /usr/bin/rhn-app
let-gui --sm-client-id default5
oracle 1856 1 0 16:04 ? 00:00:00 /usr/libexec/notification-area-a
pplet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-i or-f
d=20

oracle    1858     1  0 16:05 ?        00:00:05 gnome-terminal
oracle    1859  1858  0 16:05 ?        00:00:00 [gnome-pty-helpe]
oracle    1860  1858  0 16:05 pts/0    00:00:00 bash
oracle    1950     1  0 16:18 ?        00:00:00 ora_pmon_akan
oracle    1952     1  0 16:18 ?        00:00:00 ora_dbw0_akan
oracle    1954     1  0 16:18 ?        00:00:00 ora_lgwr_akan
oracle    1956     1  0 16:18 ?        00:00:00 ora_ckpt_akan
oracle    1958     1  0 16:18 ?        00:00:01 ora_smon_akan
oracle    1960     1  0 16:18 ?        00:00:00 ora_reco_akan
oracle    1962     1  0 16:18 ?        00:00:00 ora_cjq0_akan
oracle    1964     1  0 16:18 ?        00:00:15 ora_qmn0_akan
oracle    1966     1  0 16:18 ?        00:00:00 ora_s000_akan
oracle    1968     1  0 16:18 ?        00:00:00 ora_d000_akan
oracle    2006  1860  6 17:06 pts/0    00:00:00 ps -ef
oracle    2007  1860  0 17:06 pts/0    00:00:00 grep ora

These ar ethe error msgs I am getting with sqlplus:

[oracle_at_localhost oracle]$ sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 9 17:18:40 2004

Enter user-name: oracle
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory

Enter user-name: akan_at_domain
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name

Enter user-name: SYS
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1073667754.647261_at_yasure...
> No Spam wrote:
>
> > Hi
> >
> > On installing oracle 9i standard edition on redhat linux 9, it installed
the
> > dbca, the database, and the client.
> >
> > My problem is I do not have an internet connection, and I mainly would
like
> > to use sqlplus to learn sql. My main username to logon on to oracle is
the
> > user name for oracle which I use to logon to linux for oracle purposes
the
> > name I use is oracle but it keeps saying no such realm in shared
segment. I
> > am only able to use sql with the command
> > sqlplus /nolog I assume this creates a relational database with no file
> > saved?
> >
> > I have a password for SYS
> > and a password for SYSTEM
> > and a global variable name
> >
> > ..._at_domain
> >
> >
> > and a SID: ...
> >
> > I apologise if this seems a very silly but what do I put down for
username
> > at the username prompt when I type in sqlplus. I normally use the main
user
> > which is oracle, but I get the no realm segment error as mentioned
earlier.
> >
> > I also do not have an internet connection with this comp so I am unable
to
> > get a network service, I am told I could use something called a loop
back
> > adapter with a physical address of 127.0.0.1 which would make the comp
think
> > I am connected to the internet so I could have the client and server at
the
> > same comp, I have been unable to find such software, would you know how
I
> > could do this?
>
> From what I can glean from your email you may or may not have a
> database but you most likely did not read and follow the installation
> instructions. It is almost impossible to help you since you didn't post
> the actual error message but my guess is one of the following that you
> didn't:
>
> 1. set the kernel parameters
> 2. set ORACLE_SID
> 3. set ORACLE_HOME
> 4. start the listener and database
>
> Start with ps -ef | grep ora
>
> and see if anything Oracle is actually running. Then report back with
> actual error messages.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Fri Jan 09 2004 - 11:38:59 CST