From owner-freebsd-database Wed Jun 6 5:51:53 2001 Delivered-To: freebsd-database@freebsd.org Received: from smtp25.baruch.cuny.edu (smtp25.baruch.cuny.edu [150.210.155.201]) by hub.freebsd.org (Postfix) with SMTP id C89DE37B405 for ; Wed, 6 Jun 2001 05:51:50 -0700 (PDT) (envelope-from choepete@mindspring.com) Received: (qmail 17399 invoked by uid 0); 6 Jun 2001 11:26:39 -0000 Received: from unknown (HELO mindspring.com) (150.210.151.46) by smtp25.baruch.cuny.edu with SMTP; 6 Jun 2001 11:26:39 -0000 Message-ID: <3B1E27D7.E7891DC9@mindspring.com> Date: Wed, 06 Jun 2001 08:53:43 -0400 From: Peter Choe X-Mailer: Mozilla 4.75 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-database@FreeBSD.ORG Subject: Re: oracle8.1.7 on freebsd 4.3-stable References: <3B1645CF.74C4D702@mindspring.com> <3B166A76.41234135@millions.ca> <3B167B64.CC50F3D8@mindspring.com> <3B168430.905295DA@millions.ca> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG okay, 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. 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. peter choe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message 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 ; 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: Message-ID: <001f01c0ee8d$ef1b0a20$d1700c18@adubn1.nj.home.com> From: "Joe Raube" To: "Peter Choe" Cc: 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: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: 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" To: 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 From owner-freebsd-database Wed Jun 6 6:41:36 2001 Delivered-To: freebsd-database@freebsd.org Received: from scotth.emsphone.com (scotth.emsphone.com [199.67.51.179]) by hub.freebsd.org (Postfix) with ESMTP id B660C37B401 for ; Wed, 6 Jun 2001 06:41:33 -0700 (PDT) (envelope-from shildret@scotth.emsphone.com) Received: (from shildret@localhost) by scotth.emsphone.com (8.11.1/8.11.1) id f56Dgm916097; Wed, 6 Jun 2001 08:42:48 -0500 (CDT) (envelope-from shildret) Message-ID: X-Mailer: XFMail 1.4.0 on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <3B1E27D7.E7891DC9@mindspring.com> Date: Wed, 06 Jun 2001 08:42:48 -0500 (CDT) From: "Scott T. Hildreth" To: Peter Choe Subject: Re: oracle8.1.7 on freebsd 4.3-stable Cc: freebsd-database@FreeBSD.ORG Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG ps -aux | grep ORCL ..you should see something like : oracle 804 0.0 0.3 134556 6820 ? S May20 0:47 ora_pmon_onc oracle 808 0.0 0.3 134076 6604 ? S May20 0:42 ora_lgwr_onc oracle 810 0.0 0.3 134096 6848 ? S May20 3:21 ora_ckpt_onc oracle 812 0.0 0.9 134004 20436 ? S May20 0:08 ora_smon_onc oracle 814 0.0 0.4 133964 9864 ? S May20 0:00 ora_reco_onc oracle 816 0.0 0.3 134456 8216 ? S May20 0:02 ora_s000_onc oracle 818 0.0 0.4 134080 9056 ? S May20 0:01 ora_d000_onc oracle 820 0.0 0.3 134132 6372 ? S May20 0:02 ora_arc0_onc try connecting to the test DB : sqlplus scott/tiger. Oracle documentation is pretty good, you can get the html pages. Check out technet.oracle.com. Question : Did you use the installer, or did you tar the files from a Linux server? On 06-Jun-01 Peter Choe wrote: > okay, > > 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. > > 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. > > peter choe > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message ---------------------------------- E-Mail: Scott T. Hildreth Date: 06-Jun-01 Time: 08:36:49 ---------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Jun 7 6:33: 9 2001 Delivered-To: freebsd-database@freebsd.org Received: from smtp25.baruch.cuny.edu (smtp25.baruch.cuny.edu [150.210.155.201]) by hub.freebsd.org (Postfix) with SMTP id 6EB7237B403 for ; Thu, 7 Jun 2001 06:33:08 -0700 (PDT) (envelope-from choepete@mindspring.com) Received: (qmail 32425 invoked by uid 0); 7 Jun 2001 12:01:52 -0000 Received: from unknown (HELO mindspring.com) (150.210.151.46) by smtp25.baruch.cuny.edu with SMTP; 7 Jun 2001 12:01:52 -0000 Message-ID: <3B1F81A2.21DA372C@mindspring.com> Date: Thu, 07 Jun 2001 09:29:06 -0400 From: Peter Choe X-Mailer: Mozilla 4.75 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-database@FreeBSD.ORG Subject: oracle8.0.5.1 enterprise edition Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG anyone know where i can get oracle8.0.5.1 enterprise editon tar file? peter choe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message