Date: Wed, 6 Jun 2001 09:38:12 -0400 From: "Joe Raube" <jraube@yahoo.com> To: "Peter Choe" <choepete@mindspring.com> Cc: <freebsd-database@FreeBSD.ORG> Subject: Re: oracle8.1.7 on freebsd 4.3-stable Message-ID: <001f01c0ee8d$ef1b0a20$d1700c18@adubn1.nj.home.com> References: <3B1645CF.74C4D702@mindspring.com> <3B166A76.41234135@millions.ca> <3B167B64.CC50F3D8@mindspring.com> <3B168430.905295DA@millions.ca> <3B1E27D7.E7891DC9@mindspring.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?001f01c0ee8d$ef1b0a20$d1700c18>