Re: Oracle Error

2003-11-11 Thread Greg Faktor
. You can see the commands being executed via the log viewer tearoff on the menu. Jared On Tue, 2003-11-11 at 07:04, Greg Faktor wrote: > This is was my fault, I should not take db down (restart) in cluster > environment. Some cluster command needs to be executed first before > resta

Re: Oracle Error

2003-11-11 Thread Greg Faktor
post on MetaLink. Did you check there? Sounds like someone was playing around with ipcrm whilst Oracle was up and running. Jared On Tue, 2003-11-11 at 06:09, Greg Faktor wrote: > Hi All! > > Oracle 920 on SunOS (Cluster) > A have a process that refresh data in the database . I shut

Oracle Error

2003-11-11 Thread Greg Faktor
failure message: Identifier removed ORA-27302: failure occurred at: sskgpwwait1 Connected to an idle instance. truncate table xx * ERROR at line 1: ORA-01034: ORACLE not available Thanks. Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Greg Faktor

Histograms 7.2

2003-07-24 Thread Greg Faktor
ROR at line 1: ORA-00933: SQL command not properly ended Is it different syntax in 7.2? Thanks. Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

clustering Oracle9i db

2003-01-07 Thread Greg Faktor
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

sqlplus connection

2003-01-02 Thread Greg Faktor
? (Done it both way, not working). Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

clustering Win2000 Oracle DB Server

2002-11-18 Thread Greg Faktor
Hi All! Could some one pointed me to the good source of info about clustering Win2000 Oracle DB Server? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Oracle9i client install problem

2002-10-08 Thread Greg Faktor
s? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

shared_pool error

2002-09-20 Thread Greg Faktor
4096 bytes of shared memory ('shared pool","BEGIN DBMS_OUTPUT.ENABLE; END;". Oracle can't allocate memory for the object which is already in memory? Maybe I missing something.??? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

off topic: OCP exam registration

2002-09-05 Thread Greg Faktor
FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from th

oracle 9i

2002-07-25 Thread Greg Faktor
Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: updated rows count ― Thanks.

2002-05-30 Thread Greg Faktor
Thanks everybody for advice. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

updated rows count

2002-05-30 Thread Greg Faktor
.43GB', atus1='05/20/2002' where ataltnbr='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: RECOVERY PROBLEM

2002-03-07 Thread Greg Faktor
Thanks All for help! I did not switch logfile after end backup statment. Now everything working. Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RECOVERY PROBLEM

2002-03-06 Thread Greg Faktor
racle 8.1.5 on Digital Unix Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Publi

Re: RE: ORA-03113

2001-11-29 Thread Greg Faktor
to accomplish with shutdown immediate? Go ahead and issue Mladen's command and restart the database. It's the only way you can bring it down if you can't connect with svrmgrl or sqlplus. Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 > -Original

ORA-03113

2001-11-29 Thread Greg Faktor
will take all oracle processes and listeners down which I don't want to do. I'm on Oracle 8.1.6. Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

index size calculation

2001-11-09 Thread Greg Faktor
FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE