Urgent!!! ora-01115 ora-01110 ora-27069
OS:WIN2K DB:Oracle 9.0.1 (ArchiveLog Production) I'm facing those error with one my datafile. The datafile is 4GB. The datafile is in autoextend mode, so I don't aware about the datafile increasing, until suddenly database down:( Unfortunetly, I've no backup at all also. The person who responsible to do offline backup never backup the database. Some archive log is missing also:( Please help me, to solve the problem. Any comment or suggestion I would appreciate. thank in advance, ~holly~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lynxidajax 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).
Urgent!!! ora-01115 ora-01110 ora-27069
OS:WIN2K DB:Oracle 9.0.1 (ArchiveLog Production) I'm facing those error with one my datafile. The datafile is 4GB. The datafile is in autoextend mode, so I don't aware about the datafile increasing, until suddenly database down:( Unfortunetly, I've no backup at all also. The person who responsible to do offline backup never backup the database. Some archive log is missing also:( Please help me, to solve the problem. Any comment or suggestion I would appreciate. thank in advance, ~holly~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lynxidajax 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: /etc/system on Sun Solaris 8 for 8i and 9i
When I start the 9i2 instance, the 8i3 instance could only establish 2 max. Unfortunetly, I forgot to log the error message. Yesterday, when I checked the error message on Oracle Doc, that sayed to be change the /etc/system. Please advice.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 12, 2002 11:48 AM How do you know it ran out of resource? What's the error message and when does this appear? During startup, during heavy use or when it's just idle? ltiu On Sunday 11 August 2002 20:08, you wrote: Dear All, I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 64-bit on the same machine. But unfortunetly the old instance (8.1.7) is run out resource. I must set the /etc/system to higher value. But it is still the same. Could you please someone give me advice about it, and what is the impact for my Sun Machine if I increase the /etc/system value?? Below is my /etc/system. thanks Ahmadsyah.Alghozi.Nugroho ps: I'm feel sorry for my english.. :( === /etc/system === set hme:hme_adv_autoneg_cap=0 set hme:hme_adv_100fdx_cap=1 set hme:hme_adv_100hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set ge:ge_adv_1000autoneg_cap=0 set ge:ge_adv_1000fdx_cap=1 set ge:ge_adv_1000hdx_cap=0 forceload: drv/vxdmp forceload: drv/vxio forceload: drv/vxspec forceload: sys/semsys set semsys:seminfo_semmsl = 500 set semsys:seminfo_semmap = 10 set semsys:seminfo_semmni = 1200 set semsys:seminfo_semmns = 5000 set semsys:seminfo_semmnu = 30 set semsys:seminfo_semopm = 100 set semsys:seminfo_semume = 10 set semsys:seminfo_semusz = 96 set semsys:seminfo_semvmx = 32767 set semsys:seminfo_semaem = 16384 forceload: sys/shmsys set shmsys:shminfo_shmmax = 4294967295 set shmsys:shminfo_shmmni = 800 set shmsys:shminfo_shmmin = 1 set shmsys:shminfo_shmseg = 400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: 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).
/etc/system on Sun Solaris 8 for 8i and 9i
Dear All, I've Sun machine that run Oracle 8.1.7. Recently I installed new oracle 9i2 64-bit on the same machine. But unfortunetly the old instance (8.1.7) is run out resource. I must set the /etc/system to higher value. But it is still the same. Could you please someone give me advice about it, and what is the impact for my Sun Machine if I increase the /etc/system value?? Below is my /etc/system. thanks Ahmadsyah.Alghozi.Nugroho ps: I'm feel sorry for my english.. :( === /etc/system === set hme:hme_adv_autoneg_cap=0 set hme:hme_adv_100fdx_cap=1 set hme:hme_adv_100hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set hme:hme_adv_10hdx_cap=0 set ge:ge_adv_1000autoneg_cap=0 set ge:ge_adv_1000fdx_cap=1 set ge:ge_adv_1000hdx_cap=0 forceload: drv/vxdmp forceload: drv/vxio forceload: drv/vxspec forceload: sys/semsys set semsys:seminfo_semmsl = 500 set semsys:seminfo_semmap = 10 set semsys:seminfo_semmni = 1200 set semsys:seminfo_semmns = 5000 set semsys:seminfo_semmnu = 30 set semsys:seminfo_semopm = 100 set semsys:seminfo_semume = 10 set semsys:seminfo_semusz = 96 set semsys:seminfo_semvmx = 32767 set semsys:seminfo_semaem = 16384 forceload: sys/shmsys set shmsys:shminfo_shmmax = 4294967295 set shmsys:shminfo_shmmni = 800 set shmsys:shminfo_shmmin = 1 set shmsys:shminfo_shmseg = 400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Querying all_tab_columns using stored procedure
Title: RE: recording SQLPlus activity Dear All,I'm created stopre procedure like below: CREATE OR REPLACE PROCEDURE X1990.test(ptable varchar2) IS CURSOR c1 IS SELECT column_name || '||''' || ',' || '''||' col FROM all_tab_columns WHERE owner = 'X2002' AND table_name LIKE UPPER (ptable) ORDER BY column_id; c1rec c1%ROWTYPE;BEGIN OPEN c1; LOOP FETCH c1 INTO c1rec; EXIT WHEN c1%NOTFOUND; dbms_output.put_line(c1rec.col); END LOOP; CLOSE c1;END; The above procedurereturn blank... But when I'm querying the all_tab_columns directly from sqlplus it's returned some values. for your information, I'm accessing the store procedure from another schema. How to solve this problem??? regards, Ahmadsyah A.N.
Partition Exchange
Dear all, What's the meaning of Partition Exchange? tia, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Create user_exit under unix
Dear Gurus, I use : - Oracle Server 8.1.6.0 - Oracle Pro*FORTRAN 1.8.52.0.0 - Oracle Developer 6i release 2 Under SUN Solaris 2.8. Could you please tell how to create USER EXIT on Oracle Developer 6i using those tools above? I'll very apreciate for every reply. regards, Ahmadsyah A.N. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Cronjob
Dear Tom, Would you send me example of the script. Because I'm new with VMS environment. thanks in advance, Ahmadsyah - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 11:43 PM Ahmadsyah, If I remember correctly (my Vax is a couple of years old), we set up two jobs to accomplish this. One job ran every day. All this job did was to start the real job schedule job. the job schedule job interrogated what day of the week it was and ran other jobs. For example, if today is Thursday, it would start all jobs that were supposed to run on a thursday. the final thing that this job did was to re-schedule the first job for tommorrow at the same time. Kind of a circular job scheduling process. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 25, 2002 10:34 AM To: Multiple recipients of list ORACLE-L I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = tomorrow+06:00 - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to submit every week and month or every saturday. Could I do it on our vax machine? regards, Ahmadsyah Alghozi Nugroho Certified Oracle DBA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 7:38 PM 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: 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:
Re: Cronjob
I have the same problem but with our vax/vms machine.. could I submit a job queue on every week or maybe every month... $Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log - _$/After = tomorrow+06:00 - _$sys$geology:[diga.digu]dige.com I usually submit que every day.. but I want to submit every week and month or every saturday. Could I do it on our vax machine? regards, Ahmadsyah Alghozi Nugroho Certified Oracle DBA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 7:38 PM 0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Samir Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6028 EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: 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 Pro-Fortran, where I could find it?
Dear All, Where I could find the Oracle Pro-Fortran? Oracle dealer in my country said I could find it in Oracle Enterprise. But when I'll try to find it from Oracle 8i and Oracle 9i enterprise, I could find no-pro-fortran on it. Thanks. Ahmadsyah Alghozi Nugroho(Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Migrate INGRES 6.4 to Oracle 8.1.6
Dear all, Are there any tools that can help me to migrate INGRES 6.4 to Oracle 8.1.6? Best Regards, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).