From owner-freebsd-database  Wed Jun  6  6:38: 5 2001
Delivered-To: freebsd-database@freebsd.org
Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com [216.136.174.113])
	by hub.freebsd.org (Postfix) with SMTP id A539037B401
	for <freebsd-database@freebsd.org>; Wed,  6 Jun 2001 06:38:01 -0700 (PDT)
	(envelope-from jraube@yahoo.com)
Received: from cg248553-b.adubn1.nj.home.com (HELO cg248553b) (24.12.112.209)
  by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Jun 2001 13:38:01 -0000
X-Apparently-From: <jraube@yahoo.com>
Message-ID: <001f01c0ee8d$ef1b0a20$d1700c18@adubn1.nj.home.com>
From: "Joe Raube" <jraube@yahoo.com>
To: "Peter Choe" <choepete@mindspring.com>
Cc: <freebsd-database@FreeBSD.ORG>
References: <3B1645CF.74C4D702@mindspring.com> <3B166A76.41234135@millions.ca> <3B167B64.CC50F3D8@mindspring.com> <3B168430.905295DA@millions.ca> <3B1E27D7.E7891DC9@mindspring.com>
Subject: Re: oracle8.1.7 on freebsd 4.3-stable
Date: Wed, 6 Jun 2001 09:38:12 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Sender: owner-freebsd-database@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-database.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo?subject=subscribe%20freebsd-database>
List-Unsubscribe: <mailto:majordomo?subject=unsubscribe%20freebsd-database>
X-Loop: FreeBSD.ORG

ps -eaf or ps -aux | grep oracle

should return something like so:

oracle   12385     1  0 May21 ?        00:00:06 ora_pmon_PROD2
oracle   12387     1  0 May21 ?        00:00:15 ora_dbw0_PROD2
oracle   12389     1  0 May21 ?        00:00:35 ora_lgwr_PROD2
oracle   12391     1  0 May21 ?        00:00:57 ora_ckpt_PROD2
oracle   12393     1  0 May21 ?        00:00:21 ora_smon_PROD2
oracle   12395     1  0 May21 ?        00:00:00 ora_reco_PROD2
oracle   12397     1  0 May21 ?        00:00:01 ora_snp0_PROD2
oracle   12399     1  0 May21 ?        00:00:02 ora_snp1_PROD2

PROD2 is the name of my Oracle instance or ORACLE_SID...

also, there used to be a bug in dbstart.

try

to startup:

sqlplus /nolog
connect / as sysdba;
startup

to shutdown:

sqlplus /nolog
connect / as sysdba;
shutdown immediate;

-Joe

----- Original Message -----=20
From: "Peter Choe" <choepete@mindspring.com>
To: <freebsd-database@FreeBSD.ORG>
Sent: Wednesday, June 06, 2001 8:53 AM
Subject: Re: oracle8.1.7 on freebsd 4.3-stable


> okay,
>=20
> i think that i got oracle 8i installed.  but i can't seem to connect =
to
> the database.  how can i tell if the database is running.  i tried to
> use sqlplus to log in but i get an error saying that ORACLE is not
> available.  i modified the necessary files and when i do dbstart it =
says
> ORCL is warm started.
>=20
> how can i test to see if it is actually running?  how do i initially =
set
> up users?  i can't find any information about this in the
> documentations.
>=20
> peter choe
>=20
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-database" in the body of the message
>=20


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message