RMAN archive log Back up taking long time
We are using rman to backup the 8.1.6 database. Sometime it is noticed that rman is taking huge time to back up some archivelog files . Generally it takes <20 seconds to backup one archivelog , but for some archivelog files it is taking more then 2 hrs . Did any of you noticed this problem before. Can you share your experience and ideas where should I look into . All files are of same size. Thanks, -oramagic. We have noticed Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more
Re: ORA-28030: Server encountered problems accessing LDAP directory service
Looks like are trying to resolve service name using LDAP naming . David Mitchell <[EMAIL PROTECTED]> wrote: I've recently inherited an Oracle 8.1.6 system and was just trying tosetup a database link between two instances. I've granted the "createdatabase link" priv to the user account and can successfully create thelink but when I try to do a "select from table_name@linked_db;" I getthe following error:ERROR at line 1:ORA-28030: Server encountered problems accessing LDAP directory serviceEarlier I had a TNS error and found that my tnsnames.ora file wasmissing one of my instances. I fixed that problem and tnsping nowresponds correctly but I'm still getting the error listed on the subjectline. My sqlnet.ora file contains "NAMES.DIRECTORY_PATH= (TNSNAMES)" soeverything should be set to use my local tnsnames.ora file. I've beengoing through Oracle Net 8 documentation but still haven't foundanything. Does anyone have any suggestions? Thanks..! .David-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: David MitchellINET: [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! Mail Plus - Powerful. Affordable. Sign up now
RE: ORA-1410 Silliness
Did u do any migration recently . "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: Well, I don't think that's the issue. I'm issuing bulk inserts and using pl/sql tables in this procedure. That functionality has been in place since February and these errors only started surfacing in the last couple of months. I could decrease the commit interval and try that. I just hope it doesn't (big) hammer my runtime, it's bad enough already, even with the screaming fast bulk insert. Thanks Kevin for your input. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Very straight forward. and LONG . (Yea, I read to your last message). Could that be the issue here ?? Is the record too long or some buffer being overwritten in Oracle when there is so long of record and so much data ?? Have you tried (or do you already) commit after each insert from the RAW table ?? I know that you would not think this could help , but buffers and such might get cleared on the commit . just a thought anyway. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't given a chance to improve on it. It is basically a mainframe file that I have stored history of. SQL> desc vegas_mart Name Null? Type - -- ID NOT NULL NUMBER(38) CONTRACT_NUMBER NOT NULL NUMBER(9) LOAD_JOB_ID NOT NULL NUMBER(12) JULIAN_RUN_DATE NOT NULL NUMBER(12) FAC_CODE &n! bsp; VARCHAR2(1) OWNER_LAST_NAME VARCHAR2(20) OWNER_FIRST_NAME VARCHAR2(15) OWNER_ADDRESS1 VARCHAR2(25) OWNER_ADDRESS2 VARCHAR2(25) OWNER_CITY ! VARCHAR2(18) OWNER_STATE VARCHAR2(2) OWNER_ZIP VARCHAR2(9) NET_PURCHASE_PRICE NUMBER(11,2) ORIGINAL_DOWN_PAYMENT NUMBER(11,2) TOTAL_DOWN_PAYMENT NUMBER(11,2) CR_BAL&nbs! p; NUMBER(11,2) INTEREST_RATE NUMBER(5,2) FIRST_PAYMENT_DATE DATE QUALIFICATION_CODE VARCHAR2(1) PAYMENT_AMOUNT NUMBER(9,2) PAYMENT_FREQUENCY &! nbsp; VARCHAR2(1) AGING_10_TO_30_DAYS_DUE NUMBER(9,2) AGING_31_TO_60_DAYS_DUE NUMBER(9,2) AGING_61_TO_90_DAYS_DUE NUMBER(9,2) ASSIGNED_LOAN_ADMIN_REP VARCHAR2(2) DATE_OF_SALE DATE STATUS_OF_ACCOUNT VARCHAR2(1) CONTRACT_TYPE&nb! sp; VARCHAR2(1) WAS_PENDER VARCHAR2(1) CREDIT_LIFE_ON_CONTRACT VARCHAR2(1) DOCUMENT_STATUS_CODE VARCHAR2(1) FIXED_WEEK_SALE VARCHAR2(1) UDI_SALE &nbs! p; VARCHAR2(1) PHASE_NUMBER VARCHAR2(6) FAIRSHARE_PLUS_MEMBER VARCHAR2(1) POINTS_OWNED NUMBER(7) DEED_DATE DATE PRE_AUTH_DRAFT_ACCOUNT VARCHAR2(1) RESERVATION_CODE ! VARCHAR2(4) INTERNATIONAL_CODE VARCHAR2(1) UNIT_PHASE_COMPLETION_CODE VARCHAR2(1) AGING_0_TO_90_DAYS_DUE NUMBER(9,2) AGING_91_TO_120_DAYS_DUE NUMBER(9,2) AGING_121_TO_150_DAYS_DUE NUMBER(9,2) AGING_151_OVER NUMBER(9,2) LOT_LOCATION ! VARCHAR2(12) PAYMENTS_MADE NUMBER(3) SUPPRESSION_CODE VARCHAR2(1) ACCRUED_INTEREST_BAL NUMBER(9,2) PAC_FREEZE_CODE VARCHAR2(1) CREDIT_CARD_FREEZE_CODE VARCHAR2(1) ASSOCIATION_NUMBER ! ; VARCHAR2(4) RFS_ASSIGNMENT_DATE DATE OVERRIDE_MAINT_FEE_BALANCE VARCHAR2(1) RESERVATION_PENDING VARCHAR2(1) CREDIT_REPORTING_CODE VARCHAR2(2) CANCEL_DEFERMENT_REASON_CODE VARCHAR2(2) EQUITY_IN NUMBER(9,2) DATE_CO! DED_7 DATE ADJUSTABLE_RATE_MORTGAGE VARCHAR2(1) NUMBER_OF_PAYS_LEFT NUMBER(4) DEFERRED_INTEREST NUMBER(9,2) DEFERRED_PRINCIPAL NUMBER(9,2) CURRENT_YEAR_DEFERMENTS NUMBER(5) CURRENT_YEAR_TOTAL_DEFERMENTS &nb! sp; NUMBE
Re: Versioning the Database !
I generally follow as a practice to keep a variable v_version at package level or any script level . ( i have only packages ) and this v_version is nothing but $header$ in mks . This way I can always run a query to find out object versions in db . This is REALLY helpful specially when code is wrapped in production . -oramagic . Hemant K Chitale <[EMAIL PROTECTED]> wrote: Versioning the database ?Take a backup of the database on a seperate tape each day !What components of the database do you want to version ? Table definitions ?View definitions ? Packages/Procedures/Triggers ?Code Objects should be versioned, but data objects [Tables/Indexes/Sequences]would generally not vary once the design is done, save for a few changes/additions/enhancements.HemantAt 06:28 AM 27-12-02 -0800, you wrote:>Hi,>> I want to version the Database for development, IT, QA and staging>environment.> Can some one suggest different methods and best possible approach to>maintain the database.>> Database is in design stage & development has partially started. We>are using MKS for versioning.>>Regards>Shree>-->Please see the official ORACLE-L ! FAQ: http://www.orafaq.net>-->Author: Rama, Shreekantha (CAP, CARD)> 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).Hemant K ChitaleMy web site page is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hemant K ChitaleINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 h! ttp://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! Mail Plus - Powerful. Affordable. Sign up now
RE: oracle apps documentation
I am thinking of learning oracle manufacturing myself . Can you suggest which is most proper starting point . I dont know anything abt apps , but know oracle pl/sql and developer 2000 . Thanks , oramagic "Murray, Margaret" <[EMAIL PROTECTED]> wrote: Metalink -> top tech docs (left menu) -> E-business Suite ERP -> -> Documentation (there are also other paths to follow to get to the same place). You'll find user guides and most TRMs Also check out AppsNet: http://www.oracle.com/appsnet/content.html -----Original Message-From: ora ak [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 5:02 PMTo: Multiple recipients of list ORACLE-LSubject: oracle apps documentation can some one point me in right direction to look for oracle applications documentations. I am specially interested in manufacturing and financials . thanks , oramagic Do you Yahoo!?Y! Web Hosting - Let the expert host your web siteDo you Yahoo!? Y! Web Hosting - Let the expert host your web site
oracle apps documentation
can some one point me in right direction to look for oracle applications documentations. I am specially interested in manufacturing and financials . thanks , oramagic Do you Yahoo!? Y! Web Hosting - Let the expert host your web site
Re: SID and DB_NAME
Thanks Rajesh , well explained . I had same idea . that SID is instance indentifier . -oramagic . [EMAIL PROTECTED] wrote: Simply speaking, consider SID to be the name for the various backgroundprocess (DBWR, LGWR, et all) and the memory structures (SGA, PGA). A SIDneeds to be associated with a database, which would be the DB_NAME. The SIDand DB_NAME need not be the same. They have to be different in an OracleParallel Server environment, where you can have two SID's say ORA1 and ORA2associated with the same database, say ORA.Rajora ak hoo.com> cc: Sent by: Subject: SID and DB_NAME root@fatcity. com October 24, 2002 11:23 PM Please respond to ORACLE-L I know this novice question for dba's but just wanted to refresh this ,what is difference between SID and DATABASE_NAME , why init.ora file! ! shouldhave database name same as SID and in what circumstances SID andDB_NAME can be different .TIAoramagic-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [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!? Y! Web Hosting - Let the expert host your web site
SID and DB_NAME
I know this novice question for dba's but just wanted to refresh this , what is difference between SID and DATABASE_NAME , why init.ora file shouldhave database name same as SID and in what circumstances SID and DB_NAME can be different . TIA oramagic Do you Yahoo!? Y! Web Hosting - Let the expert host your web site
Re: How to configure MD5 data encription in Oracle 8i
why not use encryption outside the database and store encrypted string in database . We do it all the time , java application does the encrytion and authentication , db just stores the encrypted string . Just an idea . I dont the answer of your original question :) Oramagic Suman S K <[EMAIL PROTECTED]> wrote: Hi Everybody,Can anyone tell me how to use MD5 hashing algorithm in Oracle8IOr is there any built in package to encrypt the data in Oracle 8i.I have created the Application user table there I am keeping user_Idand Password for the application. How to hide the password column in the table ?ThanksSumanDISCLAIMER: Information contained and transmitted by this E-MAIL isproprietary to Mascot Systems Limited and is intended for use only by theindividual or entity to which it is addressed, and may contain informationthat is privileged, confidential or exempt from disclosure under applicablelaw. If this is a forwarded message, the content of this E-MAIL may not havebeen sent with the authority of the Company. If you are not the intendedrecipient, an agent of the intended recipient or a person! ! responsible fordelivering the information to the named recipient, you are notified that anyuse, distribution, transmission, printing, copying or dissemination of thisinformation in any way or in any manner is strictly prohibited. If you havereceived this communication in error, please delete this mail & notify usimmediately at [EMAIL PROTECTED] Before opening attachments,please scan for viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Suman S KINET: [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!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
RE: Any way to see the currently running SQL in one session.
there is a x$ table which can give u this info I am not able to recall that at the moment . oramagic Paulo Gomes <[EMAIL PROTECTED]> wrote: u could use top sessions-Original Message-Sent: quarta-feira, 16 de Outubro de 2002 2:28To: Multiple recipients of list ORACLE-LDear ALL,Is there any way to see the currently running SQL in one session? Iused v$open_cursor, but there might be many SQL statements, I don't knowwhich one is currently running. And more, if I execute a stored procedure,which SQL statements could be seen in v$open_cursor? Any clues would be much appreciated.TIAChuan-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Paulo GomesINET: [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 mail! ! ing 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!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
Re: Difference - Rebuild and Analyze index
Yes Marul , I think there is a big differenece in them . When you are rebulding the index means you are re-organzing the entries in the index , may be removing the entries for the rows deleted in past and so forth so on. But this doesn't generate any statistics about index.
When you analyze index, you generate information ( statistics) about the data in index , like leaf blocks or depth of index etc.
None of these should require orther , but they have some effect .
Like if you rebuild index , after that you dont have latest statistics and queries may not perform upto mark .
-oramagic
Marul Mehta <[EMAIL PROTECTED]> wrote:
Hi,
Can anybody please tell me the difference between -
SQL > execute DBMS_UTILITY.ANALYZE_SCHEMA('BLAH','COMPUTE',NULL,30,'FOR ALL INDEXES');
and
SQL > select 'ALTER INDEX ' || INDEX_NAME || ' REBUILD ONLINE;' from USER_INDEXES
If I execute any one the above do i need to execute the other also?
After how many days/hour it should be executed.
TIA,
Marul.Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com
Re: Connections with WebLogic (5.1) and Oracle 8.1.7 on Solaris
I though WL manages connection pool. Better look into WL configurations for connection pooling . Joshua Becker <[EMAIL PROTECTED]> wrote: Hi all,we are facing strange problems with our environment.we are using weblogic and solaris8 with 8.1.7.3. It seems that somehow amount of cumulative connectionsis getting extremely high and it seems that WL isdoing db connection each time user clicks theaplication. Is there any parameter on oracle sidecausing this.We have tested this with two similar environment andother seems to work ok and other does generate theseconnections but we do not find any reason for thedifferent behaviour...Any ideas...Rgds,Joshua_Gratis e-mail resten av livet på www.yahoo.se/mailBusenkelt!-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: =?iso-8859-1?q?Joshua=20Becker?=INET:: [EMAIL PROTECTED]Fat City Network Ser! vices -- 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!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
