Oracle Error
Hi All! Oracle 920 on SunOS (Cluster) A have a process that refresh data in the database . I shutdown database and then start it up, before running refresh. This is errors from my log file. After this happened all databases on this server were shutdown and they never failover to the second node on the cluster. I never seen this errors before, and in Metalink not much info about it. Any ideas? Connected. Database closed. Database dismounted. ORACLE instance shut down. ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 36 ORA-27301: OS 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 INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Error
This is was my fault, I should not take db down (restart) in cluster environment. Some cluster command needs to be executed first before restart database. This cluster command (take db temporary from cluster or pause cluster) needs to be run as root user. Maybe some one has an example of this command? Thanks. [EMAIL PROTECTED] 11/11/2003 9:34:26 AM You need to dig into the sun reference manuals and find out what an error 36 is in reference to semaphores. They are online I believe, somewhere at sun.com. .. How about that? Your exact error is duplicated in a 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 shutdown database and then start it up, before running refresh. This is errors from my log file. After this happened all databases on this server were shutdown and they never failover to the second node on the cluster. I never seen this errors before, and in Metalink not much info about it. Any ideas? Connected. Database closed. Database dismounted. ORACLE instance shut down. ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 36 ORA-27301: OS 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 INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Error
This is Sun Cluster 3.0. Process schedule through cron at 2:00 AM. greg [EMAIL PROTECTED] 11/11/2003 10:24:24 AM I'm going to assume this is Veritas Cluster Server. If so, why aren't you just doing this from the GUI? It's a little simpler that way. 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 restart database. This cluster command (take db temporary from cluster or pause cluster) needs to be run as root user. Maybe some one has an example of this command? Thanks. [EMAIL PROTECTED] 11/11/2003 9:34:26 AM You need to dig into the sun reference manuals and find out what an error 36 is in reference to semaphores. They are online I believe, somewhere at sun.com. .. How about that? Your exact error is duplicated in a 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 shutdown database and then start it up, before running refresh. This is errors from my log file. After this happened all databases on this server were shutdown and they never failover to the second node on the cluster. I never seen this errors before, and in Metalink not much info about it. Any ideas? Connected. Database closed. Database dismounted. ORACLE instance shut down. ORA-27157: OS post/wait facility removed ORA-27300: OS system dependent operation:semop failed with status: 36 ORA-27301: OS 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 INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 hosting services
Histograms 7.2
Hi All! I tried create histogram in Oracle 7.2 with the following statement: SQL ANALYZE TABLE nai_parameters COMPUTE STATISTICS FOR COLUMNs prompt SIZE 75; ANALYZE TABLE nai_parameters COMPUTE STATISTICS FOR COLUMNS prompt SIZE 75 * ERROR 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 Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
clustering Oracle9i db
Hi All! Need advice: We have two Windows 2000 servers with MSCS installed on it. Now I need to install Oracle9i. I read about Real Application cluster for 9i and Oracle fail safe: MSCS will take care about load balancing and failover do I need to instal RAC on top? 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 hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sqlplus connection
Hi All! I got warning Product user profile information not loaded!... after I run pupbld.sql script as system. Metalink recommend to drop PRODUCT_PRIVS and rerun pupbld.sql. I done it couple times , still not working. Any ideas? Oracle9i on SunOS. Should I connect system as sysdba? (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 hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
clustering Win2000 Oracle DB Server
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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle9i client install problem
Hi ALL! I tried install Oracle9i (9.2.0.1) client on Windows 2000 server (sp2). First screen (for installer) show up in grey color and after I press NEXT I get this: Can't find bundle for base name OUIVersion locale. This is first Oracle install on that box. Any ideas? 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 hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shared_pool error
Hi All! We get ora-04031 on Oracle816 on Unix. I'm aware that this is a bug about memory leak and we planing upgrade to Oracle 8173 to fix it. In a mean time I increased the shared_pool and shared_pool_reserved_size , and also ping some packages in. Now error sad that: enable to allocate 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 -- 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
off topic: OCP exam registration
Hi ALL! I just spoke with Prometric and they told me if I give them my OTN number they will give me discount for OCP exam. I'm the member of OTN , but I don't have any number. Someone know where I can get this number? 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 Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle 9i
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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
updated rows count
Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers , but this table can be updated not only with this big update. Other users can update rows too. I need to know updated rows number just for this big update. Thanks. update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty=850, atcapun=1, atglcode='19.99GB', atus1='05/20/2002' where ataltnbr='000'; update assethdr set atopsys= 'MS Windows 95 4.00',atdept='256MB', atcapcty= 850, atcapun=1, atglcode='19.99GB', atus1='05/17/2002' where ataltnbr=''; update assethdr set atopsys= 'MS Windows 2000 Pro 5.00',atdept='128MB', atcapcty= 400, atcapun=1, atglcode='6.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-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RECOVERY PROBLEM
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 Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RECOVERY PROBLEM
Hi All! I'm trying recovery TEST database from hot backup. I create database with a couple tables. Make couple log switches to generate redo log files (basically it's generate 3 redo log files: arch.log1_15.dbf , arch.log1_16.dbf, arch.log1_17.dbf). Then I run hot backup and backup all dbf files, redo log files, control files and arch redo log files. Shutdown database and delete all files. Then I restore all files from hot backup. Then I mount database and run: SVRMGR recover database using backup control file until cancel; ORA-00279: change 28494 generated at 03/06/02 13:19:24 needed for thread 1 ORA-00289: suggestion : /u00/app/oracle/admin/TEST/arch/arch.log1_18.dbf ORA-00280: change 28494 for thread 1 is in sequence #18 Specify log: {RET=suggested | filename | AUTO | CANCEL} cancel ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: '/ff01uc31/ora_c15d05/TEST/oradata/system01.dbf' It's looking for arch.log1_18.dbf files, which is, was not they're when I run my hot backup. Any ideas what I did wrong? Thanks a lot. Oracle 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-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03113
Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time back by Mladen: ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 It's 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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: ORA-03113
If I'll apply this command it's will take all oracle processes down for every instance in this box? Thanks. [EMAIL PROTECTED] 11/29 10:35 AM Why don't you want to want to take all the oracle processes down? I thought that's what you wanted 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 Message- From: Greg Faktor [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03113 Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time back by Mladen: ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 It's 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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
index size calculation
Hi All! I need to calculate/estimate index size for database. In 8.0.5 I used formula from Administrator Guide to calculate index size. Now this formula was removed because of it accuracy (see Metalink). Does some one has formula for 8i ? 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 Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).