Change e-mail

Hi Sorry for the spam. But does anyone know how I change the e-mail address i am signed up to this list with Thanks -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: protocol.ora

: If you trace the listener you will see that it is looking for .protocol.ora with a leading period. This is a documented bug. Just copy protocol.ora to .protocol.ora. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 12 Apr 2002, Sajid Iqbal wrote: We used to use

RBS question

Hi All I have just been asked to find if there's contention in the rollback segment header.. which tables (columns) should I look in ? TIA SI -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services

protocol.ora

Hi We used to use the protocol.ora file to restrict access to the database, on oracle 8.0.5 However since moving to Oracle 8.1.6.3 this doesn't work. Am I missing something or is there something wrong. TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

OAS 4.0.8.2

Hi I am using OAS 4082 on Sun Solaris, with Oracle 8.1.6. I was wondering if there is any way of Using 2 DAD's (Data Access Descriptors) with one plsql cartridge agent ? Regards Saj -- Sajid Iqbal Database Team Leader Email: [EMAIL PROTECTED] Website: http://www.vianetworks.co.uk

archivelog mode

.. these are the parameters that I change - # log_archive_start = true # log_archive_dest_1 = location=/u03/oradata/arch # log_archive_format = arch_%t_%s.arc Due to this I have to start archiving whenever I restart, using 'alter system archivelog start' Any ideas ? -- Sajid Iqbal

Locally Managed Tablespace

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Startup (URGENT)

After re-starting the database, the db application seems really slow after looking into it smon seems to be taking up 50% of the cpu !! What is smon doing , is there any way to get around this ?? I have tried leaving it for a while ! Regards -- Sajid Iqbal -- Please see the official

nomount

Hi Anyone now which 2 V$ views can be accessed while in nomount mode ? Also what is a tempfile ? TIA Saj Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: nomount

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

OCP

.. however when he came to doing the actual he just failed ! Does anyone have any thoughts on this ? Also is it possible to get mock exams that are more reflective of the actual exams , from anywhere Regards Saj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid

sysdba and sysoper

The same explanation ? Also whats a tempfile in oracle ? Regards -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

8i OCP

Hi Does anyone have any links (url's) for practice OCP tests. Also can anyone recommend any good books for this TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

ORA-27146: post/wait initialization failed

. Does anyone know how to do this, also how to calculate how much to increase by etc Regards -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Shutdown and archivelog mode

) Due to this when I try to put it archivelog mode after shutdown abort I get a message saying that the database can't be put into archivelog mode because recovery is needed. TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET

Processes

0 278M 260M cpu/2 40:52 18.17% oracle How can we tell what this is doing ? TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Date / Time

,'DD:HH:MI:SS') but obviously that won't work. Is there a solution other than writing a complex function myself which will have to * by 24, / by 60 and substr etc to get the different bits of the number? Please CC any replies directly to me at [EMAIL PROTECTED] Thanks in advance, Saj. -- Sajid Iqbal

OAS

could not resolve SERVICE_NAME given in connect descriptor -- Sajid Iqbal k -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

OAS 4.0.8.2

- Exiting OAS... Execute STOP of all the OAS Processes from the OAS Manager TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: OAS 4.0.8.2

'. Initialization Failure- Exiting OAS... Execute STOP of all the OAS Processes from the OAS Manager TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services

ORA-27146: post/wait initialization failed

I have just installed Oracle 8.1.6 on Solaris 2.6 The machine already has Oracle 8.0.4 installed.. (I shut this database down, as I intended to remove all of it. Now I am getting this error when I try to startup my new 8.1.6 database. TIA -- Sajid Iqbal -- Please see the official

Upgrade 8.0.4 to 8.1.6

hasn't finished.. If I click on the cancel it says that if u cancel the database won't be in the original state. The status bar has only moved a fraction. Should it take this long ? Should I cancel ? TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

desc SQL*PLUS

without any problems ! TIA Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

E-mail from Alert Logs

Hi List Is there any way of receiving an e-mail or sms , whenever a ORA- error appears in the Oracle Alert Log, or when something unexpected happens to the Oracle Instance ? TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

ORA-07445

Hello All This message is appearing in the alert log periodically.. anyone know hat it means and how I can get rid of it ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address not mapped to object] [8] [] [] Thanks -- Sajid Iqbal Database Team Leader -- Please see

ORA-04031

) Errors in file /u01/app/oracle/admin/ukdb/udump/ukdb_ora_8432.trc: ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address not mapped to object] [8] [] [] This is my shared pool size at the moment. shared_pool_size = 52428800 TIA Saj -- Sajid Iqbal Database Team Leader

Import (urgent)

- error code (dec 9, hex 0x9) On Oracle 8.0.5 on Solaris 2.6 TIA -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego