Planning Test Backup/Recovery
Hi all : Does anyone have a planning for test backup and recovery ? I have the scripts and i am doing the backup and now we need to test it in production environment. I have tested it at another environment and got sucess. but at production ... it need to be very very careful ... Any sugestion ? Regards Eriovaldo _ O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: Planning Test Backup/Recovery - Tom
Tom : I am thinking something like that .. I have already did the test at another machine ... It worked right... but the instance was diferente ... So, in your opinion i need to create a instance, in the production machine, with the same parameters of production and apply the test there, righ ... But , how can i to create a instance with the same parameters ? Should i use the init.ora of the production instance ? Thanks. Eriovaldo From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Planning Test Backup/Recovery Date: Mon, 04 Mar 2002 06:18:22 -0800 Eriovaldo, If I were you, I would create a small test database on the production machine, and perform backup/restore of that test database to be sure that everything is working before I would try it on a production database. Once you are convinced that everything works, schedule a down time where you can test backup/restore of the production database. I would also keep the test db on the production box, and as a regular monthly schedule, test backup and restore of that database - just to make sure that it continues to work. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 04, 2002 7:48 AM To: Multiple recipients of list ORACLE-L There should not be any problem to test the backup. However we are testing the restores to another machine, not on the production machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Eca Eca [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 04, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Subject:Planning Test Backup/Recovery Hi all : Does anyone have a planning for test backup and recovery ? I have the scripts and i am doing the backup and now we need to test it in production environment. I have tested it at another environment and got sucess. but at production ... it need to be very very careful ... Any sugestion ? Regards Eriovaldo _ O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC? 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: Mercadante, Thomas F 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). _ Converse com amigos on-line, experimente o MSN Messenger: http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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
Install 8.1.7 SE over EE
Hi Friends I have a instance 8.1.7 EE and i need to install de 8.1.7 Standard Edititon. How can i do it ? It is my production environment, so , I can't stop for long time ... It need to be fast ... I need to keep the name of the database, because there are a lot of scripts using the name. Regards Eriovaldo _ Associe-se ao maior serviço de e-mail do mundo através do MSN Hotmail. http://www.hotmail.com/br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: smtp via PL/SQL
( 4000 );
usrname VARCHAR2( 30 );
usraddr VARCHAR2( 100 );
CURSOR get_user IS SELECT user_fname, user_email
FROM user_mailids WHERE user_alias = lower( user );
CURSOR get_list ( v_tempstr IN VARCHAR2 ) IS
SELECT user_fname, user_email
FROM user_mailids
WHERE v_tempstr LIKE '%' || user_alias || '%';
addrlist addresslist_tab;
addrcnt BINARY_INTEGER:= 0;
BEGIN
OPEN get_user;
FETCH get_user INTO usrname, usraddr;
IF get_user%NOTFOUND THEN
CLOSE get_user;
RAISE_APPLICATION_ERROR( -20015, 'User not entered in USER_MAILIDS' );
END IF;
CLOSE get_user;
conn:= utl_smtp.open_connection( 'smtp-gw.widesoft.com.br', 25 );
utl_smtp.helo( conn, 'smtp-gw.widesoft.com.br' );
utl_smtp.mail( conn, usraddr );
FOR listrec IN get_list( to_list ) LOOP
utl_smtp.rcpt( conn, listrec.user_email );
addrcnt:= addrcnt + 1;
addrlist( addrcnt ):= 'To: ' || listrec.user_fname ||
'' || listrec.user_email || '' || crlf;
END LOOP;
IF addrcnt = 0 THEN
RAISE_APPLICATION_ERROR( -20016, 'No To: list generated' );
END IF;
FOR listrec IN get_list( cc_list ) LOOP
utl_smtp.rcpt( conn, 'cc:' || listrec.user_email );
addrcnt:= addrcnt + 1;
addrlist( addrcnt ):= 'Cc: ' || listrec.user_fname ||
'' || listrec.user_email || '' || crlf;
END LOOP;
mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From: ' || usrname || ' ' || usraddr || '' || crlf ||
'Subject: ' || subj || crlf;
FOR i IN 1 .. addrcnt LOOP
mesg:= mesg || addrlist( i );
END LOOP;
mesg:= mesg || '' || crlf || body;
utl_smtp.data( conn, mesg );
utl_smtp.quit( conn );
END;
PROCEDURE mailgroups( to_list IN VARCHAR2, cc_list IN VARCHAR2,
subj IN VARCHAR2, body IN VARCHAR2 ) IS
conn UTL_SMTP.CONNECTION;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2( 4000 );
usrname VARCHAR2( 30 );
usraddr VARCHAR2( 100 );
CURSOR get_user IS SELECT user_fname, user_email
FROM user_mailids WHERE user_alias = lower( user );
CURSOR get_list ( v_tempstr IN VARCHAR2 ) IS
SELECT user_fname, user_email
FROM user_mailids
WHERE v_tempstr LIKE '%' || user_group || '%';
addrlist addresslist_tab;
addrcnt BINARY_INTEGER:= 0;
BEGIN
OPEN get_user;
FETCH get_user INTO usrname, usraddr;
IF get_user%NOTFOUND THEN
CLOSE get_user;
RAISE_APPLICATION_ERROR( -20015, 'User not entered in USER_MAILIDS' );
END IF;
CLOSE get_user;
conn:= utl_smtp.open_connection( 'smtp-gw.widesoft.com.br', 25 );
utl_smtp.helo( conn, 'smtp-gw.widesoft.com.br' );
utl_smtp.mail( conn, usraddr );
FOR listrec IN get_list( to_list ) LOOP
utl_smtp.rcpt( conn, listrec.user_email );
addrcnt:= addrcnt + 1;
addrlist( addrcnt ):= 'To: ' || listrec.user_fname ||
'' || listrec.user_email || '' || crlf;
END LOOP;
IF addrcnt = 0 THEN
RAISE_APPLICATION_ERROR( -20016, 'No To: list generated' );
END IF;
FOR listrec IN get_list( cc_list ) LOOP
utl_smtp.rcpt( conn, 'cc:' || listrec.user_email );
addrcnt:= addrcnt + 1;
addrlist( addrcnt ):= 'Cc: ' || listrec.user_fname ||
'' || listrec.user_email || '' || crlf;
END LOOP;
mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From: ' || usrname || ' ' || usraddr || '' || crlf ||
'Subject: ' || subj || crlf;
FOR i IN 1 .. addrcnt LOOP
mesg:= mesg || addrlist( i );
END LOOP;
mesg:= mesg || '' || crlf || body;
utl_smtp.data( conn, mesg );
utl_smtp.quit( conn );
END;
END;
/
- - - - - - - - - - - - - - - - Code ends here - - - - - - - - - - - - - -
- -
Example Usage
-
testit.pls
- - - - - - - - - - - - - - - - Code begins here - - - - - - - - - - - - - -
- -
INSERT INTO user_mailids VALUES( 'eca', 'eca', '[EMAIL PROTECTED]',
'group1' );
INSERT INTO user_mailids VALUES( 'Alexandre', 'Alexandre',
'[EMAIL PROTECTED]', 'group1' );
INSERT INTO user_mailids VALUES( 'Luiz Ayres', 'Luiz Ayres',
'[EMAIL PROTECTED]', 'group1' );
INSERT INTO user_mailids VALUES( 'Belkis', 'Belkis',
'[EMAIL PROTECTED]', 'group1' );
INSERT INTO user_mailids VALUES( 'Fabiano', 'Fabiano',
'[EMAIL PROTECTED]', 'group1' );
INSERT INTO user_mailids VALUES( 'Missao', 'Missao',
'[EMAIL PROTECTED]', 'group1' );
select
substr(USER_ALIAS,1,15),
substr(USER_FNAME,1,15),
substr(USER_EMAIL,1,30),
substr(USER_GROUP,1,15)
from user_mailids
/
BEGIN
mailit.mailusers('user1','user2','ALERT: Test being conducted',
'Notice to users: This is a test' );
mailit.mailgroups('group1,group2', NULL,'WARNING: Test being conducted',
'Notice to groups: This is a test' );
END;
/
BEGIN
mailit.mailusers('eca','eca',
'ALERT: Teste de e-mail enviado por package do Oracle',
'Pessoal
Oracle Internet Directory
Hi Friend : Does anyone use Oracle Internet Directory ? How does it work ? What is the password and the user that need I to use to connect with the utility oidmon ? Why is it used ? For to build hierarquical structure ? Just it ? Regards Eriovaldo _ O MSN Photos é o jeito mais fácil de compartilhar e imprimir as suas fotos: http://photos.msn.com.br/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: ORA-04031
Ok. I have solved this problem. I put the parameter large_pool_size with a large value (200mb) and now it is running right... I know that this value is too large, but it solved my problem... We are looking for it ... Regards ... rom: BELOV [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ORA-04031 Date: Tue, 25 Sep 2001 00:30:21 -0800 need to see a trace file for more info... -Original Message- From: Eca Eca [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:35 PM To: Multiple recipients of list ORACLE-L Subject: ORA-04031 Friends : I am using 9i and receiving : ORA-04031: unable to allocate 8704 bytes of shared memory (large pool,unknown object,hash-join subh,kllcqas:kllsltba) I have 2gb of memory In init.ora i have large values for pool parameters ... What is happening ? Any idea ? The db_cache_size is around 932 mb shared_pool is around 369 mb Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: BELOV 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). _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: Undo x Rollback Segments in 9i
Humm, it will take a long time ... :) and my database is installed and almost ready to start ... I have to take decision fast ... But all kinds of help are good ... Regards Eriovaldo From: JOE TESTA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Undo x Rollback Segments in 9i Date: Mon, 24 Sep 2001 06:00:22 -0800 I'm testing it for potential demo at ioug 2002, since i've got a abstract in for undo management and flashback query. does that help any? joe [EMAIL PROTECTED] 09/24/01 09:15AM Thursday, September 20, 2001, 9:40:17 PM, you wrote: EE does anyone use it or know how to use Automatic Undo ? EE What is the best option : I don't know which is best. I did recently notice that the default database you get when you install Oracle9i uses automatic undo. I also discovered that if you want to use the new flashback query features, that you must be using automatic undo management. I like the simplified approach of just create a bunch of undo space and let Oracle worry about it. But it is a new feature, it may take some time to work the kinks out, and I'm not sure I'd rush to convert all my databases to it. By the way, is anyone doing anything with flashback query yet? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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). _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: To Users of 9i -- to Rich Jesse
Hi Rich : We installed the 9i version and had problem with large poll size. At first it was with 10mb, after around 50mb and the errors was ocurring yet, then we put around 200 mb and the error stopped. Is it normal ? Regards ... Eriovaldo S.Paulo - (Brazil) From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: To Users of 9i Date: Tue, 25 Sep 2001 11:45:42 -0800 We're using 9i to implement LDAP (OID -- I forget what version). The kicker that got me was the use of a global shared init.ora. Not a bug, but something new whose actions supercede the traditional way. Of course, if I had the time to read the docs... :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, September 25, 2001 09:45 To: Multiple recipients of list ORACLE-L [excerpted for brevity] Anyone else have anything to contribute to this list of 9i problems? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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-04031
Friends : I am using 9i and receiving : ORA-04031: unable to allocate 8704 bytes of shared memory (large pool,unknown object,hash-join subh,kllcqas:kllsltba) I have 2gb of memory In init.ora i have large values for pool parameters ... What is happening ? Any idea ? The db_cache_size is around 932 mb shared_pool is around 369 mb Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
To Users of 9i
Friends : Does anyone use the 9i database ? Are you happy using it ? Is it running ok ? What kind of problem does it have ? Bugs ? What do you think putting it in production environment ? Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Undo x Rollback Segments in 9i
Friends : I tried to create a rollback segment in 9i and its said to me : CREATE PUBLIC ROLLBACK SEGMENT RBS01 TABLESPACE RBS * ERROR at line 1: ORA-30019: Illegal rollback Segment operation in Automatic Undo mode Well, i realized that Oracle created for me some resource like rollback segment automaticaly. My doubt : If i will put the instance in Manual Undo I can to create the rollback segment, but i will lost the resource automatic. does anyone use it or know how to use Automatic Undo ? What is the best option : Rollback or Undo Automatic. I know rollback but i don't know Undo Automatic Regards Eriovaldo _ Chegou o novo MSN Explorer. Instale já. É gratuito! http://explorer.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Installing Oracle 9i
Friends : I am installing the database Oracle 9i. And it have suggested a parameter value 100mb for redo log file. I am confused with this value, i think it is too big. The blocksize is 8192 Connections simultaneous is 100 Where am I doing any mistake ? Eriovaldo [EMAIL PROTECTED] _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Executing script shell
Friends : How can i do for connect in the database by unix, when the operational system received a email ? For example : I send a email to the address (or alias) when unix receives this email i would like to run a script ... I don't know how to write a shell script for to do it ... Hugs Eriovaldo _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: read values from REF CURSOR
Friend : I think you can use it : CREATE OR REPLACE PACKAGE cv_types AS TYPE DeptCurTyp is REF CURSOR RETURN dept%ROWTYPE; END cv_types; CREATE OR REPLACE PROCEDURE dept_rpt (dept_cv IN OUT cv_types.DeptCurTyp) AS BEGIN OPEN dept_cv FOR SELECT * FROM DEPT; END; VARIABLE odcv REFCURSOR EXECUTE dept_rpt(:odcv) PRINT odcv VARIABLE pcv REFCURSOR EXECUTE dept_rpt(:pcv) PRINT pcv Eriovaldo [EMAIL PROTECTED] From: Don Dealy II [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: read values from REF CURSOR Date: Fri, 03 Aug 2001 22:35:26 -0800 One of our web developers tells me that the values he is getting back from a REF CURSOR (dynamic SQL in 8.1.7 stored proc) is not returning the expected values. Naturally, all the blame is placed on the database and the stupid Oracle stored procedure, because it all works just fine in $QL $erver 2000. Is there any way that I can debug the stored proc and determine what values are being returned through the REF CURSOR? I want to know what is being sent out from Oracle, before it hits all the Micro$oft junque. I posted this same question on an iTar, but I hold little hope for an answer. After 5 days of silence I was told that how to questions are only answered when there is nothing else to do. Thanks for your help. Don e: [EMAIL PROTECTED] _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Size of variable in PL/SQL
Hi Friends : I have a variable defined as below : v_smessage varchar2(32000):= null; When i am using it with size greater than 4000 bytes i am getting error below : ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1 What need I do for it works right ? Need I to change any parameter in database ? I have already saw it working rigth ... Regards Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Collection
Hi Friends : does anyone use the resource collection in 8i. wich advantages we have using it ? Are there problems using it ? Are there performance problemns ? Spaces ? Regards Eriovaldo [EMAIL PROTECTED] Limeira / Brazil _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
9i ? What is this ?
Hi Friends : Does anyone could explain in general how is the Database 9i, comparing it with 8i, 8.1, 8.0 ? I know a bit about this ... Wich part is too diferent from others versions ? Regards Eriovaldo _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
How to record history / procedure execution
Friends : I would like to record some history as : procedure name , start date, finish date and other things ... in a normal table. but, i wouldn´t to call the procedure doing it at the begin and at the finish of the procedure that i want to record the history ... Are there others ways to do it ? Like : a trigger of schema in execution of procedure.. Regards Eriovaldo [EMAIL PROTECTED] Brazil _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
How to send html using UTL_SMTP
Hi friends : What can I do for send html text using UTL_SMTP. I have knowledgement using normal text but not with html. Regards. Thanks. Eriovaldo [EMAIL PROTECTED] Brazil _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Error conecting by svrmgrl
Friends : I have a database Oracle installed in NT. I have deleted the service and rebuild it again. Now, when I try to connect in the database using svrmgrl i received a error message. Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete. What can i do for correct it ? Where is this address ? and What can I do for delete the services that aren't being used in NT ? Regards Eriovaldo _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: send email through pl/sql ???
Hi Janet :
Try to use this code.
It works only in 8.1 above version of database.
create or replace PROCEDURE send_mail (senderIN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
IS
mailhost VARCHAR2(30) := 'internet';
smtp_error EXCEPTION;
mail_conn utl_tcp.connection;
PROCEDURE smtp_command(command IN VARCHAR2,
ok IN VARCHAR2 DEFAULT '250')
IS
response varchar2(3);
lixo pls_integer;
BEGIN
lixo := utl_tcp.write_line(mail_conn, command);
response := substr(utl_tcp.get_line(mail_conn), 1, 3);
IF (response ok) THEN
RAISE smtp_error;
END IF;
END;
BEGIN
mail_conn := utl_tcp.open_connection(mailhost, 25);
smtp_command('HELO ' || mailhost);
smtp_command('MAIL FROM: ' || sender);
smtp_command('RCPT TO: ' || recipient);
smtp_command('DATA', '354');
smtp_command(message);
smtp_command('QUIT', '221');
utl_tcp.close_connection(mail_conn);
EXCEPTION
WHEN OTHERS THEN
null;
END;
create or replace PROCEDURE PR_ENVIA_EMAIL
(senderIN VARCHAR2,
recipient IN VARCHAR2,
subj IN VARCHAR2,
body IN VARCHAR2)
as
crlf VARCHAR2(2):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2(32000);
mail_conn UTL_SMTP.CONNECTION;
cc_recipient VARCHAR2(50) default 'email';
bcc_recipient VARCHAR2(50) default 'email';
BEGIN
mail_conn := utl_smtp.open_connection('servidor email', 25);
utl_smtp.helo(mail_conn, 'mailhost');
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
utl_smtp.rcpt(mail_conn, cc_recipient);
utl_smtp.rcpt(mail_conn, bcc_recipient);
mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From: ' || sender || crlf ||
'To: ' || recipient || crlf ||
'Cc: ' || cc_recipient || crlf ||
'Bcc: ' || bcc_recipient || crlf ||
'Reply-to: 'email, email' || crlf ||
'X-Sent-by: Widesoft Widelog - 1 ' || crlf ||
'X-Event: Deu pau no procedimento W_supxxx1 ' || crlf ||
'Subject: ' || subj || crlf;
mesg:= mesg || '' || crlf || body;
utl_smtp.data(mail_conn, mesg);
utl_smtp.quit(mail_conn);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);
END;
exec PR_ENVIA_EMAIL ('email','email','Test Message - ','Dear friend :
' || chr(13) || chr(10) || 'It is a very good resource' );
Eriovaldo
[EMAIL PROTECTED]
Brazil
From: Janet Linsy [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: send email through pl/sql ???
Date: Tue, 17 Jul 2001 20:45:23 -0800
Hi all,
Does anybody know how to send email through pl/sql?
thank you.
Janet
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
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).
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eca Eca
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).
Procedure Builder - Seeing variables
Hi all, Does anyone know what can I do for to see the variables in Procedure Builder. I know to start the procedure and i don´t get to see the variables in debbug option. Where must I click for it ? Regards Eriovaldo [EMAIL PROTECTED] Brazil _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
Scripts for tuning in 8.1.6
Hi Friends : Does anyone have some good prepared scripts for tuning in database. And how to use it in Linux ? I know that it is necessary to run several times and to calculate some statistics using the result of the queries. Regards Eriovaldo _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
No Subject
Hi friends : How to calculate the parameters : Shared_pool_size, db_block_buffer, sort_area_size of Database for : 50 session simultaneous 512 MB ram Linux Regards. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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:
Friend : The database will be used with : - java applications accessing - on line transactions by internet - procedures schedulled ( a lot ) - pages getting data from internet Eriovaldo From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Date: Mon, 16 Jul 2001 06:30:48 -0800 What's the intended use of the database, or the nature of the application that will hit this database? -Original Message- From: Eca Eca [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Subject: Hi friends : How to calculate the parameters : Shared_pool_size, db_block_buffer, sort_area_size of Database for : 50 session simultaneous 512 MB ram Linux Regards. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
MTS - in Linux
Friends : I have the parameters below and we are receiving the message : PMON: terminating instance due to error 601 Instance terminated by PMON, pid = 11300 Load Indicator not supported by OS ! Does anyone know this error ? If i to alter all parameters MTS solve this problem ? Regards Eriovaldo BANNER Oracle8i Release 8.1.6.1.0 - Production PL/SQL Release 8.1.6.0.0 - Production CORE8.1.6.0.0 Production TNS for Linux: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production SVRMGR show parameter mts NAMETYPEVALUE --- --- -- mts_circuitsinteger 225 mts_dispatchers string (protocol=TCP) mts_listener_addressstring mts_max_dispatchers integer 5 mts_max_servers integer 20 mts_multiple_listeners boolean FALSE mts_servers integer 1 mts_service string I001 mts_sessionsinteger 220 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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).
