Re: Starting Database from OEM 9.2 gives ORA-12500 Failed to start a dedicated ....
There is not enough memory to start a dedicated connection. sochange the server mode from dedicated to shared, (you can do it change some parameters in init_sid.ora file see oracle documentation). If you are going to change the server mode to shared and you have two databaseon the same machine, thenyou have toassign one listener port for each database. hope this helps Mauricio Vélez Oracle DBA Dharminder Softhome [EMAIL PROTECTED] wrote: Hey all,Following is the environment.Windows 2000Oracle Enterprise 9.2,OEM 9.2I have two 9.2 database installed on my system. OEM is configured properly.One of the database is in automatic startmode and this DB contains OEMrepository.I start the machine, open OEM, login to OEM and then try to start the otherdatabase, but it does not start the DB, instead I getORA-12500 Failed to start a dedicatedOEM doc says that with OEM, you can start/shutdown the database using OEM.Can someone point to me what I am doing wrong. I am using sysusername/password for the startup of the second database.Thanks.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Dharminder SofthomeINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVEE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
Problem with jobs
Hi, This is the situation: I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob. I proved submitting the same procedure to both databases and worked on thefirst one but not on the second one. If I manually execute this:(On the database that have the problem): Exec dbms_job.run(job_number); Then the job is successful executed (without any error) and is programmed to the next interval but after that its not executed any more. And It doesnt appear broken (Its like the queue process were not working). I know all jobs are not executed because the column last_date on dba_jobs its not updated on any job (so next_date column its not updated) and the procedure of each job are not doing what they must do. Its happens since one week ago and before that they were working well. When I submit the Job I issued commit and I dont receive any error message So the Jobs doesnt appear broken (Its like the queue process were not working) But the initialization parameter are job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file So I repeat, the jobs were working well until one week ago, and I havent change nothing special on database. the view dba_job_running appear empty all the time. I removed all jobs and I recreated them again and it didnt resolve the problem. Im not using Oracle Enterprise Management, so I cant see diagnostic error messages and in the alert file it doesnt appear nothing related with the jobs. So early at morning I have to run the jobs manually Im thinking on shutdown down database but I want It to be the last option. I hope you can help me Thanks Mauricio Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
column session_info appear empty on logminer
Hello everybodyI normally have no problems with logminer.
Thedatabase es oracle 8.1.7.4.1 on Windows NT
but in this case the results show me the username and session_info columns empty
Here is the output:
(First I created log_detalle_giros_20040124 as select * from v$logmnr_contents where seg_name = 'GIROS')
SQL select username, 2 to_char(timestamp, 'dd/mm/ hh24:mi:ss'), 3 sql_redo, 4 session_info 5 from log_detalle_giros_20040124 6 where sql_redo like '%3420653%';
USERNAME TO_CHAR(TIMESTAMP,' SQL_REDO SESSION_INFO --- -- 224/01/2004 11:48:47 update "LCA"."GIROS" set "CONS ECUTIVO" = -3420653, "REMITENT E" = 'AMINTA CAMACHO ROJAS', " BENEFICIARIO" = 'ELVIA ROJAS
D E CAMACHO', "SECUENCIA" = 9304 38, "NUMERO_ORDEN" = '00930438 ', "CODIGO_CORRESPONSAL" = '00 55', "CODIGO_CIUDAD" = '0004',
"FECHA" = TO_DATE('23-ENE-200 4 10:24:07', 'DD-MON- HH24 :MI:SS'), "CODIGO_MONEDAR" = ' 0012', "CODIGO_MONEDAE" = '000 2', "VALORR" = 852,44,
"VALORE " = 2299781, "TASA_DE_CAMBIO" = 2697,88, "MENSAJE" = 'AUTORI ZADO EL PAGO CON UN NOMBRE', " CLAVE" = NULL, "TELEFONO1" = '
4118035', "TELEFONO2" = NULL, "PAGADO" = 'S', "ACTUALIZADO" = 'N', "ACTIVADO" = 'S', "OBSE RVACIONES" = 'SE AUT PAG//NO S AVE MONT/ES CLTE 18 OPER Y
CON F REMIT Y TLF SEG OF/JM.R.', " INVESTIGACION" = 'N' where ROW ID = 'AAAGHoAAOAACviHAAG';
So why do those columns appear empty on v$logmnr_contents?
Thanks
Mauricio Vélez
Oracle DBA
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
Jobs are not working
Hello everybody Im woriking on NT and there are two 8i databases on it One database can execute jobs normally, but the other one not execute any job. I proved submitting the same procedure to both database and worked on the first one but not on the second one. How can I resolve this? Mauricio Vélez Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
Re: Jobs are not working
I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
Views for a table
Hi everybody I have the following question How can I querya table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio Vélez Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Jobs are not working
The Jobs are not broken I haven't resolve this yet, alljobswork fineon one database buton the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" [EMAIL PROTECTED] wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 233, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuild! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
problem with log version
Hello everybody
I'm trying to recover a full database from a hot backup.
When I execute the following instruction:
SQL recover database using backup controlfile until cancel;
Then I obtain the error ora-00331,
This is the output:
ORA-00279: change 1581950488 generated at 01/18/04 21:00:01 needed for thread 1ORA-00289: suggestion : C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARCORA-00280: change 1581950488 for thread 1 is in sequence #9537
Specify log: {RET=suggested | filename | AUTO | CANCEL}C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARCORA-00331: log version 8.1.0.0.0 incompatible with ORACLE version 8.0.5.0.0ORA-00334: archived log: 'C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01195: online backup of file 1 needs more recovery to be consistentORA-01110: data file 1: 'F:\ORADATA\CAMBIOS\SYSTEM01.DBF'
In the Oracle Documentation The solution to the error ora-00331 is to recover the databaseusing the old software. The problem is tha I don't have the old software.
Is there a way to change the log version or what can I do?
Regards,
Mauricio Vélez
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: Re: Difference on ArchiveLog (I'm rewriting the question)
Hello everybody thank for your answers, the size I'm talking about is summing up real sizes of archivelogs files, and I had each configuration of redo logs for one week, and the first one was for many months. Therewas not any change on database objects and the database is small, thesumming up real sizes of datafiles is 13G. I thinkIt not should be happennig, because the archive generation shouldn't be dependent on redolog size. But in this case yes (Could be an Oracle 9i bug?). Regards Mauricio Vélez Tanel Poder [EMAIL PROTECTED] wrote: Is your system overloaded e.g. there is a continuous queue of transactionswaiting? In that case, with bigger redologs, full checkpoints happen less frequently, allowing database to work faster, thus generating more redo. But, othervise, the archive generation shouldn't be dependent on redolog size. How are you measuring your archive size, just counting number of files/entries from v$archived_log or summing up real sizes of archivelogs? (´these may differ noticeably, especially when frequent manual logswitches occur or archive_lag_target is set). Tanel. - Original Message - From: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 07, 2004 10:49 PM Subject: Difference on ArchiveLog (I'm rewriting the question) Hello Everybody Im rewriting the question, Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily. I changed the size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily. I think Its not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vélez Do you Yahoo!?Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Difference on ArchiveLog
Hello Everybody Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily. I changed the size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily. So I dont understand why this difference occurs. The database Im working on is oracle 8i and Iis on Windows NT. Regards Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Difference on ArchiveLog
Hello Everybody Im rewriting the question, Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily. I changed the size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily. I think Its not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Difference on ArchiveLog (I'm rewriting the question)
Hello Everybody Im rewriting the question, Some days ago the database I work on had 3 logfiles that sized 100M and the database was generating 4G of archive daily. I changed the size to 20M and the database began to generate 2G of archive daily, then I changed to 50M and It began to generate 3G of archive daily. I think Its not logical that archive size change. The database I'm working on is oracle 9i and I'is on Windows NT. Regards Mauricio Vélez Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Problem with changing Dedicated Server to Shared Server
Hello everybody Im trying to change the Oracle 8i Dedicated Server to Shared (I dont have problems with memory, soI ve configured the large pool well). There are two databases on the same server (NT Server) , when I change one to shared server, the users cant connect to the other one. If I change both to shared server, the users cant connect to the second I changed. I proved with Oracle 9i on Windows NT and the same problem exists. How can I resolve this? Regards Mauricio Vélez Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003
Re: Obtain SQL Statement from audit
Hi The version is Oracle 8i, so is there a way to retrieve the sql statement? could the v$sql view or v$sqltext view be useful? regards Arup Nanda [EMAIL PROTECTED] wrote: You haven't specified the Oracle version. If it's 9i, you could use Fine Grained Auditing (FGA) to get the exact SQLs. Hope this helps. Arup - Original Message - From: Mauricio Vélez To: Multiple recipients of list ORACLE-L Sent: Monday, December 29, 2003 1:39 PM Subject: Obtain SQL Statement from audit Hello everybody I am auditing select statements on one table, so I put the initialization parameter audit_trail = DB and I query the dba_audit_trail and sys.aud$ views and I can get information but I can't get the sql statement. The question is how can I retrieve the sql statement used to select on my table? Regards, Mauricio Vélez Do you Yahoo!?Yahoo! Photos - Get your photo on the big screen in Times Square Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003
Obtain SQL Statement from audit
Hello everybody I am auditing select statements on one table, so I put the initialization parameter audit_trail = DB and I query the dba_audit_trail and sys.aud$ views and I can get information but I can't get the sql statement. The question is how can I retrieve the sql statement used to select on my table? Regards, Mauricio Vélez Do you Yahoo!? Yahoo! Photos - Get your photo on the big screen in Times Square
blob on import and export
Hello everybody I have the following questions: How can I use a full export without blob? Or How can I use a full import without blob? Regards, Mauricio Vélez Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Oracle8i and oracle9i in the same machine
Hi everybody I have been running oracle817 since long time on WindowsNTNow I installed Oracle9i on the same machine and I cannot use both at the same time. How can I resolve this problem regards, Mauricio Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Change dedicated server to shared server
Hi Can somebody tell me the steps for changingmy serverconfiguration from dedicated server to shared server? Thanks Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
long time to kill a session
Hi, the limit of connections on my Dedicated Serveris 400. The Server is on Windows NT I have a script that kills all conections that failsdue to communication.When I run the The script, the status of the sessions change into killbut it takes a long time to really kill them. How Can I free those connections faster? Regards,Mauricio Vélez Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: update statement ???
You have to issue the following command: UPDATE cli_branches SET brch_name = REPLACE(brch_name, ' (NO PHONE #S)'); regards, Mauricio Vélez Janet Linsy [EMAIL PROTECTED] wrote: Hi all,I need to update a column (brch_name) to be without(NO PHONE #S) string. So 3954 will be Denver, 3955will be Golden, and 3963 will be LOVELAND 29TH, etc. How to write this update statement??? Thank you!1* select brch_id, brch_name from cli_branches whereupper(brch_name) like '%PHONE%'SQL /BRCH_ID BRCH_NAME-- --3954 DENVER (NO PHONE #S)3955 GOLDEN (NO PHONE #S)3956 ENGLEWOOD (NO PHONNE #S)3957 LITTLETON (NO PHONE #S)3958 CHARLOTTE (NO PHONE #S)3959 S LEMAY (NO PHONE #S)3960 HARMONY ROAD (NO PHONE #S)3961 ENGLEWOOD (NO PHONE #S)3962 LOVELAND (NO PHONE #S)3963 LOVELAND 29TH (NO PHONE #S)3964 DENVER (NO PHONE #S)__Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwarehttp://sitebuilder.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Janet LinsyINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
