RMAN: SVR4 Error: 27: File too large
Hi List, How to fix this error without changing something in OS level? Is tehre any command to set max block size in RMAn before we do backup? Thanks in advance? RMAN-08031: released channel: c1 RMAN-08031: released channel: c2 RMAN-08031: released channel: c3 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-10035: exception raised in RPC: O RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN-03015: error occurred in stored script ts_noncrm_data_backup RMAN-03007: retryable error occurred during execution of command: backup RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "/u03/backup/rman/al_HSBC5087585421" ORA-27044: unable to write the header block of file SVR4 Error: 27: File too large Additional information: 3 RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN> $ ulimit -sa time(seconds)unlimited file(blocks) unlimited data(kbytes) 2097148 stack(kbytes)8192 coredump(blocks) 0 nofiles(descriptors) 64 vmemory(kbytes) unlimited -- 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).
RMAN Error
Hi List, I am getting the following RMAN error. Any help would be really appreciated. RMAN script:- == RMAN> replace script ts_system_backup { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; sql 'alter system switch logfile'; resync catalog; backup tablespace system format='al_%d%t%p'; } OUTPUT RMAN-03022: compiling command: backup RMAN-03023: executing command: backup RMAN-08008: channel c1: starting full datafile backupset RMAN-08502: set_count=7 set_stamp=508754890 creation_time=30-OCT-03 RMAN-08010: channel c1: specifying datafile(s) in backupset RMAN-08522: input datafile fno=1 name=/dev/vx/rdsk/dbdg10/System.dbf RMAN-08011: including current controlfile in backupset RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: c1 RMAN-08031: released channel: c2 RMAN-08031: released channel: c3 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03015: error occurred in stored script ts_system_backup RMAN-03007: retryable error occurred during execution of command: backup RMAN-07004: unhandled exception during command execution on channel c1 RMAN-10035: exception raised in RPC: ORA-19502: write error on file "al_HSBC5087548901", blockno 2040833 (blocksize=512) ORA-27063: skgfospo: number of bytes read/written is incorrect Additional information: 52736 Additional information: 131072 RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE RMAN> Recovery Manager complete. Thanks -tamizh -- 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).
Noarchivelog ==> archivelog
Hi List, Could someone help me to figure out what is going on here? I am trying to change db from NOARCHIVELOG --> ARCHIVELOG. SQL> archive log list Database log mode No Archive Mode Automatic archival Enabled Archive destination/u02/arch Oldest online log sequence 966 Current log sequence 968 SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 1409298592 bytes Fixed Size73888 bytes Variable Size 374722560 bytes Database Buffers 102400 bytes Redo Buffers 10502144 bytes Database mounted. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-01126: database must be mounted EXCLUSIVE and not open for this operation Thanks Sami -- 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).
Re: Oracle Streams
Hi Tanel, As you suggested i have upgraded to 9.2.0.4. Now i want to invalidate all the packages and revalidate again. So i did execute utlip.sql (to invalidate first) and below is the update sql as part of utlip.sql update obj$ set status = 6 where ((type# in (7, 8, 9, 11, 12, 14, 22, 32, 33)) or (type# = 13 and subname is null)) and status not in (5,6) and linkname is null and (oid$ is null or oid$ not in (select toid from type$ where bitand(properties, 16) = 16)) / The above update SQL statement is taking long time. Enclosed is the v$session_wait table output. Could someone help me to figure out -to whom the above UPDATE sql statement is waiting for? SID SEQ# EVENT STATE SECONDS_IN_WAIT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME 1 516 pmon timer WAITING 1481 duration 300 012C NULL0 00 NULL0 00 0 19 477 jobq slave wait WAITING 1400 NULL0 00 NULL0 00 NULL0 00 0 16 22 SQL*Net message from client WAITING 1385 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 18 91 SQL*Net message from client WAITING 1385 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 21 118 SQL*Net message from client WAITING 1381 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 23 48 SQL*Net message from client WAITING 1358 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 6 6 rdbms ipc message WAITING 1349 timeout 18 0002BF20 NULL0 00 NULL0 00 0 7 306 rdbms ipc message WAITING 1252 timeout 500 01F4 NULL0 00 NULL0 00 0 9 69 rdbms ipc message WAITING 867 timeout 3 7530 NULL0 00 NULL0 00 0 30 344 SQL*Net message from client WAITING 680 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 28 31 SQL*Net message from client WAITING 472 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 5 199 smon timer WAITING 120 sleep time 300 012C failed 0 00 NULL0 00 0 17 37 jobq slave wait WAITING 107 NULL0 00 NULL0 00 NULL0 00 0 27 197 SQL*Net message from client WAITING 58 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 10 175 rdbms ipc message WAITING 49 timeout 6000 1770 NULL0 00 NULL0 00 0 2 665 rdbms ipc message WAITING 37 timeout 300 012C NULL0 00 NULL0 00 0 12 12 jobq slave wait WAITING 36 NULL0 00 NULL0 00 NULL0 00 0 15 229 wakeup time manager WAITING 8 NULL0 00 NULL0 00 NULL0 00 0 4 1157 rdbms ipc message WAITING 3 timeout 300 012C NULL0 00 NULL0 00 0 22 189 SQL*Net message from client WAITING 3 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 3 2261 rdbms ipc message WAITING 1 timeout 114 0072 NULL0 00 NULL0 00 0 11 13716 db file scattered read WAITING 1 file# 1 0001 block# 40601 9E99 blocks 16 0010 0 26 7307 SQL*Net message from client WAITING 1 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 25 541 SQL*Net message from client WAITING 1 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 0 29 1255 SQL*Net message from client WAITED KNOWN TIME 0 driver id 1413697536 54435000 #bytes 1 0001 NULL0 00 2 thanks -tamizh - Original Message - Date: Sunday, October 26, 2003 9:24 am > Hi! > > This statement shouldn't do much more than change some SGA and > controlfilestructures, so an hour seems to bee too long. Have you > set 10046 trace on > for t
ORA-03113: end-of-file ... during Oracle Streams setup
Hi List I am in the process of setting up Oracle Streams and getting the following error << *** 2003-10-26 17:01:38.417 *** SESSION ID:(11.18) 2003-10-26 17:01:37.836 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ORA-00448: normal completion of background process >> while running (OEM generated script to setup Oracle Streams) << BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee => 'STRMADMIN', grant_option => TRUE); END; / >> Any help would be really appreciated. -tamizh -- 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).
Re: ORA-03113: end-of-file ... during Oracle Streams setup
No. I did not shutdown the oracle DB. It is an oracle bug. Problem:- BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, grantee => 'STRMADMIN', grant_option => TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, grantee => 'STRMADMIN', grant_option => TRUE); DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege => DBMS_RULE_ADM.CREATE_RULE_OBJ, grantee => 'STRMADMIN', grant_option => TRUE); END; / Solution:- << could ask the customer to re-load as SYS $OH/rdbms/admin/dbmsread.sql $OH/rdbms/admin/prvtread.plb . then try the testcase. >> -tamizh - Original Message - Date: Sunday, October 26, 2003 4:44 pm > Well, it's easy. You're doing "shutdown immediate" during the > procedureexecution. do "shutdown abort" and you'll get rid of the > error message. > > > On 2003.10.26 16:14, [EMAIL PROTECTED] wrote: > > Hi List > > > > I am in the process of setting up Oracle Streams and getting the > following> error > > > > << > > *** 2003-10-26 17:01:38.417 > > *** SESSION ID:(11.18) 2003-10-26 17:01:37.836 > > OPIRIP: Uncaught error 1089. Error stack: > > ORA-01089: immediate shutdown in progress - no operations are > permitted> ORA-00448: normal completion of background process > > >> > > > > while running (OEM generated script to setup Oracle Streams) > > > > << > > BEGIN > > DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( > > privilege => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ, > > grantee => 'STRMADMIN', > > grant_option => TRUE); > > END; > > / > > >> > > > > > > Any help would be really appreciated. > > -tamizh > > > > -- > > 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). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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: 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 Streams
>0001 >NULL0 >00 >0 > > 6 >6 >rdbms ipc message >WAITING >1349 >timeout >18 >0002BF20 >NULL0 >00 >NULL0 >00 >0 > > 7 >306 >rdbms ipc message >WAITING >1252 >timeout >500 >01F4 >NULL0 >00 >NULL0 >00 >0 > > 9 >69 >rdbms ipc message >WAITING >867 >timeout >3 >7530 >NULL0 >00 >NULL0 >00 >0 > > 30 >344 >SQL*Net message from client >WAITING >680 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >0 > > 28 >31 >SQL*Net message from client >WAITING >472 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >0 > > 5 >199 >smon timer >WAITING >120 >sleep time >300 >012C >failed >0 >00 >NULL0 >00 >0 > > 17 >37 >jobq slave wait >WAITING >107 >NULL0 >00 >NULL0 >00 >NULL0 >00 >0 > > 27 >197 >SQL*Net message from client >WAITING >58 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >0 > > 10 >175 >rdbms ipc message >WAITING >49 >timeout >6000 >1770 >NULL0 >00 >NULL0 >00 >0 > > 2 >665 >rdbms ipc message >WAITING >37 >timeout >300 >012C >NULL0 >00 >NULL0 >00 >0 > > 12 >12 >jobq slave wait >WAITING >36 >NULL0 >00 >NULL0 >00 >NULL0 >00 >0 > > 15 >229 >wakeup time manager >WAITING >8 >NULL0 >00 >NULL0 >00 >NULL0 >00 >0 > > 4 >1157 >rdbms ipc message >WAITING >3 >timeout >300 >012C >NULL0 >00 >NULL0 >00 >0 > > 22 >189 >SQL*Net message from client >WAITING >3 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >0 > > 3 >2261 >rdbms ipc message >WAITING >1 >timeout >114 >0072 >NULL0 >00 >NULL0 >00 >0 > > 11 >13716 >db file scattered read >WAITING >1 >file# >1 >0001 >block# >40601 >9E99 >blocks >16 >0010 >0 > > 26 >7307 >SQL*Net message from client >WAITING >1 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >0 > > 25 >541 >SQL*Net message from client >WAITING >1 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >0 > > 29 >1255 >SQL*Net message from client >WAITED KNOWN TIME >0 >driver id >1413697536 >54435000 >#bytes >1 >0001 >NULL0 >00 >2 > > > > > thanks > -tamizh > > > - Original Message - > From: Tanel Poder <[EMAIL PROTECTED]> > Date: Sunday, October 26, 2003 9:24 am > Subject: Re: Oracle Streams > > > Hi! > > > > This statement shouldn't do much more than change some SGA and > > controlfilestructures, so an hour seems to bee too long. Have > you > > set 10046 trace on > > for this session and checked whether it's doing anything? Or check > > v$session_wait and see whether this session is waiting on something. > > > > Anyway, since Streams is fresh new functionality, I recommend to > > use 9.2.0.4 > > for it, first version is probably too buggy... > > > > Tanel. > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Sunday, O
Isolating one of the replication DB
Hi List, We have 4 multi master database setup in our shop and like to isolate (disconnect/remove) one of the database from replication. What are the steps to be performed( the remaining 3 db should not be affected). Thanks in advance -tamizh -- 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).
Isolating one of the replication DB
Hi List, We have 4 multi master database setup in our shop and like to isolate (disconnect/remove) one of the database from replication. What are the steps to be performed( the remaining 3 db should not be affected). Thanks in advance -tamizh -- 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).
Oracle Streams
Hi Gurus, I am trying to setup Oracle Streams(for replication purpose) in oracle 9.2.0.1 running on windows NT. The following statement is part of Stream confuguration at source DB but it is running for more than hour. What does it do? Or is it hanging? Does anyone experience this problem? ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY,UNIQUE INDEX) COLUMNS; Any help would be really appreciated. -tamizh -- 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).
Re: Replication : ORA-04068: existing state of packages has been
Thanks Jared. Recently we did run catrepr.sql and catrep.sql to recreate replication catalog. I was getting the same error even after recompiled all the invalid objects(few packages were invalid). Then restared my instance and now it is woking fine. Thanks again -tamizh - Original Message - Date: Saturday, October 25, 2003 2:04 pm > Have you recently made any changes to your database? > > Upgrades, etc? > > This is the message you will receive when the state > of a package is invalid. It either needs recompiled, > as something it is dependent on has changed, and/or > it is broken for the same reason. > > One possible explanation for this is an incomplete > upgrade. > > You can recompile all stored code in the database > by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql. > > There's another script for this as well, but I can't recall > it at the moment. The above script is generally used as > a final step in an upgrade. > > Jared > > On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote: > > Hi List, > > > > Coudl someone please help me out to resolve this issue? > > > > 1 begin > > 2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE); > > end; > > / > > > > > > begin > > * > > ERROR at line 1: > > ORA-04068: existing state of packages has been discarded > > ORA-04062: of has been changed > > ORA-04062: timestamp of package "SYS.DBMS_REPCAT_RPC" has been > changed> ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812 > > ORA-06512: at "SYS.DBMS_REPCAT", line 532 > > ORA-06512: at line 2 > > > > > > -tamizh > > > > -- > > 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). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > 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: 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).
Replication : ORA-04068: existing state of packages has been discarded
Hi List, Coudl someone please help me out to resolve this issue? 1 begin 2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE); end; / begin * ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04062: of has been changed ORA-04062: timestamp of package "SYS.DBMS_REPCAT_RPC" has been changed ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812 ORA-06512: at "SYS.DBMS_REPCAT", line 532 ORA-06512: at line 2 -tamizh -- 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).
Re: Not able to add DB which is ruuning on the local node
Babu, Thanks for your response. I have only one ORACLE_HOME set in my machine. Also both OEM and Oracle DB are running on my local machine(Windows-NT). --Sami - Original Message - Date: Monday, October 20, 2003 11:04 pm > Is this database on the same O_H as OEM or a different one ? > > Also you may want to review MEtalink articles on "How OEM > discovers a node" > on Metalink... > > Babu > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Saturday, October 18, 2003 10:44 AM > > > > Hi List: > > > > I installed Oracle 9i on Windows NT,configured OEM on Windows > and could > successfully connect to OEM. > > > > Discover node works fine for remote machines(adds > database,listener,httpserver,ect) but not allowing me to add > database which isrunning on local > machine. > > > > Even OEM is not allowing me to add DB using manual configuration. > > > > What could be wrong? Did anyone come across this > > scenario? > > > > Any help would be really appreciated. > > TIA > > -Sami > > > > > > > > > > -- > > 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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Babu Nagarajan > 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: 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).
Not able to add DB which is ruuning on the local node
Hi List: I installed Oracle 9i on Windows NT,configured OEM on Windows and could successfully connect to OEM. Discover node works fine for remote machines(adds database,listener,http server,ect) but not allowing me to add database which isrunning on local machine. Even OEM is not allowing me to add DB using manual configuration. What could be wrong? Did anyone come across this scenario? Any help would be really appreciated. TIA -Sami -- 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).