Re: Oracle networking temp files in /tmp
Rich, Cannot verify now but if I remember correctly, these files are generated by a program in $ORACLE_HOME/bin Look for something like gen* (gennttab ??) This program is generally called during some oracle relink. HTH At 11:04 25/11/2003 -0800, you wrote: >Hey all, > >Running Oracle 9.2.0.4 on Linux, I've noticed several files in /tmp owned by >the oracle user: > >BEQ10202 DCE10202 DEC10202 I1S2 ISPX10202 ITCP10202 LU6210202 >NMP10202 RAW10202 SPX10202 TCP10202 TCPS10202 US10202 VI10202 >BEQ29871 DCE29871 DEC29871 I2S4 ISPX29871 ITCP29871 LU6229871 >NMP29871 RAW29871 SPX29871 TCP29871 TCPS29871 US29871 VI29871 > >It would appear that these files may be related to networking based on the >filename prefixes, but I can't find anything about them in the docs nor >Metalink. The only files with anything in them are the BEQ*, TCP*, and US* >ones, which coincides with the installed networking protocols, except for >the "US*" ones. It appears that those contain some sort of dump or trace. >For example, the file TCPS29871 starts off with: > >ntz.o: > d NZPKCS12_MAGIC_NUM > U _GLOBAL_OFFSET_TABLE_ > U calloc > U free > t gcc2_compiled. > U lxmcpen > U lxsCmpStr > U memcpy > U nldsfprintf > U nldtotrc > U nlepeget > U nlhthfre > U nlhthget > U nlnvcrb > U nlnvdeb > U nlnvfbp > U nlnvgap > U nlpagbp > U nlpagsp > U nlpagvc > U ntctst > U ntpafind >6d00 T ntzAllocate >7040 t ntzCheckServerDN >1120 t ntzConfigure >24c0 t ntzConvertToNumeric >6860 t ntzCreateCipherSpec >08e0 t ntzCreateConnection > >Anyone know what these might be? Since this is my desktop, I'm really >tempted to just blow them away and see what happens, but if nothing happens >it won't be much fun. > >Rich > >Rich Jesse System/Database Administrator >[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jesse, Rich > 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). > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: RMAN Script
Hi Ramon, I guess you are on 8i : your setsize and fileperset specs should be inside the backup command not outside i.e. something like this : backup fileperset 2 setsize 2000 database
RE: OFA and RAC on raw devices
Hi Muqthar , thanks for you reply. Some more precisions : What about the OFA admin subtree (create, pfile, udump,bdump..) ? Did you duplicate it on each node ? What are the steps in Service Guard to configure failover File system ? Do you use RMAN for backups ? if yes with autolocate 9i feature ? If you used soft links for datafiles, it means you have some sort of /oradata// structure on each node. Right ? Does this prove helpful ? Regards At 06:05 19/11/2003 -0800, you wrote: >Gilles, > >RAC Configuration: > > 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access > 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE LOGS (File System) > I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM. > 3. UNDO (RAW FILES) - Each node will have its own UNDO. > >We have STRIPED RAID1+0 to have good performance. Database is not pointing to RAW FILES directly. I have created SOFT LINKS to point to RAW FILES. I have created TABLESPACE using SOFT LINKS. > >Muqthar Ahmed > >-Original Message- >Sent: Wednesday, November 19, 2003 1:55 AM >To: Multiple recipients of list ORACLE-L > > >Hi listers, > > Configuration : > Hp-ux 11i > Oracle 9iR2 with RAC (2 nodes) > OSD clusterware : MC/Service Guard 11.15 > >Oracle software is installed on each node and >the database is on shared raw devices. > > Any experience/gotchas implementing OFA on RAC without cluster file systems? > In particular, do you share the admin subtree between nodes ? and how (NFS >mount ?) >Also do you cross-mount archive log file systems ? > > Thanks in advance for any info or pointers > > Regards > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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).
OFA and RAC on raw devices
Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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).
OFA and RAC on raw devices
Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: Opatch
Ian, what is your Perl version ? I have that same problem with Perl 5.6 on Aix. but not with Perl 5005_03 the version Oracle installed with Oracle HTTP Server. Contacting OWS, they told me that it didn't reproduced with Perl 5.8 I didn't have time to upgrade so I sticked with Perl 5005_03. HTH Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: [PMX:##] Re: cannot disable or drop the ON DATABASE
Hi Rahul in your case (8i ) put _system_trig_enabled = FALSE in your init.ora file, bounce the DB and drop the trigger. Nota : In 9i you can use alter system set "_system_trig_enabled"=false; HTH you wrote: >> Help list... i have created the following in 8.1.5 instance >> >> CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE >> CREATE OR ALTER OR DROP ON DATABASE >> >> BEGIN >> null; >> END; >> / >> >> and now i cannot drop or disable this trigger >> >> ERROR at line 1: >> ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER >> >> >> i'm loggin into svrmgrl and connecting as internal to try drop or >> disable.. >> is this a bug ?? >> >> TIA >> >> Rahul.. >> >> >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: rahul sharma >> 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). >> > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: Oracle Verison Information
Hi Munish, in 8i start Oracle Universal Installer and go to Products installed (or something like that) you can then save the list as a text file. In 9i, download Opatch from Metalink and use the following command : opatch lsinventory HTH At 04:43 30/06/2003 -0800, you wrote: > Hi Listers, I have a peculiar problem. I want to get the version of >oracle software with all the patches that are installed without opening >the database. Is there any file form which i can extract this >information. This is required for both Windows and Solaris Platforms. Any >help provided will be appreciated. Thanks and Best Regards Munish Bajaj >Attachment Converted: "c:\program files\eudora\attach\Blank Bkgrd1.gif" Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: oracle authentication from windows
eas how to restrict the externally identified users so that they >> >> have to log in to the database server to access their oracle schemas.? >> > >> >Well, they are mutually exclusive. A user is authenticated by either the >> >database or externally, not both. So if you create user scott identified >> >externally, you are allowing him to bypass database authentication. If >you >> >don't want that, then you would create user SCOTT identified by a >password. >> > >> In fact if os_authent_prefix=OPS$ and ONLY in this case, >> you can still do this (it's inherited from V6 days but still working >> with Oracle 9i R2) : >> >> create user ops$arup identified by nanda; >> grant create session to ops$arup; >> And know you can either connect with >> sqlplus / >> or >> sqlplus /nolog >> connect ops$arup/nanda >> or >> sqlplus /nolog >> connect ops$arup >> password : nanda >> >> Although it doesn't work directly from the command line >> like sqlplus ops$arup/nanda >> or sqlplus ops$arup >> password : nanda >> (But works again after you get >> Enter username for a 2nd try) >> >> Regards >> >> >> Gilles Parc >> >> carpe diem !! >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Gilles PARC >> 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). >> >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Arup Nanda > 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). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: tnslsnr core dump
Jason, I don't remember the bug number but search on Metalink and you will find it. If I recall correctly, it's caused by the presence of comments (# lines) in listener.ora file. HTH At 08:05 25/06/2003 -0800, you wrote: >All, > >I'm an Oracle newbie, and have a problem. I am running Oracle 8.0.5 on AIX >4.3.3. I am trying to change the password to control the listener, but >tnslsnr core dumps and I get an empty listener.ora file in >$ORACLE_HOME/network/admin every time I attempt to change and save the new >password. It looks like the problem is with "save_config". Below is a >screen capture of what I did: > >zcycpdlc2:/ora/app/oracle/product/8.0.5/network/admin> lsnrctl >LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.5.0.0 - Production on >25-JUN-03 14:52:05 > >(c) Copyright 1997 Oracle Corporation. All rights reserved. > >Welcome to LSNRCTL, type "help" for information. > >LSNRCTL> change_password >Old password: >New password: >Reenter new password: >Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=zcycpdlc2)) >Password changed for LISTENER >The command completed successfully >LSNRCTL> SET PASSWORD >Password: >The command completed successfully >LSNRCTL> save_config >Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=zcycpdlc2)) >TNS-12537: TNS:connection closed > TNS-12560: TNS:protocol adapter error > TNS-00507: Connection closed > >Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY)) >TNS-12224: TNS:no listener > TNS-12541: TNS:no listener > TNS-12560: TNS:protocol adapter error > TNS-00511: No listener >IBM/AIX RISC System/6000 Error: 79: Connection refused >Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=zcycpdlc2)(Port=1521)) >TNS-12224: TNS:no listener > TNS-12541: TNS:no listener > TNS-12560: TNS:protocol adapter error > TNS-00511: No listener >IBM/AIX RISC System/6000 Error: 79: Connection refused >LSNRCTL> uqit >NL-00853: undefined command "uqit". Try "help" >LSNRCTL> quit >zcycpdlc2:/ora/app/oracle/product/8.0.5/network/admin> > > >Any help would be appreciated. Thanks in advance!! > >Jason Alburger > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: > 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). > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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 : Create tablespace performance problem
Hi Listers, Configuration : Software : Aix 4.3.3 / Oracle 9.2.0.3 Hardware ; 6 CPU, 16 Go RAM, DAS clarriion FC4500 with 2 Storage Processors (SP) 1 Fibre channel link by SP 10 x 36 Go Disks 512 Mo of cache Disk configuration : 1 RAID group raid1 (2 disks)Lun bound to SPA --> hdisk1 --> VG01 1 RAID group raid5 (9 disks - stripe size 128Ko) Lun bound to SPB --> hdisk2 --> VG02 1 RAID group raid5 (6 disks - stripe size 64Ko) Lun bound to SPA --> hdisk3 --> VG03 1 RAID group raid1(2disks) Lun bound to SPB --> hdisk4 --> VG04 1 Hot spare Now the problem : Nota : Oracle block size is 8Ko I created 8 x 8 Go raw logical volumes (aka raw devices) on VG02 when I create a 64 Go tablespace (8 datafiles) on these, it takes 2h30 then I created 10 x 8Go raw logical volumes on VG03 But when I create a 80 Go tablespace (10 datafiles) on these, it takes only 30 minutes. That's 5 times less for a bigger size !! What can be the reason ? So far, the differences I see are : - VG and so LVs are attached to a different controller (SPA vs SPB) - stripe size is different (64k vs 128K) - stripe width is different (6 disks vs 9 disks) - VG Partition Size is different (256 Mo vs 512 Mo) Which one do you think is the main culprit ? As I'm not on site and I don't want to change all at once, I plan to ask first for a double check of the FC links, controllers and Luns configuration But after that except asking to rebuild with the same stripe size , width and PPsize, I'm at a loss. Any ideas ? except BAARF of course ;-)) Thanks in advance Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: oracle authentication from windows
Hi Arup, At 21:59 21/06/2003 -0800, you wrote: ... >An OS user called scott will be able to connect as the database user >OPS$SCOTT, not SCOTT - a big difference. This is why the os_authent_prefix >parameter is so important to set; don't leave it as null. If it is null, >then the OS user scott can connect to database user scott. > Maybe I miss the obvious.. Considering remote_os_authent=false, why for LOCAL connections os_authent_prefix='' is inherently less secure than os_authent_prefix=OPS$ or whatever string you choose. In each case, the prerequisite is to create the user "identified externally" (that's where you MUST be cautious) But if scott is created with a password (i.e create user scott identified by tiger) then no OS user scott can log on whatever the os_authent_prefix is. At least that's how I understand the feature. Can you please elaborate on the security issue ? >> Any ideas how to restrict the externally identified users so that they >> have to log in to the database server to access their oracle schemas.? > >Well, they are mutually exclusive. A user is authenticated by either the >database or externally, not both. So if you create user scott identified >externally, you are allowing him to bypass database authentication. If you >don't want that, then you would create user SCOTT identified by a password. > In fact if os_authent_prefix=OPS$ and ONLY in this case, you can still do this (it's inherited from V6 days but still working with Oracle 9i R2) : create user ops$arup identified by nanda; grant create session to ops$arup; And know you can either connect with sqlplus / or sqlplus /nolog connect ops$arup/nanda or sqlplus /nolog connect ops$arup password : nanda Although it doesn't work directly from the command line like sqlplus ops$arup/nanda or sqlplus ops$arup password : nanda (But works again after you get Enter username for a 2nd try) Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: DATAFILE SIZE
Hi jerome, I think there is still a limit. For example, with Oracle 9i 64 bits on Aix 4.3.3 the limit is around 4 million Oracle blocks (exactly 4194303) for a datafile/tempfile So the real limit depends on your db_block_size but there is one. HTH Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: sysresv doesn't work on AIX
Hi peter, you need to use sysresv with oracle user. Is it what you do ? HTH At 12:33 26/03/2003 -0800, you wrote: >Poking around metalink I found a reference to a utility called >sysresv (note 123322.1). According to the document it >displays the id and key for each for the shared memory segments >which the Oracle instances have created. > >I tried it on an AIX 4.3 system running three Oracle instances and it >does not work. > >Example: > ># sysresv -l vdev delmia ngcdev > >IPC Resources for ORACLE_SID "vdev" : >Shared Memory >ID KEY >No shared memory segments used >Oracle Instance not alive for sid "vdev" > >IPC Resources for ORACLE_SID "delmia" : >Shared Memory >ID KEY >No shared memory segments used >Oracle Instance not alive for sid "delmia" > >IPC Resources for ORACLE_SID "ngcdev" : >Shared Memory >ID KEY >No shared memory segments used >Oracle Instance not alive for sid "ngcdev" > >If I do Aipcs -m | grep oracle > >I get: > >m 1179648 0xf50105e0 --rw-r- oracle oinstall >m 1179649 0xfa5fbc28 --rw-r- oracle oinstall >m 2 0x02da4bbc --rw-r- oracle oinstall > >Anyone else have similar experiences? > >Thanks, >Peter Schauss >Northrop Grumman Corporation >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Schauss, Peter > 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). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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).
FYI : Bug on asynch Io for Aix 4.3 / Oracle 9.2
Hi listers, I discovered recently that the init.ora parameter filesystemio_options defaulted to none in 9.2 on Aix 4.3.3. (In 8i it was hidden and defaulted to asynch). This parameter is mainly here to help avoid OS bugs / problems by disabling certain types of IO (I think mainly Aio) on file systems. I opened a TAR and was just told that this issue has been logged under Bug 2510406 ( UNPUBLISHED) fixed in 10i. Abstract: " FILESYSTEMIO_OPTIONS IS SET TO "NONE" WITH A DEFAULT ON AIX " As the Oracle analyst couldn't say what was the impact if I put it back to asynch, I asked for a backport in 9.2. I asked also for an alert. HTH Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: lost control files
Hi , Some precisions : If you have ONLY LOST the controlfiles after a clean shutdown (normal or immediate) you can just : 1) startup nomount 2) recreate the controfiles (CREATE CONTROLFILE command) 3) open the database in NORESETLOGS mode. If you have ONLY LOST the controlfiles after a shutdown abort or hardware crash you have to : 1) startup nomount 2) recreate the controfiles (CREATE CONTROLFILE command) 3) recover database (this will use your online logs) 3) open the database in NORESETLOGS mode. Hope thie helps At 13:15 09/01/2003 -0800, you wrote: >Jeff, > >You are right. It's still possible to create the controlfile by hand using >the CREATE CONTROLFILE command. You can do, in fact you *have* to do >incomplete recovery "recover database using backup controlfile until cancel" > >However, a BIG however, here; you MUST know all the file names that were >there in the database, except temporary tablespace, all redo logs to create >the controlfile. It's often this information that's impossible to obtain. >Therefore it's a good practice to throw in a statement "ALTER DATABASE >BACKUP CONTROLFILE TO TRACE" into your regular hot backup script or just a >cronjob that creates the trace file in the user_dump_dest directory. In case >of a disater like this you have at least that file to go back to and save >yourself from writing the commands. > >HTH. > >Arup Nanda > > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, January 09, 2003 3:04 PM > > >> >> Wrong...I _think_ :) >> >> If he rebuilds them using the correct file placements then >> it will work. The only problem is that he will have to open >> RESETLOGS and incomplete recovery will be impossible. But >> if he has all of his datafiles and is only missing control >> files then he can startup nomount and create controlfile >> from there. >> >> Jeff Herrick >> non-OCP DBA >> >> On Thu, 9 Jan 2003, David L Phillips wrote: >> >> > No. It would be like getting amnesia and just using the memories of >someone that looks like you. >> > The data stored in the control files is unique to that database. It >contains location of files, database name, recovery info etc. >> > >> > >> > David L Phillips >> > Database Consultant (8i OCP) >> > Digital Concepts Inc. >> > >> > >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Jeff Herrick >> 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). >> >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Arup Nanda > 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). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: encrypted user/passwd connection
Hi, I think these 2 parameters are necessary ONLY for sql*net V2 compatibility. If you are all Net8 (client and server), the password is always encrypted whatever the number of failed attempts. To test it, active the trace in your client sqlnet.ora file (level 8 or 16) and examine the trace file. By the way, ORA_ENCRYPT_LOGIN must be set in the environment (or registry) and DBLINK_ENCRYPT_LOGIN in the init.ora parameter file. Hope this helps At 07:03 07/01/2003 -0800, you wrote: > >"All oracle passwords are encrypted" is not a true statement. Failed login >attempts, are retried by sending the password in an unencrypted format. >Atleast, until 8.1.7. To avoid which, ORA_ENCRYPT_LOGIN variable and >DBLINK_ENCRYPT_LOGIN parameter (for retried attempts across database link) >should be set to TRUE. > >I could stand corrected though. > >Raj > > > > > >Sony kristanto > >nggih.com> cc: >Sent by: Subject: RE: encrypted user/passwd connection >[EMAIL PROTECTED] >m > > >January 07, >2003 01:53 AM >Please respond >to ORACLE-L > > > > > > >You're right Jared, all oracle password is encrypted. Btw Andrey if it is >possible how to do it ? > >> -Original Message- >> From: Jared Still [SMTP:[EMAIL PROTECTED]] >> Sent: Tuesday, January 07, 2003 11:04 AM >> To: Multiple recipients of list ORACLE-L >> Subject: Re: encrypted user/passwd connection >> >> >> Andre, >> >> Oracle does not send passwords across the network >> in clear text, they are encrypted by default. >> >> Jared >> >> On Monday 06 January 2003 05:43, Andrey Bronfin wrote: >> > Dear list ! >> > I have just been asked the following question: >> > is it possible to make a connection from an Oracle client to an Oracle >> > instance (both are 8.1.7) in an "encrypted" way. >> > I.e. if someone is sitting with a sniffer between the server and the >> > client, then i don't want him to be able to see the user/passwd i'm >> > connecting with. Again , i am NOT asking how store the data in the DB >in >> an >> > "encrypted" way, but how to connect to an instance without showing my >> > passwd. >> > Thanks a lot! >> > Andrey. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: > 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). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: rbs' maxextents in LMT
Hi, the trick is to use package dbms_space_admin (Cf Oracle Doc) to convert from DMT to LMT. With this method, you obtain a "USER" allocation type as seen in dba_tablespaces view that allow you to use maxextents clause. N.B. to ease the conversion, it's better to have DMT tablespaces already using "minimum_extent" clause Hope this helps At 13:33 06/01/2003 -0800, you wrote: >Hi: > >Oracle 8173 on Sun Solaris 2.8. > >I am in the process of converting rollback segments from DMT to LMT (to see >how much performance we can get, if any). The tablespace size is 8G and I >used to create rbs like: > >create rollback segment RBS00X storage(initial 2048K next 2048K minextents >20 maxextents 800) tablespace rbs; > >I set maxextents to avoid "run away transaction". But now with rbs in LMT, >there is no way to set maxextents, how can we avoid "run away transaction" >in this situation? > >Thanks. > >Guang Mei > > >_ >Add photos to your e-mail with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Guang Mei > 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). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: Unix script to stop password-protected listener
Hi Michal, It's a security breach and bug #2366907 has been opened for that. So protect carefully your listener.ora file from non privileged readers. Regards At 01:53 08/10/2002 -0800, you wrote: >Yes, you can change your listener.ora file permission up to 600 on the >server side. In a shell script you can then use encrypted password found >in listener.ora on line PASSWORDS_. > >lsnrctl <set password C6C144CF750E3CA5 >stop >exit >EOF > >If the password is not in the listener.ora file, run lsnrctl, set >password manualy and execute SAVE_CONFIG. This will write a line into >your listener.ora file with the encrypted password. > >HTH, > Mike Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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: How to clone a local database from 9i server to a remote
Hi Nguyen , If i understood correctly what you want, one solution may be to create your DB with 9iR2 software but with 8i compatibility (compatible=8.1.7 in init.ora). HTH Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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).
Security risk with catsnmp catalog
Hi Listers, There is a security risk with catsnmp catalog (/rdbms/admin/catsnmp.sql) which is shipped with Oracle releases. This is generic. Details : this file drop and recreate user dbsnmp with default password "dbsnmp" and give him different privileges. For 8i releases, it is mostly V_$ views privileges But for 9i releases, it will grant "SELECT ANY DICTIONARY" privilege (this one give access to any sys objects like link$ if you see what i mean...). One can argue that the security policy of the site should ensure that default passwordmust be changed. But even in this case, I'm sure that over the time many databases will reverse to the default password because catproc.sql (which execute automatically catsnmp) is required when applying patchsets and sometimes individual patches. I opened a TAR and the support analyst referred me to bug #2432163 which is visible (i thought naively that all security problems were kept out from prying eyes...) As a patch will probably take some time, i asked Oracle to place an alert accordingly . In the meantime, if you don't use OEM, i strongly suggest that you 1- execute /rdbms/admin/catnsnmp.sql to remove this stuff 2- remove /bin/dbsnmp which is by default setuid root (at least if you have followed install procedures and run root.sh) Unbreakable...or autobreakable ;-) Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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: Learn from my mistakes! Or "Helpful DBA hint of the day"
on 18/03/2002 -0800, you wrote: >In 9.0.1, when you create a DB, you would "connect / as sysdba". However, >if you also run "catalog" and "catproc" while connected like this, Oracle >Advanced Symmetric Replication WILL NOT WORK. You *MUST* be connected as >"SYS as sysdba". > >It's taken me forever to find this. The biggest clue I had was a number of >ORA-06550 errors in the create logs that point to a character set mismatch. >Of course, I found an article on Metaclink that said this may be normal, so >I ignored them at first. (I can't find that article again!) > >I know I've sent out at least one other message like this, but these little >things can really come back and haunt a person. And maybe the next time I >have this and send a message to the list, someone with a real memory can >help me! > >Enjoy! :) Hi Rich, sorry for a late answer... Recently i had this same problem upgrading to 8.1.7.3 and found a clue burried in a Metalink Forum (search for thread 142012.995) The interesting part is : The problem might be related to a few SQL*Plus initialization bugs, i.e. you should not call PL/SQL in the same session in which you started the instance. You need to reconnect first HTH Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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: Riddle me this Oracle riddle...
Hi listers, continuing on varchar2 memory cost in PL/SQL, note this found in Oracle 8i/9i PL/SQL user guide : (Chapter 3 PL/SQL Datatypes - Character types - Varchar2) "Small VARCHAR2 variables are optimized for performance, and larger ones are optimized for efficient memory use. The cutoff point is 2000 bytes. For a VARCHAR2 that is 2000 bytes or longer, PL/SQL dynamically allocates only enough memory to hold the actual value. For a VARCHAR2 variable that is shorter than 2000 bytes, PL/SQL preallocates the full declared length of the variable. For example, if you assign the same 500-byte value to a VARCHAR2(2000 BYTE) variable and to a VARCHAR2(1999 BYTE) variable, the former takes up 500 bytes and the latter takes up 1999 bytes. " HTH Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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).
Security hole in some Unix login program
Hi listers, in case like me it escaped your attention last December, there is a security alert concerning a flaw in /bin/login on some Unix / Linux variants permitting an intruder to gain root access. At least AIX and SOLARIS are concerned but check carefully with your OS vendor and patch accordingly. ( for Aix 4.3 fix is APAR IY26443 ) Here are some references : http://www.cert.org/advisories/CA-2001-34.html http://xforce.iss.net/static/7284.php http://www.securityfocus.com/archive/1/246487 For once NT fellows, you are safe... HTH Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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: Is DBMS_OBFUSCATION free in Enterprise Edition?
Hi Cherie, Sorry to be late... Platform Aix 4.3.3 / Oracle 8.1.7 EE Two months ago, i tried to use 3DES (new in 8.1.7 DBMS_OBFUSCATION toolkit) and i got an error saying that i had to install Advanced Security Option to use this algorithm (for simple DES you don't get this error) So, depending on the algorithm you want to use, you can have extra cost as ASO is not free at all. Check carefully with your Oracle rep as i never get a definitive answer on that matter. HTH Gilles Parc Email : [EMAIL PROTECTED] carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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).
Key generator for dbms_obfuscation package
Hi listers, I plan to use Oracle obfuscation tool kit in Triple DES mode (new in 8.1.7) for number and data strings. Do you know a good key generator to strengthen the encryption process ?? Thanks in advance Gilles Parc Email : [EMAIL PROTECTED] carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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: 8.1.7 DB and auto registration with Listener
Hi Kirti, i had support on call today : they say it's probably generic but were speculating about a normal behavior not documented. But as pmon registers correctly when the instance is started, i had to insist they fill a bug. I will let you know Regards At 13:15 08/02/2001 -0800, you wrote: >Hi Gilles, > Thanks for the tip. > It is now working.. > My TAR with OWS is awaiting reply from Oracle Internals team (whatever that >means;).. for the past 2 days.. > > Once again the list does get the job done faster :) > >- Kirti Deshpande > Verizon Information Services > >> -Original Message- >> From:Gilles PARC [SMTP:[EMAIL PROTECTED]] >> Sent:Thursday, February 08, 2001 2:07 PM >> To: Multiple recipients of list ORACLE-L >> Subject: Re: 8.1.7 DB and auto registration with Listener >> >> Hi Kirti, >> >> I have the same problem here on Aix 4.3..3 / RDBMS 8.1.7 : >> restarting or reloading the listener, pmon gets stuck on socket >> (close_wait status) and never register again the database. >> But today i find a workaround simply putting INSTANCE_NAME parameter >> in my init.ora file >> >> I have opened a TAR with OWS and they are supposed to fill >> a new bug. >> >> Hope this helps in your situation >> >> Best Regards >> >> >> >> >> Gilles Parc >> Email : [EMAIL PROTECTED] >> >> carpe diem !! >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> -- >> Author: Gilles PARC >> 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: Deshpande, Kirti > 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). > > Gilles Parc Email : [EMAIL PROTECTED] carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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: 8.1.7 DB and auto registration with Listener
Hi Kirti, I have the same problem here on Aix 4.3..3 / RDBMS 8.1.7 : restarting or reloading the listener, pmon gets stuck on socket (close_wait status) and never register again the database. But today i find a workaround simply putting INSTANCE_NAME parameter in my init.ora file I have opened a TAR with OWS and they are supposed to fill a new bug. Hope this helps in your situation Best Regards Gilles Parc Email : [EMAIL PROTECTED] carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilles PARC 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).
