RE: DBMS_JOB : Can submit but does not execute=working now

[CHAN Chor Ling Catherine (CSC)]

Hi,

Thanks to all who reply. After setting the job_queue_processes to 1 and 
job_queue_interval = 90, the job runs successfully. Thank you.

Regds,
Catherine

-Original Message-
From:   Jay Hostetter [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, February 19, 2003 8:25 PM
To: [EMAIL PROTECTED]; CHAN Chor Ling Catherine (CSC)
Subject:RE: DBMS_JOB : Can submit but does not execute

Make sure job_queue_processes  0.  Also check job_queue_interval.



Jay Hostetter
Oracle DBA
D.  E. Communications
Ephrata, PA  USA

 [EMAIL PROTECTED] 02/18/03 08:28PM 
Hi Gurus,

I use the following command to execute immediately.

Connected.
SQL BEGIN
  2  DBMS_JOB.RUN(1);
  3  END;
  4  /
PL/SQL procedure successfully completed.

--
-- I change the time for next execution to check whether it can submit 
on 18 Feb 2003 at 8am
--
1  begin
  2  DBMS_JOB.CHANGE(1,
  3  ' 
PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDATE+1');
  4* END;
SQL /

It did not execute. Any advice ? TIA

Regds,
Catherine

-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Wednesday, February 19, 2003 9:15 AM
To: '[EMAIL PROTECTED]' 
Subject:DBMS_JOB : Can submit but does not 
execute 

Hi Gurus,

I have submitted a job but it does not execute.  Why? 
Does the owner require any privileges ? However, I can use DBMS_JOB.CHANGE command to 
execute immediately.  I would like the job to execute on a daily basis. Any advice ? 
TIA

--
-- Submit a job
--
  1  DECLARE
  2job BINARY_INTEGER;
  3  BEGIN
  4
DBMS_JOB.SUBMIT(job,'PROCEDURE_NAME;',SYSDATE,'SYSDATE+1');
  5DBMS_OUTPUT.PUT_LINE(TO_CHAR(JOB));
  6* END;
SQL /
1

PL/SQL procedure successfully completed.

SQL COMMIT;

Commit complete.

--
-- Execute the job
--
  1  begin
  2  DBMS_JOB.CHANGE(1,
  3  ' 
PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDATE+1');
  4* END;
SQL /

PL/SQL procedure successfully completed.

SQL COMMIT;

Commit complete.

--
-- Check whether the job is submitted
--
SQL SELECT * FROM DBA_JOBS

  JOB LOG_USER   PRIV_USER
- -- 
--
SCHEMA_USERLAST_DATE LAST_SEC 
THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME B
-- -  
-  -  -- -
INTERVAL


 FAILURES
-
WHAT


NLS_ENV


MISC_ENV   
   INSTANCE

How do you calcuate the temp space needed for view?

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I issue the following command select count(*) from view1 and encounter the following 
error ORA-01630: max # extents (121) reached in temp segment in tablespace TEMP.  I 
think I need to increase the tablespace TEMP  but how do I calculate the temporary 
space needed ? 

Assuming view1 is select * from table1, table2 where table1.Col1=table2.Col1
Is the temporary space needed = (table 1 row-length * table 1 total number of rows ) * 
(table 2 row-length * table 2 total number of rows ) ?

Any advice ? Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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 do you calcuate the temp space needed for view?

[CHAN Chor Ling Catherine (CSC)]

Hi Rafiq,

My database version is 7.3.3.6.0, so I cannot set the maxextents unlimited. I added 
another datafile and increase initial extent and next extent much larger for this 
tablespace. My user still encountered the error. I would like to know how much space 
is needed for selecting the view. Any advice ? TIA.

Regds,
New Bee
-Original Message-
From:   M Rafiq [mailto:[EMAIL PROTECTED]]
Sent:   Friday, February 21, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: How do you calcuate the temp space needed for view?

Your database having db_block_size 2K so max extents are 121. You may 
alter 
your temp tablespace by

alter tablespace temp default storage(maxextents unlimited); then
alter tablespace temp coalesce;

and try your query. If space is not sufficient in temp ts then message 
will 
come with ORA-1652. In that case you have to increase size of temp 
tablespace by resizing extisting file or adding another datafile.


HTH,

Regards
Rafiq







Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 20 Feb 2003 17:08:49 -0800

Hi Gurus,

I issue the following command select count(*) from view1 and encounter 
the 
following error ORA-01630: max # extents (121) reached in temp 
segment in 
tablespace TEMP.  I think I need to increase the tablespace TEMP  but 
how 
do I calculate the temporary space needed ?

Assuming view1 is select * from table1, table2 where 
table1.Col1=table2.Col1
Is the temporary space needed = (table 1 row-length * table 1 total 
number 
of rows ) * (table 2 row-length * table 2 total number of rows ) ?

Any advice ? Thanks.

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: CHAN Chor Ling Catherine (CSC)
   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).


_
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: M Rafiq
  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: CHAN Chor Ling Catherine (CSC)
  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: DBMS_JOB : Can submit but does not execute

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I use the following command to execute immediately.

Connected.
SQL BEGIN
  2  DBMS_JOB.RUN(1);
  3  END;
  4  /
PL/SQL procedure successfully completed.

--
-- I change the time for next execution to check whether it can submit on 18 Feb 2003 
at 8am
--
1  begin
  2  DBMS_JOB.CHANGE(1,
  3  ' PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDATE+1');
  4* END;
SQL /

It did not execute. Any advice ? TIA

Regds,
Catherine

-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Wednesday, February 19, 2003 9:15 AM
To: '[EMAIL PROTECTED]'
Subject:DBMS_JOB : Can submit but does not execute 

Hi Gurus,

I have submitted a job but it does not execute.  Why? Does the owner 
require any privileges ? However, I can use DBMS_JOB.CHANGE command to execute 
immediately.  I would like the job to execute on a daily basis. Any advice ? TIA

--
-- Submit a job
--
  1  DECLARE
  2job BINARY_INTEGER;
  3  BEGIN
  4DBMS_JOB.SUBMIT(job,'PROCEDURE_NAME;',SYSDATE,'SYSDATE+1');
  5DBMS_OUTPUT.PUT_LINE(TO_CHAR(JOB));
  6* END;
SQL /
1

PL/SQL procedure successfully completed.

SQL COMMIT;

Commit complete.

--
-- Execute the job
--
  1  begin
  2  DBMS_JOB.CHANGE(1,
  3  ' 
PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDATE+1');
  4* END;
SQL /

PL/SQL procedure successfully completed.

SQL COMMIT;

Commit complete.

--
-- Check whether the job is submitted
--
SQL SELECT * FROM DBA_JOBS

  JOB LOG_USER   PRIV_USER
- -- --
SCHEMA_USERLAST_DATE LAST_SEC THIS_DATE THIS_SEC 
NEXT_DATE NEXT_SEC TOTAL_TIME B
-- -  -  
-  -- -
INTERVAL


 FAILURES
-
WHAT


NLS_ENV


MISC_ENV  
INSTANCE
 
-
1 USER1  USER1  
USER1  17-FEB-03 20:01:20
18-FEB-03 08:00:00 16 N
SYSDATE+1
0
PROCEDURE_NAME;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' 
NLS_ISO_CURRENCY='AMERICA' NLS_NUME
RIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY' 
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
01020002   
  0

Regds,
Catherine
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

DBMS_JOB : Can submit but does not execute

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I have submitted a job but it does not execute.  Why? Does the owner require any 
privileges ? However, I can use DBMS_JOB.CHANGE command to execute immediately.  I 
would like the job to execute on a daily basis. Any advice ? TIA

--
-- Submit a job
--
  1  DECLARE
  2job BINARY_INTEGER;
  3  BEGIN
  4DBMS_JOB.SUBMIT(job,'PROCEDURE_NAME;',SYSDATE,'SYSDATE+1');
  5DBMS_OUTPUT.PUT_LINE(TO_CHAR(JOB));
  6* END;
SQL /
1

PL/SQL procedure successfully completed.

SQL COMMIT;

Commit complete.

--
-- Execute the job
--
  1  begin
  2  DBMS_JOB.CHANGE(1,
  3  ' PROCEDURE_NAME;',to_date('1802200308:00:00','ddmmhh24:mi:ss'),'SYSDATE+1');
  4* END;
SQL /

PL/SQL procedure successfully completed.

SQL COMMIT;

Commit complete.

--
-- Check whether the job is submitted
--
SQL SELECT * FROM DBA_JOBS

  JOB LOG_USER   PRIV_USER
- -- --
SCHEMA_USERLAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE 
NEXT_SEC TOTAL_TIME B
-- -  -  - 
 -- -
INTERVAL

 FAILURES
-
WHAT

NLS_ENV

MISC_ENV  INSTANCE
 -
1 USER1  USER1  
USER1  17-FEB-03 20:01:2018-FEB-03 
08:00:00 16 N
SYSDATE+1
0
PROCEDURE_NAME;
NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' 
NLS_ISO_CURRENCY='AMERICA' NLS_NUME
RIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-YY' NLS_DATE_LANGUAGE='AMERICAN' 
NLS_SORT='BINARY'
01020002 0

Regds,
Catherine
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

Daily job to populate table in another database

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,
 
If you need to copy data (after some manipulations) from database A to
another table in database B, how do you achieve that ?
Our current practice is to use crontab (schedule daily job) and sqlplus
(procedure to copy the data over to another database via dblink).
 
Do you think it's more efficient to use DBMS_JOB ? Can DBMS_JOB call the
procedure at the same time daily ? Any sample? Please advise. Thanks.
 
Regds,
new bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: plsql cartridge

[CHAN Chor Ling Catherine (CSC)]

Hi Imran,

Instead of alert, you can try to display a web page with the message
...incorrect data, continue? and Yes and No button. 

Hope it helps.

Regds,
Catherine

This communication (including any attachment) is meant only for the
recipient(s) named above and may contain confidential or legally privileged
information. If you are not an intended recipient, this communication has
been sent to you in error and you must delete all copies of this
communication from your computer system and notify the sender immediately by
reply email. Unauthorised use, disclosure, dissemination, distribution,
retention, copying or reliance on this communication is prohibited and may
attract civil and/or criminal penalties. Thank you.

-Original Message-
From:   Imran Ashraf [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, December 10, 2002 11:30 PM
To: Multiple recipients of list ORACLE-L
Subject:plsql cartridge

hi,

i have a web application developed  using Web
Application Server tool kit. The form is dynamically
produced by calling a package/procedure www_aaa. 
I have very little knowledge of this but have been
given a small job to do on it. 

The user enters some data on the form then hits
'Submit'. The procedure does some validation on the
data entered. 

I am trying to have an alert appear if the data in one
of the fields is incorrect. The alert has a simple
message '..incorrect data , continue? YES NO' If user
selects 'Yes it contiues with normal processing, if
'No' is selected cursor goes to relevant field
allowing the user to change the data.

Any examples of how to do this would be appreciated.

Thanks in advance.

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Imran Ashraf
  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.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

OT: Website that contains materials about performance tuning of S

[CHAN Chor Ling Catherine (CSC)]

Hi,

Does anyone know of any web site that contains materials about performance
tuning of SQL (oracle or any other database) ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

How to create user with cannot login sqlplus but can use odbc to

[CHAN Chor Ling Catherine (CSC)]

Hi,
 
I need to create a new user in 8.1.6 who cannot login via sqlplus but can
use odbc to connect to this oracle account. 
Does anyone has the script to create such user ? TIA.
 
Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

How to get the count of all tables using dbms_sql

[CHAN Chor Ling Catherine (CSC)]

Hi,

I need to insert the total number of records all the tables into the table,
MIGRATION_TABLE. I want to use the 
How do I obtain the count(*) into a variable in dbms_sql.parse(cid, 'SELECT
COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7);  ?

TIA

Declare
   cid INTEGER; 
BEGIN 
  for i in (select OWNER,TABLE_NAME from DBA_TABLES) loop

-- Open new cursor and return cursor ID. 
cid := dbms_sql.open_cursor; 

   /* Parse and immediately execute dynamic SQL statement built by 
  concatenating table name to DROP TABLE command.  (Unlike DML 
  statements, DDL statements are executed at parse time.) */ 
   dbms_sql.parse(cid, 'SELECT COUNT(*) FROM ' ||i.owner||'.'||i.table_name,
dbms_sql.v7); 

/* Close cursor. */ 
   dbms_sql.close_cursor(cid); 

  end loop;

EXCEPTION 
   /* If an exception is raised, close cursor before exiting. */ 
   WHEN OTHERS THEN 
  dbms_sql.close_cursor(cid); 
END;

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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 get the count of all tables using dbms_sql

[CHAN Chor Ling Catherine (CSC)]

Hi,

I've found the answer.

DECLARE
countval NUMBER;
curidBINARY_INTEGER;
retval   NUMBER;
BEGIN

for i in (select OWNER,TABLE_NAME from DBA_TABLES WHERE ROWNUM) loop

  curid:= dbms_sql.open_cursor;
  dbms_sql.parse( curid, 'BEGIN SELECT count(*) INTO :cntval FROM '||
 i.owner||'.'||i.table_name||'; END;',  dbms_sql.v7 );
  dbms_sql.bind_variable( curid, 'cntval', countval );
  retval:= dbms_sql.execute( curid );
  dbms_sql.variable_value( curid, 'cntval', countval );
  dbms_sql.close_cursor( curid );
  dbms_output.put_line( 'Count is:= ' || countval );

end loop;

END;
/

Regds,
New Bee
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Thursday, October 17, 2002 4:12 PM
To: '[EMAIL PROTECTED]'
Subject:How to get the count of all tables using
dbms_sql

Hi,

I need to insert the total number of records all the tables
into the table, MIGRATION_TABLE. I want to use the 
How do I obtain the count(*) into a variable in
dbms_sql.parse(cid, 'SELECT COUNT(*) FROM ' ||i.owner||'.'||i.table_name,
dbms_sql.v7);  ?

TIA

Declare
   cid INTEGER; 
BEGIN 
  for i in (select OWNER,TABLE_NAME from DBA_TABLES) loop

-- Open new cursor and return cursor ID. 
cid := dbms_sql.open_cursor; 

   /* Parse and immediately execute dynamic SQL statement
built by 
  concatenating table name to DROP TABLE command.
(Unlike DML 
  statements, DDL statements are executed at parse
time.) */ 
   dbms_sql.parse(cid, 'SELECT COUNT(*) FROM '
||i.owner||'.'||i.table_name, dbms_sql.v7); 

/* Close cursor. */ 
   dbms_sql.close_cursor(cid); 

  end loop;

EXCEPTION 
   /* If an exception is raised, close cursor before
exiting. */ 
   WHEN OTHERS THEN 
  dbms_sql.close_cursor(cid); 
END;

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

Scramble or Delete data in Oracle HRMS 11i

[CHAN Chor Ling Catherine (CSC)]

Hi,

I've cloned the Oracle HRMS 11I Application to another machine. I can access
the form but still cannot view output and change HRMS Oracle password.  
I need to scramble or delete the data (not sure which api?) in Oracle HRMS
Applications. Any advice ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

Is it possible to copy one db to another if the SID is different

[CHAN Chor Ling Catherine (CSC)]

Hi,

Qn : Is it possible to copy one database to another if the source database
name is different from the target database name ? 

I need to clone Oracle Applications 11I from one machine (source
instance:PROD) to another (target instance:TEST). I followed the
instructions on Metalink doc 135792.1 Cloning Oracle Applications Release
11I. Everything works fine until I re-create the controlfile in the target
instance.

In svrmgrl =
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
  GROUP 1 (
'/dg3/oracle/testredo/log01a.dbf',
'/dg4/oracle/testredo/log01b.dbf'
  ) SIZE 10M
  
DATAFILE
  '/dg7/oracle/testdata/system01.dbf',
  '/dg7/oracle/testdata/system02.dbf', 
  ...
  '/dg8/oracle/testdata/ctxd01.dbf',
.
CHARACTER SET US7ASCII
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match given name of
TEST

Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Is it possible to copy one db to another if the SID is differ

[CHAN Chor Ling Catherine (CSC)]

Hi Yen-wee,

I tried but still get the following error message :

CREATE CONTROLFILE SET DATABASE TEST RESETLOGS NOARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match given name of
TEST
ORA-01110: data file 6: '/dg8/oracle/testdata/ctxd01.dbf'

Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])

Regds,
New Bee
-Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, October 09, 2002 3:18 PM
To: CHAN Chor Ling Catherine (CSC)
Subject:RE: Is it possible to copy one db to another
if the SID is differ ent

Hi

Can u try SET instead of REUSE?

CREATE CONTROLFILE SET DATABASE TEST RESETLOGS ARCHIVELOG





-Original Message-
From: CHAN Chor Ling Catherine (CSC)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Is it possible to copy one db to another if the SID
is
different


Hi,

Qn : Is it possible to copy one database to another if the
source database
name is different from the target database name ? 

I need to clone Oracle Applications 11I from one machine
(source
instance:PROD) to another (target instance:TEST). I followed
the
instructions on Metalink doc 135792.1 Cloning Oracle
Applications Release
11I. Everything works fine until I re-create the
controlfile in the target
instance.

In svrmgrl =
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS
ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
  GROUP 1 (
'/dg3/oracle/testredo/log01a.dbf',
'/dg4/oracle/testredo/log01b.dbf'
  ) SIZE 10M
  
DATAFILE
  '/dg7/oracle/testdata/system01.dbf',
  '/dg7/oracle/testdata/system02.dbf', 
  ...
  '/dg8/oracle/testdata/ctxd01.dbf',
.
CHARACTER SET US7ASCII
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS
ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match
given name of
TEST

Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Is it possible to copy one db to another if the SID is differ

[CHAN Chor Ling Catherine (CSC)]

Thanks to those (Venkat, Rajendra and Yen-Wee) who replied. Problem has been
resolved.

Solution :
*   Has to use CREATE CONTROLFILE SET DATABASE TEST RESETLOGS
ARCHIVELOG
*   I forgot to delete old control files.

Thank you so much.

Regds,
New Bee
-Original Message-
From:   Choudhary Rajendra (TTL_LKO)
[mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, October 09, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Is it possible to copy one db to another
if the SID is differ

  Hi, 
You have to recreate the controlfile as CREATE
CONTROLFILE SET
DATABASE TEST RESETLOGS ARCHIVELOG. The new database name
will be TEST .
Pl ensure that the old control files are deleted before
recereating the
controlfile . 
  Regards
  Rajendra

-Original Message-
Sent: Wednesday, October 09, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
different 


Hi,

Qn : Is it possible to copy one database to another if the
source database
name is different from the target database name ? 

I need to clone Oracle Applications 11I from one machine
(source
instance:PROD) to another (target instance:TEST). I followed
the
instructions on Metalink doc 135792.1 Cloning Oracle
Applications Release
11I. Everything works fine until I re-create the
controlfile in the target
instance.

In svrmgrl =
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS
ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
  GROUP 1 (
'/dg3/oracle/testredo/log01a.dbf',
'/dg4/oracle/testredo/log01b.dbf'
  ) SIZE 10M
  
DATAFILE
  '/dg7/oracle/testdata/system01.dbf',
  '/dg7/oracle/testdata/system02.dbf', 
  ...
  '/dg8/oracle/testdata/ctxd01.dbf',
.
CHARACTER SET US7ASCII
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS
ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name PROD in file header does not match
given name of
TEST

Any advice ? Thanks. (Please reply to [EMAIL PROTECTED])

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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.com
-- 
Author: Choudhary Rajendra (TTL_LKO)
  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.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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

RE: Is it possible to copy one db to another if the SID is differ

[CHAN Chor Ling Catherine (CSC)]

Hi,

Thanks for those who replied. I've solved the problem. 
Solution: Use SET database in the CREATE CONTROLFILE command and I forgot to
delete the old control files.

Regds,
New Bee
-Original Message-
From:   Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, October 10, 2002 5:34 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Is it possible to copy one db to another
if the SID is different 

Dear New Bee:

We do this all the time, and the problem you're having is
the one that I tripped over my first time, too.

There is an important word missing from your command.
It's not...
CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS
ARCHIVELOG
...it is ...
CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS
ARCHIVELOG
 ^^^

And when you ALTER DATABASE OPEN you'll also need to say 
RESETLOGS.

HTH,
Mike

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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 Arm Twisting?

[CHAN Chor Ling Catherine (CSC)]

Hi John,

Are you on Oracle Payroll as well ? If yes, is the Oracle Payroll as buggy
as Oracle Human Resources ? The vendor is trying to persuade us to go on
Oracle Payroll and I am hoping that the management will say NO.

Regds,
Catherine
-Original Message-
From:   John Kanagaraj [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, August 15, 2002 4:24 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Arm Twisting?

I agree with Catherine. Oracle Apps (esp. 11i and bleeding
edge versions)
generate about 5 - 6 TARs a day at times at my current
client. However, as
far as other 'simple' applications are concerned, where the
DB is just a
simple repository (of say usernames and passwords for a Web
server), full
Oracle Support is an overkill. An oh, for this kind of
support, my client
had purchased 'Premium Support' that comes with a fixed
number of onsite
days, Weekly TAR review and a special number to call that is
NOT staffed by
the usual 'Run to WebIV for any question' types.

John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com

** The opinions and facts contained in this message are
entirely mine
and do not reflect those of my employer or customers **


-Original Message-
From: CHAN Chor Ling Catherine (CSC)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 8:08 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Arm Twisting?


I guess you are not using Oracle Human Resources
Applications. 
For most of
the patches that we've applied, there are new bugs. It's a
never-ending
applying patches-after-patches ...  We've lost count of the

number of TARs
opened.  The worst part is after applying a patch to solve
a 
bug, the new
problem which was not documented in the readme file always 
emerge itself
after sometime. By then, it's too late to revert back to
the 
old version.
Are we the only company having the problem ? sigh..

Regds,
Catherine
   -Original Message-
   From:   Conboy, Jim
[mailto:[EMAIL PROTECTED]]
   Sent:   Thursday, August 15, 2002 5:54 AM
   To: Multiple recipients of list ORACLE-L
   Subject:RE: Oracle Arm Twisting?

   I've called Oracle for a TAR once in the
past 
18 months.

   Ah, my friend, but you're not using Portal 
9.0.2, are you?
I've opened more TARs in the last few months than the rest
of my Oracle
career.  Bleeding edge, I guess, so maybe its our own
fault.  But
third-party support for this would have stopped the project

before it got
started.

   I agree that its not accurate to generalize
all 
tech support
as nimrods.  There are some very good ones out there, and
even 
the rest at
least have acccess to all the internal notes we can't get
to 
(Gr...why
the hell do they show in metalink searches if we can't see 
them?).  And the
developers, if you can ever get to them, know their stuff
and 
are a pretty
decent bunch.

   Jim

   -Original Message-
   Sent: Wednesday, August 14, 2002 5:18 PM
   To: Multiple recipients of list ORACLE-L


   Well, that's not really fair.  There are a 
number of good
people
   that work for Oracle Support.  True, there
are also some
that
   are subpar, but how often is it necessary to
open a TAR
anymore?

   MetaLink has vastly improved over the past 
couple of years

RE: Oracle Arm Twisting?

[CHAN Chor Ling Catherine (CSC)]

Hi Jay,

Our Oracle HR consultant said that we are to test only the patch readme.txt
Enhanced features as Oracle HR is way too big and it's not possible to
test every form and report. Are you on 11I Oracle HR ? If yes, do you mean
that you test every single form and report ? If yes, how long does it take ?

Regds,
Catherine
-Original Message-
From:   Jay Hostetter
[mailto:[EMAIL PROTECTED]]
Sent:   Thursday, August 15, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Arm Twisting?

Catherine,

  We all feel your pain.

  My only suggestion is to test heavily.  For every hour of
patching that we have, we have several hours of pre-req research and testing
on another server.  You simply can't run this software without a whole
separate environment for testing patches.

  Is there a support group for 11i dbas?

Jay

 [EMAIL PROTECTED] 08/14/02 11:08PM 
I guess you are not using Oracle Human Resources
Applications. For most of
the patches that we've applied, there are new bugs. It's a
never-ending
applying patches-after-patches ...  We've lost count of the
number of TARs
opened.  The worst part is after applying a patch to solve a
bug, the new
problem which was not documented in the readme file always
emerge itself
after sometime. By then, it's too late to revert back to the
old version.
Are we the only company having the problem ? sigh..

Regds,
Catherine
-Original Message-
From:   Conboy, Jim
[mailto:[EMAIL PROTECTED]] 
Sent:   Thursday, August 15, 2002 5:54 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Oracle Arm Twisting?

I've called Oracle for a TAR once in the
past 18 months.

Ah, my friend, but you're not using Portal
9.0.2, are you?
I've opened more TARs in the last few months than the rest
of my Oracle
career.  Bleeding edge, I guess, so maybe its our own fault.
But
third-party support for this would have stopped the project
before it got
started.

I agree that its not accurate to generalize
all tech support
as nimrods.  There are some very good ones out there, and
even the rest at
least have acccess to all the internal notes we can't get to
(Gr...why
the hell do they show in metalink searches if we can't see
them?).  And the
developers, if you can ever get to them, know their stuff
and are a pretty
decent bunch.





**DISCLAIMER
This e-mail message and any files transmitted with it are
intended for the use of the individual or entity to which they are addressed
and may contain information that is privileged, proprietary and
confidential. If you are not the intended recipient, you may not use, copy
or disclose to anyone the message or any information contained in the
message. If you have received this communication in error, please notify the
sender and delete this e-mail message. The contents do not represent the
opinion of DE except to the extent that it relates to their official
business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Hostetter
  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: CHAN Chor Ling Catherine (CSC)
  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

RE: Oracle Arm Twisting?

[CHAN Chor Ling Catherine (CSC)]

: http://www.orafaq.com
-- 
Author: 
  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: Conboy, Jim
  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: CHAN Chor Ling Catherine (CSC)
  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: Which table to check whether my SQL_TRACE is on for the user

[CHAN Chor Ling Catherine (CSC)]

Hi KG,

Is ORADEBUG PEEK an utility that only works in 9I ? Could I use it in the
user account .ie. not sys account ? 
I am using Version Version 8.0.6 and it does not work for me. Please advise.
Thanks.

SQL ORADEBUG peek
unknown command beginning ORADEBUG p... - rest of line ignored.

Regds,
New Bee
-Original Message-
From:   K Gopalakrishnan [mailto: [EMAIL PROTECTED]]
Sent:   Thursday, August 08, 2002 11:18 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Which table to check whether my
SQL_TRACE is on for the user 

Raj:

You are right. But you can find the with PGA dump
or ORADEBUG PEEK..

KG


-Original Message-
Rajendra
Sent: Thursday, August 08, 2002 6:33 AM
To: Multiple recipients of list ORACLE-L
user


Dear 'New Bee',

If I remember correctly, I read an reply by Steve Adams that
this trace flag
is in the PGA (??) so not possible to find.

O Wise Men/Women ... please correct me if I am wrong ...
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect
that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an
art!


-Original Message-
Sent: Wednesday, August 07, 2002 11:08 PM
To: Multiple recipients of list ORACLE-L
user


Hi Dave,

Thanks but the command does not work.

In SQLPLUS,
SQL alter SESSION SET SQL_TRACE=TRUE
  2  /
Session altered.
SQL SHOW PARAMETER SQL_TRACE
unknown SHOW option PARAMETER
unknown SHOW option SQL_TRACE

I am using Oracle Database 8.1.6. Any other suggestions ?
Thanks.

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  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: CHAN Chor Ling Catherine (CSC)
  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: Table Naming Conventions

[CHAN Chor Ling Catherine (CSC)]

Hi Gary,

In our environment, there are many applications in one database. We always
create public synonym for all the tables. To avoid confusion, all the tables
have to be tagged with the application prefix .eg. Student System has the
prefix STD, so the tables will be STD_XXX where XXX is the table name and
the public synonym is STDXXX. We don't have any rules for the table name
XXX.

Hope it helps.

Regds,
Catherine
-Original Message-
From:   Gary Chambers [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, July 31, 2002 4:37 AM
To: Multiple recipients of list ORACLE-L
Subject:Table Naming Conventions

All...

Will some of you please provide some insight on your table
naming
conventions?  I'm in the very early planning stages of what
will likely
be a large and complex schema (IT asset inventory).  I have
a chance to
start it correctly.  TIA

Gary Chambers

//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  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: CHAN Chor Ling Catherine (CSC)
  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).

OT : Apache version

[CHAN Chor Ling Catherine (CSC)]

Hi Guru,

Does anyone know how to find the apache vision in Unix ? Is pkginfo -i
|grep -i apache the correct command to find the apache version ? Please
advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Oracle Applications Development Database Refresh

[CHAN Chor Ling Catherine (CSC)]

 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: CHAN Chor Ling Catherine (CSC)
   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: John Weatherman
   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).
 
 
 begin 666 InterScan_Disclaimer.txt

M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S

M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E

M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL

M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@

M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C

M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA

M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
 M2!B92!I;QE9V%L+B
@268@6]U(AA=F4@F5C96EV960@=AIR!M97-S

M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I

M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)

M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@

M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S

M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL

M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S

M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R

M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
 %;G0N#0H 
 end
 
 -- 
 Please see the official ORACLE-L FAQ:
http://www.orafaq.com
 -- 
 Author: April Wells
   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: John Kanagaraj
  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

RE: OT : Apache version

[CHAN Chor Ling Catherine (CSC)]

Hi Kevin  Nastase,

Thanks. Both methods work. 

$ PATH=/dg2/oracle/testcomn/util/apache/1.3.9/Apache/Apache/bin:$PATH
$ export PATH
$ httpd -v
Server version: Apache/1.3.9 (Unix)
Server built:   Mar 21 2000 19:10:08

Thanks so much.

Regds,
Catherine
-Original Message-
From:   Thomas, Kevin [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, July 09, 2002 10:24 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT : Apache version 

You could just navigate to the directory it's stored in and
it'll be all
over the directory names.

-Original Message-
Sent: 09 July 2002 11:03
To: Multiple recipients of list ORACLE-L


Hi Guru,

Does anyone know how to find the apache vision in Unix ? Is
pkginfo -i
|grep -i apache the correct command to find the apache
version ? Please
advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Thomas, Kevin
  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: CHAN Chor Ling Catherine (CSC)
  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).

How to calculate table size in 8i

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I found an article in metalink 105765.1 How to Determine Approximate Hard
Drive Space Needed for a Specific Table.  The formula for disk space is
simply multiplying the average row length (by analyzing the table) * the
number of rows in the table.  It's very different from Metalink 10640.1
Extent and Block Space Calculation and Usage in V7 Database where it takes
the block header etc in considerations but of course, article 10640.1 is for
Version 7.

How do you gurus calculate table space in Version 8 ?  Please advise.
Thanks.

Regds,
New Bee


Doc ID /help/usaeng/Search/search.html :  Note:105765.1   Content
Type:   TEXT/PLAIN  
Specific Table  Creation Date:  18-APR-2000 
Type:   PROBLEM Last Revision Date: 26-DEC-2000 
Status: PUBLISHED   
Problem Description
---
How can you determine how much disk space is needed for a table?


Solution Description

You can use SQL to determine how much space is needed for the table based
upon the average row length.

1. compute statistics about this table:

   analyze CEUSER.CE_STATEMENT_LINES
   compute statistics;

   Now determine the average row length in bytes:

   select avg_row_len
   from dba_tables
   where table_name=' CE_STATEMENT_LINES';

   AVG_ROW_LEN
   ===
   98


2. Multiple the average row length in bytes by the number of rows you
believe 
   you will need:

   98 (bytes) x 1 records =  98 bytes needed

References
--
For more information on the ANALYSE command, you may wish to refer to: 

Oracle8 SQL Reference Release 8.0, Part No.A58225-01

Also:

Oracle8i SQL Reference Release 8.1.5, Part Number: A67779-01
.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Oracle Applications Development Database Refresh

[CHAN Chor Ling Catherine (CSC)]

 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: 
   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: 
  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: CHAN Chor Ling Catherine (CSC)
  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: Printing a report in landscape mode

[CHAN Chor Ling Catherine (CSC)]

Hi Ahmed,

Try setting the system parameter, Orientation to LANDSCAPE. Hope it helps.

Regds,
Catherine
-Original Message-
From:   Ahmed Gholam Hussain
[mailto:[EMAIL PROTECTED]]
Sent:   Sunday, April 21, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L
Subject:Printing a report in landscape mode 

Dear listers ,

  This may sounds a very trivial question for some of u
.

  I am unable to print my report in landscape mode using
Reports6 ..
Please guide me on how to solve this issue ?



Regards 
Gholam 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ahmed Gholam Hussain
  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: CHAN Chor Ling Catherine (CSC)
  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: a PL/SQL question - how to catch errors without going into ex

[CHAN Chor Ling Catherine (CSC)]

Hi Audrey,

Try this, it will stay in the loop 

i := 1;
while i  10 loop
  for j in (select the_name from the_table into myvar where the_id =
i) loop
  .
  end loop;
end loop;
.

Hope it helps.

Regds,
Catherine

-Original Message-
From:   Andrey Bronfin [mailto:[EMAIL PROTECTED]]
Sent:   Friday, April 05, 2002 2:44 AM
To: Multiple recipients of list ORACLE-L
Subject:a PL/SQL question - how to catch errors without
going into except

Dear gurus !
I'm wondering whtether i can catch an SQL error (from inside a
PL/SQL proc)
without jumping to the EXCEPTION block
OR
is there a way to jump back to the body of the proc from the
EXCEPTION block
(i know that GOTO can not do it).

For example , assume i have users with IDs 1,2,5,6 in my table and i
want to
do some loop like this

i := 1;
while i  10 loop
  select the_name from the_table into myvar where the_id = 1;
end loop;
.

I will be thrown to the EXCEPTION block as soon as i becomes 3.
And i can never go back to the loop from the EXCEPTION block , in
order to
continue looping  ;-(
So , can i just tell PL/SQL something like never mind if U fail
(i.e. an
exception is thrown) , just go to the next iteration ...

I'm wondering if there is something similar to PERL's 
 next if .

Thanks a lot
Andre





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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: CHAN Chor Ling Catherine (CSC)
  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: Follow-up :Long running SQL Problem?

[CHAN Chor Ling Catherine (CSC)]

Hi,

Thanks to those who take the trouble to reply. It's indeed enlightening.
I've learnt a lot from you guys.

Regds,
New Bee
-Original Message-
From:   Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, April 04, 2002 3:54 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Follow-up :Long running SQL Problem?



CHAN Chor Ling Catherine (CSC) wrote:
 
 Hi Gurus,
 
 My senior DBA always tell us that the not in command
sucks and we are all
 encourage to use the select count(*). SQL A is greatly
frowned upon and SQL
 B will be the best.
 
 SQL A :
 SELECT col1,col2
   FROM Table_1
  WHERE (col1,col2) NOT IN (SELECT col3,col4
  FROM Table_2
 WHERE col3 = col1
   AND col4 = col2);
 SQL B :
 SELECT col1,col2
   FROM Table_1 A
  WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE
b.col3=a.col1 AND
 b.col4=a.col2));
 
 Qn : Is it true ? Could someone shed some light ? Please
advise. Thanks.
 
 Regds,
 Catherine
 

Larry has pointed to me off-list that your 'SQL A' query is
indeed
correlated - totally unusual for a 'NOT IN' and, in your
case, such a
case for disaster (couldn't return anything) that I presume
that you
typed it as fast as I read it initially?

Being as lazy as he is :-) here is from Larry's message :

 Also, point her towards Metalink note 28934.1. It contains
a good
 discussion. But I don't agree with the final conclusion to
always use NOT
 EXISTS even though a NOT IN using a HASH AJ is sometimes
much better. The
 only reason for that recommendation was their fear that
many folks don't
 understand how a NOT IN handles nulls in the results set
(returns no rows)
 differently than a NOT EXISTS. A good developer should
know the difference.
 

HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: CHAN Chor Ling Catherine (CSC)
  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: Long running SQL Problem?

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,
 
My senior DBA always tell us that the not in command sucks and we are all
encourage to use the select count(*). SQL A is greatly frowned upon and SQL
B will be the best.
 
SQL A :
SELECT col1,col2 
  FROM Table_1 
 WHERE (col1,col2) NOT IN (SELECT col3,col4 
 FROM Table_2 
WHERE col3 = col1 
  AND col4 = col2); 
SQL B :
SELECT col1,col2 
  FROM Table_1 A
 WHERE (0=(SELECT COUNT(*) FROM Table_2 b WHERE b.col3=a.col1 AND
b.col4=a.col2));
 
Qn : Is it true ? Could someone shed some light ? Please advise. Thanks.
 
Regds,
Catherine

-Original Message-
Sent: Wednesday, March 27, 2002 8:19 PM
To: CHAN Chor Ling Catherine (CSC)



Hello Catherine 

Thanks first of all for your suggestions. 
The indexes were already in exitance before your email, so I did not even
try that. 
But your query and that of Marco van Rooy ran exactly the same number of
seconds. 
They are both basicly the same. 
Marco's looked like this... 

SELECT col1,col2 
  FROM Table_1 
 WHERE (col1,col2) NOT IN (SELECT col3,col4 
 FROM Table_2 
WHERE col3 = col1 
  AND col4 = col2); 

Because both yours and Marcos brought the data back in so short a time
*16sec*, I have not yet experimented with any of the others.

Thanks again 
Rgds 
Denham 

-Original Message- 
mailto:[EMAIL PROTECTED] ] 
Sent: Wednesday, March 27, 2002 2:00 PM 
To: '[EMAIL PROTECTED]' 


Hi Denham, 
  
I would like to know which solution is the fastest. 
  
Regds, 
Catherine 

-Original Message- 
Sent: Wednesday, March 27, 2002 7:44 PM 
To: Multiple recipients of list ORACLE-L 


Hi List 
  
Thank you to everyone who took the time to answer, I never realised that 
there could be so many solutions :) 
  
Rgds 
Denham 

-Original Message- 
Sent: Wednesday, March 27, 2002 10:53 AM 
To: Multiple recipients of list ORACLE-L 



Hello List 

Is there anyone who can give me a solution to this problem. 
It is a sql that runs forever and I eventually have to kill it, both tables 
are large 50 + rows. 
Is there perhaps a quicker more effecient way of doing this. 


SELECT col1,col2 
FROM Table_1 
WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2); 


TIA 
Denham Eva 
Oracle DBA 

  _  

This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - For more information please visit 
 http://www.marshalsoftware.com http://www.marshalsoftware.com 
www.marshalsoftware.com 
  _  


  _  

This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - For more information please visit 
 http://www.marshalsoftware.com http://www.marshalsoftware.com 
www.marshalsoftware.com 
  _  

  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: ORA-600 Error

[CHAN Chor Ling Catherine (CSC)]

Hi John,

Oracle has solved the problem. Change the connect strings in the form server
from http to socket. Thanks.

Regds,
New Bee
-Original Message-
From:   John Kanagaraj [mailto:[EMAIL PROTECTED]]
Sent:   Monday, April 01, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: ORA-600 Error

Hi Catherine,

Depending on your version, and whether you have set the
system profile
'Sign-On:Audit Level' to FORMS, you should be able to view
current online
forms users using 

SELECT USER_NAME, USER_FORM_NAME, RESPONSIBILITY_NAME, TIME,
PID
FROM APPS.FND_SIGNON_AUDIT_VIEW  order by user_name
/

Past history, again depending on whether the above System
profile was set or
not, can be determined by querying the FND_LOGINS,
FND_LOGIN_RESP_FORMS and
FND_USERS. Apologies - I don't have a query on-hand to do
this.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that
is freely
available!

** The opinions and statements above are entirely my own and
not those of my
employer or clients **


 -Original Message-
 From: CHAN Chor Ling Catherine (CSC)
[mailto:[EMAIL PROTECTED]]

 I am trying to gather the events that will led up to the 
 error : who is
 accessing the form and the operations that were attempted 
 that led to the
 error.
 
 Does anyone know the query to list all the user who is 
 accessing the form ?
 
 I tried to use 
 SELECT OSUSER,USERNAME, TERMINAL, COMMAND, SQL_ADDRESS, 
 PREV_SQL_ADDR ,
 MODULE
 FROM V$SESSION WHERE PROGRAM='f60runm@orion (TNS V1-V3)'
 
 OSUSER USERNAME   TERMINAL COMMAND SQL_ADDR
PREV_SQL MODULE
 -- -- -- - 
 -
 orahrmsAPPS  0 8D0F3EB4
8D0F3EB4
 orahrmsAPPS  0 8D0F3EB4
8D0F3EB4 FNDSCAUS
 orahrmsAPPS  0 8D162568
8D162568
 orahrmsAPPS  0 8D162568
8D162568
 orahrmsAPPS  0 8D06ECB8
8D06ECB8 PERWSHRG
 
 It does not work 'cause there are 5 different users with 
 different login
 accessing the form and all I get from the
v$session.username 
 is 'APPS'.
 
 Any advice ? How do U gurus solve the ORA-600 error ?
Please 
 help. Thanks.
 
 Regds,
 New Bee
 
 Contents of form server log file :
 port=9000
 mode=http
 exe=f60webmx
 Choosing default pool 1 for this process...
 1
 Forms environment:
 ORACLE_HOME = /dg2/oracle/nieora/8.0.6
 PATH =

/dg2/oracle/nieora/8.0.6/bin:/dg2/oracle/nieora/8.0.6/bin:/dg2
 /oracle/nieapp

l/fnd/11.5.0/bin:/dg2/oracle/nieappl/ad/11.5.0/bin::/dg2/oracl
 e/nieora/8.0.6

/bin:/usr/ccs/bin:/usr/sbin:/dg2/oracle/niecomn/util/jre/1.1.8
 /bin:/usr/bin
 LD_LIBRARY_PATH =

/dg2/oracle/nieora/8.0.6/lib:/dg2/oracle/niecomn/util/jre/1.1.
 8/lib:/dg2/ora

cle/nieora/8.0.6/lib:/dg2/oracle/nieora/8.0.6/lib:/usr/dt/lib:
 /usr/openwin/l
 ib
 
 Forms listener started on port 9000.
 
 **START PLSQL RUNTIME DUMP
 
 ***Got ORA-600 while running PLSQL***
 
 PACKAGE BODY .FORMS40:
 library unit=d40d60 line=453 opcode=37 static link=0
scope=1
 FP=da971c PC=ef7596cc Page=0 AP=da882c ST=da9724
 DL0=d95da0 GF=d95dd4 DL1=d95db4 DPF=d95dcc DS=d41c8c
DON library unit variable list instantiation
 --  - -
  0   d40d60

RE: Move index to another tablespace

[CHAN Chor Ling Catherine (CSC)]

Hi Ayyappan,

Correct me if I am wrong. I think in 8.1.6, you can use the alter index
command to move an index to a different tablespace 
eg. ALTER INDEX summit.orders_idx REBUILD TABLESPACE new_tablespace_name;

Regds,
New Bee
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, April 02, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Move index to another tablespace

Hi 

U have to rebuild the index only. u can't able to move from
one tablespace
to another like move table.

Regards

Ayyappan.S



This communication contains information, which is
confidential and may also
be privileged. It is for the exclusive use of the intended
recipient(s). If
you are not the intended recipient(s), please note that any
distribution,
printing, copying or use of this communication or the
information in it is
strictly prohibited. If you have received this communication
in error,
please notify the sender immediately and then destroy any
copies of it.
Visit us @

www.ssiworldwide.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: CHAN Chor Ling Catherine (CSC)
  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).

ORA-600 Error

[CHAN Chor Ling Catherine (CSC)]

 3199
 263 3205
 264 3228
 265 3261
 266 3345
 268 3351
 269 3374
 270 3386
 271 3391
 275 3400
 276 3412

PACKAGE BODY ./XAPPCORE
APP_STANDARD:
library unit=dbeb20 line=453 opcode=8 static link=0 scope=1
FP=da869c PC=dcf684 Page=1 AP=da8638 ST=da8708
DL0=d959d8 GF=d95b14 DL1=d95a70 DPF=d95b0c DS=dcc890
   DON library unit variable list instantiation
--  - -
 0   dbeb20d95b14d95b44
 1
 2
 3
 4   d4bfe0   103401c   1033e08
 5   d37a28   1032a8c   10329bc
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18   dd848c   103459c   103430c
19
20
21
22
23
24
25
26
27
28
29
30
31  1037db8   1034e5c   1034bfc
32
33
34
35
36
37   cd7214 0d95884
   scopeframe
 
   2   da869c
   10
version=43123476 instantiation size=312
exception id errorDON offset  beginendDID
- -- - -- -- -- -- --
0 100501 0  0587563586
1 100501 0  0   1228   1115   1227
line pcode offset
 
 604   14
 615   28
 616   50
 617   72
 618   94
 622  116
 625  138
 629  160
 632  184
 636  208
 640  232
 644  255
 648  278
 651  366
   7
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

ORA-01000: maximum open cursors exceeded

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

Every week, we do a logical export of the whole production database. It used
to work until I encounter the ORA-01000: maximum open cursors exceeded

Command : exp userid='system/system_pwd' file=$ORA_EXP_FILE grants=y rows=y
constraints=y compress=y full=y inctype=complete log=$ORA_EXP_LOG
Error message :
Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0
- Production
With the Partitioning option
JServer Release 8.1.6.1.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR
character set

About to export the entire database ...
. exporting tablespace definitions
EXP-8: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
EXP-0: Export terminated unsuccessfully

Qn :
*   Before exporting, we startup the database in restrict mode. Is it
the same for you gurus out there ?
*   If I were to increase the cursor, how many should I increase to
(Current value=300) ?

Please help. TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Long running SQL Problem?

[CHAN Chor Ling Catherine (CSC)]

Hi Denham,
 
Suggestion 1) Perhaps you may create an index for table_1 (col1,col2) and
table_2 (col3,col4)  
Suggestion 2) Try 
SELECT col1,col2 
FROM Table_1 
WHERE (0=(select count(*) from table_2 where
col3=col1 and col4=col2))
 
Hope it helps.
 
Regds,
Catherine

-Original Message-
Sent: Wednesday, March 27, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L



Hello List 

Is there anyone who can give me a solution to this problem. 
It is a sql that runs forever and I eventually have to kill it, both tables
are large 50 + rows. 
Is there perhaps a quicker more effecient way of doing this. 


SELECT col1,col2 
FROM Table_1 
WHERE (col1,col2) NOT IN (SELECT col3,col4 FROM Table_2); 


TIA 
Denham Eva 
Oracle DBA 

  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
http://www.marshalsoftware.com www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: How to duplicate production database onto development box

[CHAN Chor Ling Catherine (CSC)]

Hi,

Does anyone know whether I could duplicate the Oracle HRMS Applications
using the same methods as described ? I understand that some of the Oracle
Applications tables hardcode the server name etc. Has anyone done it before
? I need to migrate my production Oracle HRMS Apps database to a more
powerful machine. 

TIA

Regds,
New Bee
-Original Message-
From:   Marc Cure [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, March 27, 2002 4:16 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: How to duplicate production database
onto development box

Is there any need to create a standby database in this case?
My procedure
for copying production to development is:

1. alter database backup controlfile to trace; (in
production)
2. Restore a production backup (either hot or cold) to the
development
server
3. Update database name and filenames in the controlfile
script from step 1,
as required
4. Run script from step 3 on development server to create
new controlfiles
5. Recover new development database up to desired point in
time using
archived redo from production
6. Open the new development database with resetlogs

This approach allows me to rename the database and the
datafiles (if the
datafiles need to be placed differently on the development
server than in
production, for example) in one step, rather than manually
renaming 50+
datafiles in a standby database, and then recovering,
activating, and
renaming that database.

Marc Cure
Oracle DBA, OCP


-Original Message-
Sent: Tuesday, March 26, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L


I use a hot backup to create a standby database then apply
logs to the point
I want to get a copy of production of a specific time.

Then you can rename the database if you want to.
-Original Message-
Sent: Tuesday, March 26, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Just copy the files over and recreate the control file.

Abraham
-Original Message-
Sent: Tuesday, March 26, 2002 7:48 AM
To: Multiple recipients of list ORACLE-L


Hi!
We want to put an exact copy of our production database
(approx. 200 GB)
onto a development box. What would be the best way to
achieve this?
Export/import would take kinda long... ;)
Would transportable tablespaces be the way to go?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marc Cure
  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: CHAN Chor Ling Catherine (CSC)
  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: How to duplicate production database onto development box

[CHAN Chor Ling Catherine (CSC)]

(approx. 200 GB)
onto a development box. What would be the
best way to
achieve this?
Export/import would take kinda long... ;)
Would transportable tablespaces be the way
to go?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut

-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Marc Cure
  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: CHAN Chor Ling Catherine (CSC)
  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: Khedr, Waleed
  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: CHAN Chor Ling Catherine (CSC)
  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).

OT: Oracle HRMS Applications - Cannot view concurrent request ou

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

We encountered the error FS-CANT OPEN TMPFILE when we tried to view the
concurrent request report. Yesterday, we can view any report but not today.
The only thing that's different is that we run the purge obselete workflow
runtime data concurrent program this morning but it should not affect the
view of report, right ? Please help. Thanks.

Desperate DBA :(
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Oracle HRMS Applications - Cannot view concurrent request ou

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

The problem has been resolved. Not enough disk space in the /var/tmp
directory.

Regds,
ChorLing
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Tuesday, March 26, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: Oracle HRMS Applications - Cannot view
concurrent request ou

Hi Gurus,

We encountered the error FS-CANT OPEN TMPFILE when we
tried to view the
concurrent request report. Yesterday, we can view any report
but not today.
The only thing that's different is that we run the purge
obselete workflow
runtime data concurrent program this morning but it should
not affect the
view of report, right ? Please help. Thanks.

Desperate DBA :(
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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: Concatenating formated number and date doesn't work

[CHAN Chor Ling Catherine (CSC)]

Hi Aleem,
 
I think it's because of the space in front. Try SELECT
';'||TO_CHAR(12345,'099')||';' from dual and you will notice that there
is a space in front.
 
  1* SELECT  ';'||TO_CHAR(12345,'099')||';' from dual
SQL /
 
';'||TO_CH
--
; 0012345;
 
The problem does not lies in TO_CHAR( SysDate, 'MMDD' ).  Hope it helps.
 
Regds,
Catherine

-Original Message-
Sent: Tuesday, March 26, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L



Hi,

 

In a database procedure that accepts employee_ID as numeric parameter I have
the following code that doesn't work together, it however works separatly, I
wonder why?

 

PROCEDURE abc ( emp_ID IN NUMBER := 12345 )

AS

  Emp_Char_ID VARCHAR2(7);

  Bar_Char_Date VARCHAR2(8);

  Emp_Bar_Code VARCHAR2(15);

BEGIN

  Emp_Char_ID := TO_CHAR( emp_id, '099' ) 

  Bar_Char_Date := TO_CHAR( SysDate, 'MMDD' );

  Emp_bar_code :=  Emp_Char_ID || Bar_Char_Date;

  /* The concatenation line compiles fine, but at execution time gives
error:  ORA-06502: PL/SQL: numeric or value error  */

  UPDATE Employee SET Bar_Code = Emp_Bar_Code WHERE Employee_ID = emp_id;

END;

 

The same procedure works fine after the following modifications

Removed format mask on emp_id (First line of the BEGIN section)

Modified the update statement and used LPAD( Emp_Bar_Code, 15, '0')

The question is why the formatted number conversion gives error in
concatenation with date converted to character.

 

TIA!

 

Aleem

 

-Original Message-
Sent: Tuesday, March 26, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L

 


I suspect that you need a new version of Veritas Volume manager, I would
check around the Veritas website for info. or there is a driver you need to
load in the boot of the installation  process. 
If you are still mystified try asking your question over on the sunmangers
list. www.sunmanagers.org 

you almost certainly will find an answer there 


Cheers 



--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
   Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

   - Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision

=









 

CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] 
Sent by: [EMAIL PROTECTED] 

26/03/2002 11:33 AM 
Please respond to ORACLE-L 


To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] 
cc: 
Fax to: 
Subject:OT : Upgrade Unix OS with Veritas Volumn Manager




Hi Unix Gurus,

My UNIX administrator has to upgrade the OS from 5.6 to 5.8.  We are using
Veritas Volumn Manager.  The upgrade fails because we are not familiar with
Veritas Volumn Manager. Has anyone upgraded SUN-Solaris Unix OS from 5.6 to
5.8 with Veritas Volumn Manager ? Please help. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
 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).




-- 
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please delete
it and notify the sender. The contents of this e-mail are the opinion of the
writer only and are not endorsed by the Mincom Group of companies unless
expressly stated otherwise.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

OT : Upgrade Unix OS with Veritas Volumn Manager

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

My UNIX administrator has to upgrade the OS from 5.6 to 5.8.  We are using
Veritas Volumn Manager.  The upgrade fails because we are not familiar with
Veritas Volumn Manager. Has anyone upgraded SUN-Solaris Unix OS from 5.6 to
5.8 with Veritas Volumn Manager ? Please help. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CASE under Oracle8i

[CHAN Chor Ling Catherine (CSC)]

Hi Jonathan,

I am using Oracle8i Enterprise Edition Release 8.1.6.1.0 

SQL SET SERVEROUTPUT ON
SQL EDIT
Wrote file afiedt.buf

  1  DECLARE
  2 dual_message VARCHAR2(20);
  3  BEGIN
  4 SELECT CASE
  5 WHEN DUMMY='X' THEN 'Dual is OK'
  6 ELSE 'Dual is messed up'
  7 END INTO dual_message
  8 FROM DUAL;
  9 DBMS_OUTPUT.PUT_LINE(dual_message);
 10* END;
SQL /
   SELECT CASE
  *
ERROR at line 4:
ORA-06550: line 4, column 11:
PLS-00103: Encountered the symbol CASE when expecting one of the
following:
( * - + all mod null an identifier
a double-quoted delimited-identifier a bind variable
table avg count current distinct max min prior sql stddev sum
unique variance execute the forall time timestamp interval
date a string literal with character set specification
a number a single-quoted SQL string

Hope it helps.

Regds,
Catherine
-Original Message-
From:   Jonathan Gennick [mailto:[EMAIL PROTECTED]]
Sent:   Monday, March 25, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Subject:CASE under Oracle8i

If you run Oracle8i, and could conveniently test a couple of
statements for me, I'd appreciate it.

First, I believe the following should work under Oracle8i:

SELECT CASE 
WHEN DUMMY='X' THEN 'Dual is OK'
ELSE 'Dual is messed up'
END
FROM DUAL;

I'm less certain about the following, which I vagualy recall
hearing might not work under Oracle8i, but which does work
under Oracle9i:

DECLARE
   dual_message VARCHAR2(20);
BEGIN
   SELECT CASE 
   WHEN DUMMY='X' THEN 'Dual is OK'
   ELSE 'Dual is messed up'
   END INTO dual_message
   FROM DUAL;
   DBMS_OUTPUT.PUT_LINE(dual_message);
END;

Be sure to SET SERVEROUTPUT ON before executing the above.
Otherwise you won't see the results.

The point of all this is that I seem to recall hearing that,
while SQL in 8i supported the CASE statement, that SQL
within PL/SQL did not. I'm trying to verify the truth or
falsity if that statement. 

Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED]
http://Gennick.com * http://MichiganWaterfalls.com *
http://ValleySpur.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  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: CHAN Chor Ling Catherine (CSC)
  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: CPU usage for each oracle instance

[CHAN Chor Ling Catherine (CSC)]

Hi Anne,

Maybe you can try /usr/ucb/ps -aux in Unix to find the CPU usage of the
instance processes.

For example : 
Thu Mar 21 15:45:00 SGT 2002
USER   PID %CPU %MEM   SZ  RSS TT   SSTART  TIME COMMAND
orahrms   7312  6.4 10.0421864406560 ?S 14:29:34  3:47 oracleTEST
(LOCAL=

Hope it helps.

Regds,
New Bee
-Original Message-
From:   Anne Yu [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, March 21, 2002 12:49 AM
To: Multiple recipients of list ORACLE-L
Subject:CPU usage for each oracle instance


Hey list, In the system accounting report, I can get the
total CPU usage
for ORACLE.  However, I have 7 instances on this box.  How
can I get the
total CPU usage for each Oracle instance?Any ideas?


Million thanks,



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anne Yu
  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: CHAN Chor Ling Catherine (CSC)
  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: OT : Unix script to monitor log file size/disk space

[CHAN Chor Ling Catherine (CSC)]

Hi Radim,

We are using Sun Solaris Version 2.6 right now. By this weekend, we'll be
upgrading our OS to Version 2.8.  I am very interested in your script. Could
U send your scripts to me? Thank you so much.

Regds,
New Bee
-Original Message-
From:   Radim J. [mailto:[EMAIL PROTECTED]]
Sent:   Friday, March 22, 2002 5:13 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT : Unix script to monitor log file
size/disk space

Hi,

What version of unix do you use ? I use this script on HP.
If you want I
can send it to you.

Radim 

-Original Message-
Ling Catherine (CSC)
Sent: Wednesday, March 13, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

Does anyone have the unix script to monitor disk space or a
certain file
? For example, if the disk space is more than 80%, send an
email to the
administrator or if the log file is too huge, email the log
file to the
administrator and truncate the file etc .

Please help. Thanks.

Regds,
New Bee in Unix
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Radim J.
  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: CHAN Chor Ling Catherine (CSC)
  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: Oracle CERT Advisory

[CHAN Chor Ling Catherine (CSC)]

Hi,

I searched the metalink for vulnerability with Oracle 8I database and only
found the article below :

Doc ID /help/usaeng/Search/search.html :  Note:151292.1   Content
Type:   TEXT/PLAIN  
Fragmentation AttackCreation Date:  02-JUL-2001 
Type:   ALERT   Last Revision Date: 03-FEB-2002 

Besides this article, is there any patch that one should apply for the
Oracle 8I database ? Please advise. Thanks.

Regds,
New Bee
-Original Message-
From:   Ray Stell [mailto:[EMAIL PROTECTED]]
Sent:   Saturday, March 16, 2002 1:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle CERT Advisory

On Fri, Mar 15, 2002 at 04:08:37AM -0800, Boivin, Patrice J
wrote:
 http://www.cert.org/advisories/CA-2002-08.html
 
-- 

At the top of this page it lists 8i Database in the Systems
Affected.
But there are no entries for 8i in the advisory.  I called
CERT
and they said, hmmm  I'm waiting on a more detailed
report
from them.  I'll post it when they reply. 

===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC
28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  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: CHAN Chor Ling Catherine (CSC)
  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: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

[CHAN Chor Ling Catherine (CSC)]

 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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: DENNIS WILLIAMS
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

OT : Unix script to monitor log file size/disk space

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

Does anyone have the unix script to monitor disk space or a certain file ?
For example, if the disk space is more than 80%, send an email to the
administrator or if the log file is too huge, email the log file to the
administrator and truncate the file etc .

Please help. Thanks.

Regds,
New Bee in Unix
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

Upgrade OS for database 8.1.6

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

My test database 8.1.6 resides in Unix machine. We are supposed to upgrade
the Unix OS from 5.6 to 5.8 for our Oracle HRMS V11.5.1.
There are some problems with the OS upgrade and for some reasons, the Unix
administrator cannot restore back the OS. He has tried to install a new copy
of the OS 5.8 and now I cannot start up my database. The error message is
below 

$ /dg5/app/oracle/testcomn/admin/scripts/addbctl.sh start

You are running addbctl.sh version 115.0

Starting the database TEST ...


SQL*Plus: Release 8.1.6.0.0 - Production on Thu Mar 7
10:14:23 2002

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to an idle instance.
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
Disconnected

addbctl.sh: exiting with status 0


I am thinking of asking him to install a fresh copy of the OS 5.6 ? Any
advice ? Please help. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Upgrade OS for database 8.1.6

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

We've solved the problem. Some of the unix Kernel parameters are not set
properly. Thanks.

Regds,
New Bee
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Thursday, March 07, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Subject:Upgrade OS for database 8.1.6

Hi Gurus,

My test database 8.1.6 resides in Unix machine. We are
supposed to upgrade
the Unix OS from 5.6 to 5.8 for our Oracle HRMS V11.5.1.
There are some problems with the OS upgrade and for some
reasons, the Unix
administrator cannot restore back the OS. He has tried to
install a new copy
of the OS 5.8 and now I cannot start up my database. The
error message is
below 

$
/dg5/app/oracle/testcomn/admin/scripts/addbctl.sh start

You are running addbctl.sh version 115.0

Starting the database TEST ...


SQL*Plus: Release 8.1.6.0.0 - Production on
Thu Mar 7
10:14:23 2002

(c) Copyright 1999 Oracle Corporation.  All
rights reserved.

Connected to an idle instance.
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
Disconnected

addbctl.sh: exiting with status 0


I am thinking of asking him to install a fresh copy of the
OS 5.6 ? Any
advice ? Please help. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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: Error in relinking executables after Upgrade Unix OS from 2.6

[CHAN Chor Ling Catherine (CSC)]

Hi Hemant,

Thanks for your help. I've checked the metalink for Installation Guide. I
found a copy Oracle8I Release Notes Release 3 (8.1.7) for Sun SPARC solaris
Part Number A86565-01. Our OS has the following SUNWarc, SUNWbtool, SUNWhea,
SUNWlibm, SUNWlibms, SUNWsprot, SUNWtoo packages but the executables ld and
make are not in the /usr/ccs/bin directory.

Our UNIX administrator is trying to add in another package SUNWbtoox.
Hopefully, make and ld will be installed in the /usr/ccs/bin directory. I
will keep you inform. 

Thanks.

Regds,
Chorling
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Monday, March 04, 2002 2:14 PM
To: CHAN Chor Ling Catherine (CSC)
Subject:RE: Error in relinking executables after Upgrade
Unix OS from 2.6 TO


Check the Oracle8/8i Installation Guide for Solaris.

Looking up the Oracle8i 8.1.7 Installation Guide for Solaris (which
initially
mentioned only Solaris 2.6 and 7) :  The package names
would be similar in Solaris 8.

Operating System Patch
Use the latest kernel patch from Sun Microsystems. Sun
provides patch information at:
http://sunsolve.sun.com
Solaris 2.6 requires at least kernel jumbo patch revision
#105181-15 for successful installation of Release 3 (8.1.7).

See Table 1:???€??€???€€€?€??
Table 1:???€?€???€€€?€

?age 1-14 for patches required on Solaris for the JRE

Operating System Packages
SUNWarc, SUNWbtool, SUNWhea, SUNWlibm, SUNWlibms,
SUNWsprot, SUNWtoo

Window Manager
X-windows must be installed on the system from where the
Installer is run. Use any Sun-supported X-windows server, for
example, dtwm, twm, olwm, that supports Motif.
Character mode installs are not supported for Release 3 (8.1.7).

Required Executables
The following executables must be present in the
/usr/ccs/bin directory: make, ar, ld, nm.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  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: Error in relinking executables after Upgrade Unix OS from 2.6

[CHAN Chor Ling Catherine (CSC)]

Hi Hemant,

My Solaris vendor does not know the package name of SVR4 linker, hence he
cannot install.  Could you tell me the package name of SVR4 linker ? Please
help. Thanks.

Regds,
New Bee
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Monday, March 04, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Error in relinking executables after
Upgrade Unix OS from 2.6 TO

The relink expects to use the linker from /usr/ccs/bin.

/usr/ucb and /usr/ccs/bin are different.

/usr/ccs* contains the SVR4 distribution.
/usr/ucb* contain the  BSD distribution.

In fact, /usr/ucb/ld  [on my machine] is a shell-script
which
sets the LD_RUN_PATH and defines /usr/ucblib first,
ie it changes the order of the libraries.

If you have copied /usr/ucb/ld over to /usr/ccs/bin/ld   you
will see
that the program is calling itself --- it would be forking
multiple
processes
till it runs out of swap space.

You should be using /usr/ccs/bin/ld.  Oracle requires the
SVR4 linker.
Ask your Solaris vendor to install it.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
04/03/2002 10:48 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]   
 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) 
 Subject: Error in relinking executables after
Upgrade Unix OS from 2.6 TO 











Hi Gurus,

I upgraded my UNIX OS from 2.6 to 5.8 for our HRMS 11I
V11.5.1 and now
encountered problem when I relink my executables.

The instructions from Oracle support for Upgrade is
= run the environment file ($ . $APPL_TOP/APPSORA.env) =
OK
= relink adadmin using adrelink ($ adrelink.sh force=y ad
adadmin) =
ERROR ENCOUNTERED
= use adadmin to relink all executables ($ adadmin-Relink
Applications
Programs) = ERROR ENCOUNTERED

1st error encountered  Adrelink: the directory
containing the
make
command must be
in your path.
SolutionFor Solaris 2.6, the default directory for
ld and make is
in
/usr/ccs/bin. Since the OS has been upgraded to 5.8, the
ld program is
only found in /usr/ucb directory and make program in
/usr/local/bin
directory.
I've copied the make and ld programs to the directory
/usr/ccs/bin.

2nd error encountered  /usr/ccs/bin/ld: cannot fork:
no swap space
See error messages above (also recorded in log file) for
possible
reasons for the failure. Also, please check that the Unix
userid
running adrelink has read, write, and execute permissions
on the directory /dg5/app/oracle/testappl/ad/11.5.0/bin,
and that there is sufficient space remaining on the disk
partition
containing your Oracle Applications installation.

I've 1.5GB swap space and I've read,write and execute
permission on the
directory /dg5/app/oracle/testappl/ad/11.5.0/bin
My physical memory is $ df -k
Filesystem kbytes used avail capacity Mounted on
/dev/dsk/c0t1d0s0 1302231 929196 320946 75% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
mnttab 0 0 0 0% /etc/mnttab
/dev/dsk/c0t1d0s6 1326439 88963 1184419 7% /var
/dev/dsk/c0t0d0s0 26255015 23017221 2975244 89% /dg1
/dev/dsk/c1t0d0s0 1322803 53282 1216609 5% /opt
/dev/dsk/c1t0d0s1 30122920 3018192 26803499 11% /dg4
/dev/dsk/c1t1d0s0 35292880 15626245 19313707 45% /dg5
/dev/dsk/c1t2d0s0 35292880 24654450 10285502 71% /dg6
/dev/dsk/c1t3d0s0 35292880 19057633 15882319 55% /dg7
swap 1517552 24 1517528 1% /tmp
/dev/dsk/c0t1d0s7 9975 46 8932 1% /export/home

Qn: Has anyone upgraded his/her OS from 2.6 to 5.8 before
for HRMS V11.5.1
?
How much swap space is needed for the program to compile

RE: Disable certain users from login to database while applying H

[CHAN Chor Ling Catherine (CSC)]

Hi Hemant,

Thanks for your earlier reply. 

I will not lock APPS, APPLSYS and APPLSYSPUB accounts as these accounts are
needed for the HR patches. 

In my company, we do have in-house applications which use client-server
forms/reports to access (read-only privilege) the HR tables. We created user
accounts for these applications. The last time when I applied HR patches, I
encountered deadlock despite shutting down the concurrent manager, forms
server, report server , apache server, web db 2.5 server etc.  I suspected
some of my users were accessing the HR tables via sqlplus/client-server
forms/reports, thereby causing deadlocks.

This time round, I will lock the user accounts which use client-server
forms/reports to access (read-only privilege) the HR tables. 

Hope it helps. 

Regds,
Catherine
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, February 20, 2002 4:44 PM
To: CHAN Chor Ling Catherine (CSC)
Cc: [EMAIL PROTECTED]
Subject:RE: Disable certain users from login to
database while applying H


Catherine

Which database accounts will you lock ?  You can't lock
APPS, APPLSYS and
APPLSYSPUB
as APPLSYSPUB and APPS will be used by all users and APPS
and APPLSYS will
be used by the patch.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
19/02/2002 05:23 PM
Sent by: [EMAIL PROTECTED]




Hi Gurus,

Thanks for replying to my qn.

Startup Database in Restricted mode will not work (for
more details, pls
refer to the email below).

The following solutions :
1.  Database ON LOGON Trigger = don't know whether it will
work
2.  Lock Database Account = I am going to use this
solution.
3.  Change Database Account Password = I believe it will
work

In our Oracle HR, we also support oracle client-server
forms/reports, so
I've to disable their accounts so that they do not access
the HR database
using sqlplus/forms/reports while I am applying patches.


Regds,
Catherine
 -Original Message-
 From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
 Sent:  Tuesday, February 19,
2002 2:13 PM
 To:   Multiple recipients of list
ORACLE-L
 Subject:   Re: Disable certain
users from login to
database while applying Human


 As you are talking of Oracle Apps, NONE
of the
suggested
solutions :
 1.  Database ON LOGON Trigger
 2.  Lock Database Account
 3.  Change Database Account Password
 4.  Startup Database in Restricted mode
 would work.

 The users connect to the Database in
the APPS schema
-- this
is the
 universal
 schema that Oracle Apps uses.  The
Patch requires APPS
so
Restricted
 doesn't
 help (unless you grant Restricted to
APPS in which
case all
the users can
 logon).
 Ditto about locking, changing password
or writing a
trigger
on the APPS
 schema.

 What you can do are :
 1. Shutdown the Apache server for the
Self-Service
Modules
 2. Shutdown the Forms server for the
Forms Module
 3. Shutdown the Concurrent Managers.

 All of the above would affect ALL
users.

 Alternatively, login to the Application
as the System
Administrator user
 and
 change the Application User Passwords
for the users
whom you
want disabled.
 Change the passwords back to a default
(WELCOME

Web DB 2.5 listener always hung for Oracle HRMS applications V11.

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

We are running Oracle HRMS Applications 11I (V11.5.1) in two E450 sun
servers. OS is Solaris 2.6

1st server contains the database, concurrent manager and report server.
2nd server contains the apache listener, TCF SERVER, Web DB 2.5 listener,
Web DB 2.2 Listener and Form server listener. 

Qn : The Web DB 2.5 listener always hung. Is there a way to solve the
problem ? Is anyone having the same configurations as me with no problem ?
Please help. Thanks

I've checked the network roundtrip between the 2 servers using
tnsping=fast, no bottlenecks
I've checked the number of processes in the database : it's only 26
concurrent users (26processes in the init.ora)=ok
I've checked the 1st and 2nd server resources using vmstat and iostat :
There are enough memory = no bottlenecks

Oracle consultants claim that there is bug in the Web DB 2.5 listener
(Version is adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52). The only solution
is to bounce the web listener when the problem arises.

We even schedule a job to bounce the listener at 7am and 1pm but that does
not solve the problem. Sometimes, I still have to bounce the web listener
manually when user reports the problem. 

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Web DB 2.5 listener always hung for Oracle HRMS applications

[CHAN Chor Ling Catherine (CSC)]

Hi Hemant,

We use the at command to startup all our form server/report server/webdb
listener etc so that even if we were to logout of the telnet session where
the WebDB listener is started. The form server/report server/listener will
not hung/died because the parent shell has died.

 Why don't you migrate from WebDB to Apache ?
I've found the document in metalink Note:154666.1 = Moving virtual
directory mappings from WebDB to iAS. Thanks.

Qn : Has anyone using Oracle HRMS V11.5.1 migrated from WebDB to Apache
before ? How's the performance ? Does the apache listener hung ? Please
advise. Thank



-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Thursday, February 21, 2002 11:10 AM
To: CHAN Chor Ling Catherine (CSC)
Cc: [EMAIL PROTECTED]
Subject:Re: Web DB 2.5 listener always hung for
Oracle HRMS applications V11.


Catherine,


Why don't you migrate from WebDB to Apache ?.  There is
excellent
documentation
on migrating from WebDB to Apache for 11i.

Your WebDB listener could be hung if it is running in the
wrong shell --
eg if you
logout of the telnet session where the WebDB listener was
started, you will
see
subsequents requests to the listener failing.  This is
because the parent
shell
has died.

If you are starting it from the Bourne shell, try switching
to Korn shell
before starting it
(or vice versa).
Check whether the startup script calls nohup wdblsnr
hostname
portnumber .

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
21/02/2002 10:13 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]   
 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) 
 Subject: Web DB 2.5 listener always hung for
Oracle HRMS applications 
 V11.












Hi Gurus,

We are running Oracle HRMS Applications 11I (V11.5.1) in two
E450 sun
servers. OS is Solaris 2.6

1st server contains the database, concurrent manager and
report server.
2nd server contains the apache listener, TCF SERVER, Web DB
2.5 listener,
Web DB 2.2 Listener and Form server listener.

Qn : The Web DB 2.5 listener always hung. Is there a way to
solve the
problem ? Is anyone having the same configurations as me
with no problem ?
Please help. Thanks

I've checked the network roundtrip between the 2 servers
using
tnsping=fast, no bottlenecks
I've checked the number of processes in the database : it's
only 26
concurrent users (26processes in the init.ora)=ok
I've checked the 1st and 2nd server resources using vmstat
and iostat :
There are enough memory = no bottlenecks

Oracle consultants claim that there is bug in the Web DB 2.5
listener
(Version is adwdbctl.sh.UNIX 115.1 2000/05/01 17:35:52).
The only
solution
is to bounce the web listener when the problem arises.

We even schedule a job to bounce the listener at 7am and 1pm
but that does
not solve the problem. Sometimes, I still have to bounce the
web listener
manually when user reports the problem.

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  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

RE: Web DB 2.5 listener always hung for Oracle HRMS applications

[CHAN Chor Ling Catherine (CSC)]

Hi Hemant,

Thanks for supplying the correct article number. I'll look into it.

Even if my web 2.5 listener is up and running (see below), my users still
cannot logon to the Oracle Applications. The listener just hung.

# ps -ef | grep 8000
 orahrms  4406  4404  0 07:25:03 ?0:03 wdblsnr orion 8000
 orahrms  4404 1  0 07:25:03 ?0:00 /bin/csh -f
/dg2/oracle/nieora/8.0.6/bin/wdbstart orion 8000
 orahrms  7279  7271  0 13:53:45 pts/10:00 grep 8000

The problem can be solved by bouncing the listener. 

Qn : Has anyone using Oracle HRMS V11.5.1 migrated from WebDB to Apache
listener before ? How's the performance ? Does the apache listener hung ?
Please advise. Thank you.

Regds,
Catherine
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Thursday, February 21, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Web DB 2.5 listener always hung for
Oracle HRMS applicationsV11.

Catherine,

You have the wrong note.  Look up Note 119873.1 titled
Apache Single
Listener Configuration for Applications 11.5.1
I don't know how you are using the at command to startup
the servers.

I didn't suggest that the forms server and reports server
die.  I was
talking of the WebDB listener specifically !
WebDB2.2 handles forms sign-ons while 2.5 handles online
help and personal
home page and self-service modules.
Note 113254.1 refers to the Forms Server/Reports Server/
WebDB 2.2 dying
because of the
wrong shell.  You need to check the shell your WebDB 2.5
runs from. Note
144400.1 covers
WebDB 2.5 as well.

Do a ps -ef to see if the process is running.  Remember
that WebDB 2.2
and 2.5 have
different startup scripts and process names.

I do remember seeing WebDB 2.5 die by itself
occassionally.  We had a
cron job running
the webdb startup script periodically.


Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
21/02/2002 12:14 PM


 To: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group@ST Domain, 
 '[EMAIL PROTECTED]' [EMAIL PROTECTED]

 cc:

 Subject: RE: Web DB 2.5 listener always hung
for Oracle HRMS applications 
V11.












Hi Hemant,

Please ignore my earlier email.

We use the at command to startup all our form server/report
server/webdb
listener etc so that even if we were to logout of the telnet
session where
the WebDB listener is started. The form server/report
server/listener will
not hung/died because the parent shell has died.

 Why don't you migrate from WebDB to Apache ?
I've found the document in metalink Note:154666.1 = Moving
virtual
directory mappings from WebDB to iAS. Thanks.

Qn : Has anyone using Oracle HRMS V11.5.1 migrated from
WebDB to Apache
before ? How's the performance ? Does the apache listener
hung ? Please
advise. Thank you.

Regds,
Catherine
 -Original Message-
 From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
 Sent:  Thursday, February 21,
2002 11:08 AM
 To:   Multiple recipients of list
ORACLE-L
 Subject:   Re: Web DB 2.5 listener
always hung for
Oracle HRMS applications V11.


 Catherine,


 Why don't you migrate from WebDB to
Apache ?.  There
is
excellent
 documentation
 on migrating from WebDB to Apache for
11i.

 Your WebDB listener could be hung if
it is running
in the
wrong shell --
 eg if you
 logout of the telnet session where the
WebDB listener
was
started, you will
 see

RE: Disable certain users from login to database while applying H

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

Thanks for replying to my qn.

Startup Database in Restricted mode will not work (for more details, pls
refer to the email below).

The following solutions :
1.  Database ON LOGON Trigger = don't know whether it will work
2.  Lock Database Account = I am going to use this solution.
3.  Change Database Account Password = I believe it will work

In our Oracle HR, we also support oracle client-server forms/reports, so
I've to disable their accounts so that they do not access the HR database
using sqlplus/forms/reports while I am applying patches.


Regds,
Catherine
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, February 19, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disable certain users from login to
database while applying Human


As you are talking of Oracle Apps, NONE of the suggested
solutions :
1.  Database ON LOGON Trigger
2.  Lock Database Account
3.  Change Database Account Password
4.  Startup Database in Restricted mode
would work.

The users connect to the Database in the APPS schema -- this
is the
universal
schema that Oracle Apps uses.  The Patch requires APPS so
Restricted
doesn't
help (unless you grant Restricted to APPS in which case all
the users can
logon).
Ditto about locking, changing password or writing a trigger
on the APPS
schema.

What you can do are :
1. Shutdown the Apache server for the Self-Service Modules
2. Shutdown the Forms server for the Forms Module
3. Shutdown the Concurrent Managers.

All of the above would affect ALL users.

Alternatively, login to the Application as the System
Administrator user
and
change the Application User Passwords for the users whom you
want disabled.
Change the passwords back to a default (WELCOME) later.

However, what you SHOULD do, per Oracle Support, is 1.
Shutdown 2. Shutdown
3. Shutdown
as I have listed above.
If you are familiar with Oracle Applications Patching and
are comfortable
with reading
the Patch drivers, you can figure out what database objects
are being
modified/updated/created
and what Forms/Reports/HTML etc files are being
modified/created by the
patch.
Then you can take an intelligent decision  should you
allow users to
logon when
applying the patch ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
18/02/2002 03:28 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]   
 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) 
 Subject: Disable certain users from login to
database while applying  
 Human












Hi Gurus,

I need to disable certain users from login to database while
I apply the
Human Resources Patches for our Oracle HR 11i Applications.
Which is the best way to do it ? Should I write on-logon
trigger to disable
or should I take away their privileges to logon to
report/forms/sqlplus ?
What about the rest of the DBA Applications administrator ?
What do U guys
do to solve the dead-lock problem (If my users access the HR
tables while I
apply the patches, I will encounter dead-lock problem) ?

Please advise. Thanks.

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  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

RE: Disable certain users from login to database while applying H

[CHAN Chor Ling Catherine (CSC)]

Hi Nikunj,

Thanks for replying but I cannot stop the database listener as I need to
login to certain accounts to apply the HR patches.
I will solve the problem by locking those user accounts who could use
sqlplus/forms/reports to access my HR tables, thereby causing deadlock when
I apply the patches. Thanks.

Regds,
Catherine
-Original Message-
From:   Nikunj Gupta [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, February 20, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disable certain users from login to
database while applying Human

stop the listener.



Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Monday, February 18, 2002 01:23 PM
Human


 Pick One..

 1. Change the password.. and then reset to original.
 2. Revoke CREATE SESSION from user.
 3. Startup database in Restrict mode.

 Hope this helps..

 - Original Message -
 To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
 Sent: Sunday, February 17, 2002 11:28 PM


  Hi Gurus,
 
  I need to disable certain users from login to database
while I apply the
  Human Resources Patches for our Oracle HR 11i
Applications.
  Which is the best way to do it ? Should I write on-logon
trigger to
 disable
  or should I take away their privileges to logon to
report/forms/sqlplus
?
  What about the rest of the DBA Applications
administrator ? What do U
guys
  do to solve the dead-lock problem (If my users access
the HR tables
while
 I
  apply the patches, I will encounter dead-lock problem) ?
 
  Please advise. Thanks.
 
  Regds,
  New Bee
  --
  Please see the official ORACLE-L FAQ:
http://www.orafaq.com
  --
  Author: CHAN Chor Ling Catherine (CSC)
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: Nikunj Gupta
   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: Nikunj Gupta
  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

Disable certain users from login to database while applying Human

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I need to disable certain users from login to database while I apply the
Human Resources Patches for our Oracle HR 11i Applications.
Which is the best way to do it ? Should I write on-logon trigger to disable
or should I take away their privileges to logon to report/forms/sqlplus ?
What about the rest of the DBA Applications administrator ? What do U guys
do to solve the dead-lock problem (If my users access the HR tables while I
apply the patches, I will encounter dead-lock problem) ? 

Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Any other OCP discount code ? S36 code can no longer be used

[CHAN Chor Ling Catherine (CSC)]

Hi Jim,

I use OTN20. 20% discount.

Regds,
New Bee
-Original Message-
From:   James McCann [mailto:[EMAIL PROTECTED]]
Sent:   Friday, January 11, 2002 6:25 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Any other OCP discount code ? S36 code
can no longer be used

Hi, could you pass it on to me please,

Thanks,

Jim

-Original Message-
Ling Catherine (CSC)
Sent: 11 January 2002 06:25
To: Multiple recipients of list ORACLE-L
used


Dear All,

I've found the discount code.

Regds,
New Bee
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Friday, January 11, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:Any other OCP discount code
? S36 code can
no longer be used

Dear Gurus,
 
The education discount code S36 can no
longer be used to get
20% discount
from the OCP Test. Does anyone know of any
discount code ?
Please advise.
Thanks.
 
Regds,
New Bee
 

 

-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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: James McCann
  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: CHAN Chor Ling Catherine (CSC)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

Any other OCP discount code ? S36 code can no longer be used

[CHAN Chor Ling Catherine (CSC)]

Dear Gurus,
 
The education discount code S36 can no longer be used to get 20% discount
from the OCP Test. Does anyone know of any discount code ? Please advise.
Thanks.
 
Regds,
New Bee
 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Any other OCP discount code ? S36 code can no longer be used

[CHAN Chor Ling Catherine (CSC)]

Dear All,

I've found the discount code.

Regds,
New Bee
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Friday, January 11, 2002 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:Any other OCP discount code ? S36 code can
no longer be used

Dear Gurus,
 
The education discount code S36 can no longer be used to get
20% discount
from the OCP Test. Does anyone know of any discount code ?
Please advise.
Thanks.
 
Regds,
New Bee
 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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: TABLESPACE ALERT

[CHAN Chor Ling Catherine (CSC)]

Hi Seema,

I've a weekly job that informs me List Of Tablespaces With Next Extent 
Largest Free Extent.  This list helps me to identify the list of
tablespaces that need to be extended due to lack of space (This script will
take into considerations the autoextend indicator).  If this is what you
were looking for, below is the sql statement. I am using Oracle 8.1.6.

Hope it helps.

Regds,
New Bee

REM
REM NAME :  fail_ext_segment.sql
REM FUNCTION :  To identify segments that will fail to acquire
REM their next extent.
REM HISTORY  :
REM DATEWHO WHAT
REM --- 
REM 07-Nov-2001 CHORLINGCREATION
REM

connect / as sysdba

SET PAGESIZE 60
SET LINESIZE 132
SET FEEDBACK OFF
SET VERIFY OFF
SET ECHO OFF
SET HEADING OFF

SELECT  'Database :  '||NAME||' Time :  '||
TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI:SS')
FROMV$DATABASE;

SELECT  'Report   :  List Of Segments With Next Extent  Largest Free
Extent'
FROMDUAL;

SET TERMOUT OFF
REM SET NEWPAGE 0
SET HEADING ON
SET SPACE 1

COLUMN OWNER FORMAT A10
COLUMN SEGMENT_NAME FORMAT A30
COLUMN SEGMENT_TYPE FORMAT A10
COLUMN TABLESPACE_NAME FORMAT A15
COLUMN SEGMENT_TYPE HEADING Segment|Type
COLUMN EXTENTS_ALLOC HEADING EXTENTS|ALLOC format 999,999
COLUMN MAX_FREE_BYTES FORMAT999,999,999
COLUMN NEXT_EXTENT_BYTES FORMAT 999,999,999
COLUMN AUTO_EXTEND_TABLESPACE FORMAT A7
COLUMN NEXT_EXTENT_BYTES HEADING Next|Extent|Bytes
COLUMN MAX_FREE_BYTES HEADING Largest|Free|Extent
COLUMN TABLESPACE_NAME HEADING Tablespace|Name
COLUMN AUTO_EXTEND_TABLESPACE HEADING Auto|Extend

BREAK ON OWNER SKIP 1

SELECT
T.OWNER,T.SEGMENT_NAME,T.SEGMENT_TYPE,F.TABLESPACE_NAME,T.NEXT_EXTENT_BYTES,
  T.Extents_alloc,F.MAX_FREE_BYTES,DF.AUTO Auto_Extend_Tablespace
FROM (SELECT
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,MAX(NEXT_EXTENT)
NEXT_EXTENT_BYTES,
  SUM(EXTENTS) Extents_alloc
  FROM DBA_SEGMENTS GROUP BY
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME) T,
 (SELECT TABLESPACE_NAME,MAX(BYTES) MAX_FREE_BYTES FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
 (SELECT TABLESPACE_NAME,MAX(AUTOEXTENSIBLE) AUTO FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) DF
WHERE T.TABLESPACE_NAME = F.TABLESPACE_NAME
AND  F.MAX_FREE_BYTES = T.NEXT_EXTENT_BYTES
AND DF.TABLESPACE_NAME=T.TABLESPACE_NAME
AND DF.AUTO='NO'
union
SELECT
T.OWNER,T.SEGMENT_NAME,T.SEGMENT_TYPE,F.TABLESPACE_NAME,T.NEXT_EXTENT_BYTES,
  T.Extents_alloc,F.MAX_FREE_BYTES,'Yes' Auto_Extend_Tablespace
FROM (SELECT TABLESPACE_NAME,(MAXBYTES-USER_BYTES)
MAX_FREE_BYTES,AUTOEXTENSIBLE AUTO
  FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE='YES') F,
 (SELECT
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME,MAX(NEXT_EXTENT)
NEXT_EXTENT_BYTES,
  SUM(EXTENTS) Extents_alloc
  FROM DBA_SEGMENTS GROUP BY
OWNER,SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME) T
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
AND F.MAX_FREE_BYTES = T.NEXT_EXTENT_BYTES
ORDER BY 1,4,3,2;


-Original Message-
From:   Seema Singh [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, January 09, 2002 8:00 AM
To: Multiple recipients of list ORACLE-L
Subject:TABLESPACE ALERT

Hi
I want to set alert information whenever a tablespaces reach
close to full 
or some particular space is free.
If some one have any scripts please send me.
Thanks
-Seema




_
Send and receive Hotmail on your mobile device:
http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seema Singh
  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: CHAN Chor Ling Catherine (CSC)
  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

RE: database administration questions

[CHAN Chor Ling Catherine (CSC)]

 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: CHAN Chor Ling Catherine (CSC)
  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: Mail list for Oracle Applications 11.0 and 11i?

[CHAN Chor Ling Catherine (CSC)]

Hi Don,

You can try  to send ablank message to [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  to sign up for Oracle HRMS listserver

HTH.

Regds,
ChorLing
-Original Message-
From:   Don [mailto:[EMAIL PROTECTED]]
Sent:   Friday, December 14, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L
Subject:Mail list for Oracle Applications 11.0 and
11i?

I'm sure I have seen mention of one or more listservers for
users that are 
in the Oracle Apps world.  Would somebody be kind enough to
post those 
listservers again, or point me where I could find them?


Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  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: CHAN Chor Ling Catherine (CSC)
  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).

Upgrade OS from Unix 2.6 to Unix 2.8 for Oracle HRMS Applications

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I need to update the OS from Unix 2.6 to 2.8 on my database and form
servers. We are running Oracle HRMS Applications 11I Version 11.5.1.

Has anyone done it before ? Any advice ? Please help. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: OCP

[CHAN Chor Ling Catherine (CSC)]

Hi,

Does the material from technet.oracle.com sufficient to pass the exam ?

Regds,
New Bee

-Original Message-
From:   Ed [mailto:[EMAIL PROTECTED]]
Sent:   Saturday, December 08, 2001 12:05 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: OCP

Just finished this a few months ago. My advice is to use the
Oracle Exam
Guide, Sybex Exam Guides, and Exam Cram as a third choice,
but get the other
two first.  The ExamCram has much more detail, but does not
explain concepts
well.  The STS (selftestsoftware.com) practice tests are
really very good.
I only used one, but it was done very well.  I passed all
tests on the first
try with an average of about 90%.  The actual tests are MUCH
harder than the
practice tests in the study guides (any of them).

Also note, you not only need to study, but also TRY things.
I installed
Oracle on Linux at home and tinkered to my heart's content.
Make sure you
understand the DBA and V$ views or you won't pass.

Best of luck,

Ed

- Original Message -
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Friday, December 07, 2001 4:40 AM


 Hi

 I have been a DBA for a few years now, I am consdering
doing the OCP exams

 I have bought the Oracle 8i DBA certification Exam Guide.

 However I have been informed by a fellow DBA that he
bought the same book,
 studied it and took the practice tests and was getting
around 90% in
 these tests.. 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 Iqbal
   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: Ed
  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: CHAN Chor Ling Catherine (CSC)
  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).

Change sysdate in database to a future date

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I need to change the sysdate in the database to a future date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Change sysdate in database to a future date

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

Does anyone know how to change the date of the Unix system ? I am running my
database server in Unix 2.6. Thanks.

Regds,
New Bee

PS.  Thank you, Kranti,  for your reply.

-Original Message-
From:   kranti pushkarna
[mailto:[EMAIL PROTECTED]]
Sent:   Friday, December 07, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change sysdate in database to a future
date 

change the date of the system on which the database resides

-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

I need to change the sysdate in the database to a future
date. Does anyone
know the command to do it ? Please advise. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: kranti pushkarna
  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: CHAN Chor Ling Catherine (CSC)
  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: Change sysdate in database to a future date

[CHAN Chor Ling Catherine (CSC)]

Dear All,

I've found the answer. I manage to use the date command in root account to
change the date. Thanks.

Regds,
New Bee
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Friday, December 07, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change sysdate in database to a future
date 

Hi Unix Gurus,

Does anyone know how to change the date of the Unix system ?
I am running my
database server in Unix 2.6. Thanks.

Regds,
New Bee

PS.  Thank you, Kranti,  for your reply.

-Original Message-
From:   kranti pushkarna
[mailto:[EMAIL PROTECTED]]
Sent:   Friday, December 07, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Change sysdate in
database to a future
date 

change the date of the system on which the
database resides

-Original Message-
Sent: Friday, December 07, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L


Hi Gurus,

I need to change the sysdate in the database
to a future
date. Does anyone
know the command to do it ? Please advise.
Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: kranti pushkarna
  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: CHAN Chor Ling Catherine (CSC)
  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

RE: Script for next_extent of objects = free space available

[CHAN Chor Ling Catherine (CSC)]

 SELECT * FROM DBA_FREE_SPACE WHERE
TABLESPACE_NAME='XTRD';

TABLESPACE_NAME  FILE_ID  BLOCK_ID BYTES
BLOCKS
RELATIVE_FNO
-- - - -
-

XTRD  29  2179   3112960
380
29


Regds,
New bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Molina, Gerardo
  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: CHAN Chor Ling Catherine (CSC)
  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).

Script for next_extent of objects = free space available

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I am looking for a script that shows the list of tables with next extent =
the free space available in the tablespace. Does anyone have the script ?

I write a script displaying the list of table-spaces with inadequate space
for the next extent of the table

SELECT F.TABLESPACE_NAME,NEXT_EXTENT,BYTES FREE_SPACE
FROM (SELECT TABLESPACE_NAME,MAX(NEXT_EXTENT) NEXT_EXTENT
FROM DBA_TABLES GROUP BY TABLESPACE_NAME) T,
 (SELECT TABLESPACE_NAME,MAX(BYTES) BYTES
  FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) F
WHERE T.TABLESPACE_NAME = F.TABLESPACE_NAME
AND  F.BYTES = T.NEXT_EXTENT

Example :

TABLESPACE_NAMENEXT_EXTENT FREE_SPACE

-- --- --

XTRD   83886083112960


Based on the example above, although I alter database to set the data file
pertaining to the tablespace_name XTRD autoextend on for the next 10M, 
the bytes in dba_free_space will still reflect as 3112960. My script will
not work.

Any advise ? Thanks.


SQL SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='XTRD';

FILE_NAME


  FILE_ID TABLESPACE_NAMEBYTESBLOCKS STATUS
RELATIVE_FNO AUT  MAXBYTES
- -- - - -
 --- -
MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-  -- ---
/dg7/app/oracle/testdata/xtrd01.dbf
   29 XTRD20971520  2560 AVAILABLE
29 NO  0
00   208896002550


I issued the command to set autoextend on for the datafile
'/dg7/app/oracle/testdata/xtrd01.dbf'.


SQL  SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='XTRD';

FILE_NAME

---
  FILE_ID TABLESPACE_NAMEBYTESBLOCKS STATUS
RELATIVE_FNO AUT  MA
- -- - - -
 --- ---
MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-  -- ---
/dg7/app/oracle/testdata/xtrd01.dbf
   29 XTRD20971520  2560 AVAILABLE
29 YES 3.4
  4194302 2560   208896002550


SQL SELECT * FROM DBA_FREE_SPACE WHERE TABLESPACE_NAME='XTRD';

TABLESPACE_NAME  FILE_ID  BLOCK_ID BYTESBLOCKS
RELATIVE_FNO
-- - - - -

XTRD  29  2179   3112960   380
29


Regds,
New bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: OT : Is Oracle HRMS 11i 11.5.1 supported in Unix OS 2.8 ?

[CHAN Chor Ling Catherine (CSC)]

Hi,

I've found the answer. 

Regds,
ChorLing

-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Friday, October 05, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject:OT : Is Oracle HRMS 11i 11.5.1 supported in
Unix OS 2.8 ? 

Hi Gurus,

Does anyone know whether oracle HRMS 11i 11.5.1 is supported
in Unix OS 2.8.
We are currently using Unix OS 2.6 but is thinking of moving
to another Unix
machine that only supports OS 2.8.  Any advice ?

Regds,
Chorling
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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).

OT : Is Oracle HRMS 11i 11.5.1 supported in Unix OS 2.8 ?

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

Does anyone know whether oracle HRMS 11i 11.5.1 is supported in Unix OS 2.8.
We are currently using Unix OS 2.6 but is thinking of moving to another Unix
machine that only supports OS 2.8.  Any advice ?

Regds,
Chorling
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: The DBA in the IS organization

[CHAN Chor Ling Catherine (CSC)]

Hi Dave,

Our department (appro. 40 staff) is divided into 3 sections : application,
network and end-user 

All our DBAs are under the applications support group. All of us report to
the applications head. Our title is Systems Analyst. We don't have root
access to the Unix servers. Besides, installing database, cloning database
and applying patches etc, all of us are involved in applications
development/maintenance.  I migrated the Leave Holiday System into the
Oracle HRMS self-service (oracle workflow), maintain in-house projects,
support turn-key project like payroll etc.

Hope it helps.

Regds,
Catherine
-Original Message-
From:   Farnsworth, Dave
[mailto:[EMAIL PROTECTED]]
Sent:   Saturday, September 15, 2001 7:55 PM
To: Multiple recipients of list ORACLE-L
Subject:The DBA in the IS organization

I am wondering how my fellow DBA's fit into their IS
organization.  My
situation is this.  I was hired just a little over a year
ago as a DBA but
my official title is network programmer.  Except for some
job scripting I
have not done any coding.  I am the only DBA for 5 Oracle
databases and 4
SQL Server installations.  Currently my boss is the head of
development.  I
work with the developers and with the network admins
equally.  I sometimes
feel a bit of a conflict with me being under the developers.
I have been
thinking about approaching the VP of IS about having me be
under him rather
than being under development.  I feel I need to have equal
footing with the
development managers and with the network admins.  Right now
I am kind in
limbo with no real authority.
So anyway, I am just wondering where you fit in your
organization and what
is the appropriate place for the DBA.
And yes I got called into work.  Sucks to be me today.  :o)

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  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: CHAN Chor Ling Catherine (CSC)
  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: SO UPSET FOR ALL AMERICANS

[CHAN Chor Ling Catherine (CSC)]

Singaporeans express our deepest condolences to the victims and their
families. We join others in condemning these acts of terrorism.

I'll continue to pray for the people of America.

Catherine
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 09/12/2001 1:40 PM

We Indians also pray for the families who have lost their kin and kith
in the terrorist attack and I personally believe, those who are
responsible must be traced and punished by law.

Venkat
--

On Tue, 11 Sep 2001 16:12:03  
 Jared Still wrote:

Thank you Bunyamin.

This is a tragedy for everyone.

Jared

On Tuesday 11 September 2001 10:15, Bunyamin K. Karadeniz wrote:
 I HOPE BEST WISHES FOR ALL PEOPLE IN AMERICA .

 WE TURKISH PEOPLE ARE ALL SORRY AND HOPE YOU HEALTH.
 BUNYAMIN


Content-Type: text/html; charset=iso-8859-9; name=Attachment: 1
Content-Transfer-Encoding: quoted-printable
Content-Description: 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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).



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  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: CHAN Chor Ling Catherine (CSC)
  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: OT: STOP THE PRESS!!

[CHAN Chor Ling Catherine (CSC)]

Not just the pentagon, the world trade centres in New York were crashed by 2
planes as well.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 09/11/2001 10:45 PM

Looks like the Pentagon was also just bombed.

Denise Gwinn
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: CHAN Chor Ling Catherine (CSC)
  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).

How to organize oracle directories in Unix ?

[CHAN Chor Ling Catherine (CSC)]

Hi Guru,

How do you organize your oracle directories in Unix ?

I am thinking of using the configurations below. We are using Raid 5 with
various mount points.

\dg1\oracle = contains Oracle Human Resources software applications and
oracle home .eg. sidappl, sidcomn, sidora

\dg2\oracle = contains redo log file and control file eg. sidredo  sidctrl

\dg3\oracle = contains redo log file and control file eg. sidredo  sidctrl

\dg4\oracle = contains redo log file and control file eg. sidredo  sidctrl

\dg5\oracle = system tablespace file and temp tablespace data file .eg.
siddata
\dg6\oracle = data file and rollback segment data file .eg. siddata
\dg7\oracle = index file eg. sididx
\dg8\oracle = archive log file .eg. sidarc

Is there any disadvantage if I put the redo log file and control file in
different directories but in the same mount point ?

Is there any disadvantage if I put the rollback segment data file together
with my data file in the same directory ?

Is there any disadvantage if I put the tablespace data file together with my
temp tablespace data file in the same directory ?

TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: How to organize oracle directories in Unix ?

[CHAN Chor Ling Catherine (CSC)]

Hi Joe,

What's your configuration ? Raid 1 ?
How do U organize the oracle directories ? 

Correct me if I am wrong. I thought though I use Raid 5 but with different
mount points, I will not have contention problems 
For example 
One mount point for data files
Another mount point for index files. 

Please advise. Thanks.

Regds,
New Bee
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 09/09/2001 8:30 PM

if u dont know the underlying striping and someone else built the
filesystes, then the point is moot, you might as well have one logical
disk, since you cant reallt guarantee where something is going to end up
anyways.

with all of the raid5 stuff(that evryone likes so much anymore), we as
DBAs dont have control over where stuff is, so a good backup/recovery
plan is a must, at least in the old days when a physical device was
mapped to a filesystem(pre-logical volume days), we could handle making
sure of duplexing redo logs, etc.

joe
CHAN Chor Ling Catherine (CSC) wrote:
 
 Hi Guru,
 
 How do you organize your oracle directories in Unix ?
 
 I am thinking of using the configurations below. We are using Raid 5
with
 various mount points.
 
 \dg1\oracle = contains Oracle Human Resources software applications
and
 oracle home .eg. sidappl, sidcomn, sidora
 
 \dg2\oracle = contains redo log file and control file eg. sidredo 
sidctrl
 
 \dg3\oracle = contains redo log file and control file eg. sidredo 
sidctrl
 
 \dg4\oracle = contains redo log file and control file eg. sidredo 
sidctrl
 
 \dg5\oracle = system tablespace file and temp tablespace data file
.eg.
 siddata
 \dg6\oracle = data file and rollback segment data file .eg. siddata
 \dg7\oracle = index file eg. sididx
 \dg8\oracle = archive log file .eg. sidarc
 
 Is there any disadvantage if I put the redo log file and control file
in
 different directories but in the same mount point ?
 
 Is there any disadvantage if I put the rollback segment data file
together
 with my data file in the same directory ?
 
 Is there any disadvantage if I put the tablespace data file together
with my
 temp tablespace data file in the same directory ?
 
 TIA
 
 Regds,
 New Bee

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  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: CHAN Chor Ling Catherine (CSC)
  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: OT : Changing APPLSYS password in Oracle Human

[CHAN Chor Ling Catherine (CSC)]

Hi Mario,

Version 11i

Regds,
Catherine
-Original Message-
From:   Mario Alberto Ramos Arellano
[mailto:[EMAIL PROTECTED]]
Sent:   Thursday, September 06, 2001 4:41 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: RE: OT : Changing APPLSYS password in
Oracle Human

Hi Catherine,

That's pretty interesting. AFAIR, I didn't have to change
any hard code when we working with Oracle Apps 10.7 NCA.

What version you're working with?

Salu2

Mario Alberto Ramos

 CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
09/05/01 01:48 AM 
Hi Mario,

Mario wrote : 
 That's not the way it works.
 I remember I did it once and the right steps are on
metalink (you need to
do it in Oracle Apps and afterwards in the database). 
 Be pretty careful as you might screw your whole
application up on
changing the apps password.

The procedure that Jeram used is exactly the same as
Note:1013526.102 in
Metalink. I followed the procedure without changing the
configuration files
and I still cannot login to the Oracle HR applications.
Anyway, I found an
article in Metalink that states that the apps password which
is hardcoded in
the file wdbsvr.app must be changed to the new password. 

TESTora/8.0.6/listener/cfg/wdbsvr.app
TESTora/webdb/listener/cfg/wdbsvr.app

I changed the passwords and now I can finally login to the
Oracle Apps.

Regds,
New Bee
-Original Message-
From:   Jeram [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, September 05, 2001 12:41
PM
To: Multiple recipients of list ORACLE-L
Subject:Re: OT : Changing APPLSYS
password in Oracle
Human Resources

Hi..

This is the way How I changed my apps and
applsys password :

1. Shutdown your concurrent manager and make
sure there is
noone using the
application.
2. Start your oracle APPS and logon as
Sysadmin (with System
Administrator
Responsibility)
3. Go to security---Oracle---register
4. Query all users in Oracle APPS ( if you
are using Orcle
APPS 11 or 11i
just type ctrl+f11 it will display all
users)
5. Click in the Password column(tab) for
Apps and Applsys
user , type new
password and press enter then retype it
again for
confirmation, do it one by
one for APPS and APPLSYS user.
6. Save your work and exit from oracle apps.
7. now you have to use SQLPLUS to logon to
the database
connect as SYSTEM or
SYS
8.type  alter user apps identified by (the
same password
entered from
application level) do it for applsys also.
9. task completed

If possible do it first in you Test
environment, test it, if
it is OK then
try in Production, or before doing it take a
full backup of
your application
and database also.

Hope this can help you.

Thanks
Jeram
-Original Message-
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Date: Wednesday, September 05, 2001 10:19 AM


That's not the way it works.
I remember I dit it once and the right steps
are on metalink
(you need to do
it in Oracle Apps and afterwards in the
database). Be pretty
careful as you
might screw your whole application up on
changing the apps
password.

 [EMAIL PROTECTED] 09/04/01 07:30 AM 
Hi Oracle App DBA Gurus

OT : Changing APPLSYS password in Oracle Human Resources System

[CHAN Chor Ling Catherine (CSC)]

Hi Oracle App DBA Gurus,

Does anyone have a list of files that hardcode the APPLSYS  APPS password
in the oracle software directory ? I am about to change the APPS  APPLSYS
password but worry that the HR application will not run smoothly as I
believe the passwords of APPLSYS  APPS accounts are hardcoded in the
configuration files. Any pointers ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: OT : Changing APPLSYS password in Oracle Human Resources Syst

[CHAN Chor Ling Catherine (CSC)]

Hi,

I've found the OS configuration files that hardcodes the passwords.

Regds,
New Bee

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 09/04/2001 4:50 PM

Hi Oracle App DBA Gurus,

Does anyone have a list of files that hardcode the APPLSYS  APPS
password
in the oracle software directory ? I am about to change the APPS 
APPLSYS
password but worry that the HR application will not run smoothly as I
believe the passwords of APPLSYS  APPS accounts are hardcoded in the
configuration files. Any pointers ? TIA

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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: OT : Changing APPLSYS password in Oracle Human Resources

[CHAN Chor Ling Catherine (CSC)]

Hi Mario,

Mario wrote : 
 That's not the way it works.
 I remember I did it once and the right steps are on metalink (you need to
do it in Oracle Apps and afterwards in the database). 
 Be pretty careful as you might screw your whole application up on
changing the apps password.

The procedure that Jeram used is exactly the same as Note:1013526.102 in
Metalink. I followed the procedure without changing the configuration files
and I still cannot login to the Oracle HR applications.  Anyway, I found an
article in Metalink that states that the apps password which is hardcoded in
the file wdbsvr.app must be changed to the new password. 

TESTora/8.0.6/listener/cfg/wdbsvr.app
TESTora/webdb/listener/cfg/wdbsvr.app

I changed the passwords and now I can finally login to the Oracle Apps.

Regds,
New Bee
-Original Message-
From:   Jeram [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, September 05, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: OT : Changing APPLSYS password in Oracle
Human Resources

Hi..

This is the way How I changed my apps and applsys password :

1. Shutdown your concurrent manager and make sure there is
noone using the
application.
2. Start your oracle APPS and logon as Sysadmin (with System
Administrator
Responsibility)
3. Go to security---Oracle---register
4. Query all users in Oracle APPS ( if you are using Oracle
APPS 11 or 11i
just type ctrl+f11 it will display all users)
5. Click in the Password column(tab) for Apps and Applsys
user , type new
password and press enter then retype it again for
confirmation, do it one by
one for APPS and APPLSYS user.
6. Save your work and exit from oracle apps.
7. now you have to use SQLPLUS to logon to the database
connect as SYSTEM or
SYS
8.type  alter user apps identified by (the same password
entered from
application level) do it for applsys also.
9. task completed

If possible do it first in you Test environment, test it, if
it is OK then
try in Production, or before doing it take a full backup of
your application
and database also.

Hope this can help you.

Thanks
Jeram
-Original Message-
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Date: Wednesday, September 05, 2001 10:19 AM


That's not the way it works.
I remember I dit it once and the right steps are on metalink
(you need to do
it in Oracle Apps and afterwards in the database). Be pretty
careful as you
might screw your whole application up on changing the apps
password.

 [EMAIL PROTECTED] 09/04/01 07:30 AM 
Hi Oracle App DBA Gurus,

Does anyone have a list of files that hardcode the APPLSYS
 APPS password
in the oracle software directory ? I am about to change the
APPS  APPLSYS
password but worry that the HR application will not run
smoothly as I
believe the passwords of APPLSYS  APPS accounts are
hardcoded in the
configuration files. Any pointers ? TIA

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  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: Mario Alberto Ramos Arellano
  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

OT (Unix): Find names of files (in current sub-dir) that contai

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

What's the command to find the names of all files (in the current directory
and sub-directory) which contains the word APPS ? 

I know that grep -i APPS *.*  works but it's only for the current
directory.  I need to know all the files that contain the word APPS in the
sub-directory as well. 

TIA

Regds,
New Bee 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: OT (Unix): Find names of files (in current sub-dir) that co

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

I am sorry that my earlier email is not clear. Exactly, I am trying to find
all the files in the current and sub-directories that have the word APPS
in the file contents.

TIA

Regds,
New Bee
-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Friday, August 31, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L
Subject:OT (Unix): Find names of files (in current 
sub-dir) that contai

Hi Unix Gurus,

What's the command to find the names of all files (in the
current directory
and sub-directory) which contains the word APPS ? 

I know that grep -i APPS *.*  works but it's only for the
current
directory.  I need to know all the files that contain the
word APPS in the
sub-directory as well. 

TIA

Regds,
New Bee 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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).

Drop Recreate table or alter table drop column. Which is

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

If the table is empty  U need to drop one of the columns, do you 
1) alter table tab_name drop column col_name or 
2) drop  recreate table

I use option (1). Which is a better choice ?  TIA

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: SQL+ SELECT statement need help

[CHAN Chor Ling Catherine (CSC)]

Try CHR(10) 

.ie. SELECT 'NAME : ' || ename ||CHR(10)||'DEPARTMENT : ' || dept ||
CHR(10)||'SALARY : ' ||sal FROM emp;

Hope it helps.

Regds,
Chorling
-Original Message-
From:   Sinardy [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, August 28, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Subject:SQL+ SELECT statement need help

Hi all,

1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || '  DEPARTMENT : ' ||
dept || '   SALARY : ' ||
sal
FROM emp;

Result:

NAME : JAMES   DEPARTMENT : LAB ENGINEER   SALARY :
2000
NAME : BOB   DEPARTMENT : DRIVER   SALARY : 2000


3. I can I break them to be like

Name : JAMES
DEPARTMENT : LAB ENGINNER
SALARY : 2000

NAME : BOB
DEPTARTMENT : DRIVER
SALARY : 2000

something like a new line ('/n') in C++

SELECT 'NAME : ' || ename || '/n  DEPARTMENT : ' ||
dept || '/n   SALARY :
' || sal
FROM emp;


Thank you

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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: CHAN Chor Ling Catherine (CSC)
  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).

OT: Unix - performance tuning (vmstat 5)

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

I submit a job to monitor the CPU utilization etc every 15 mins using the
command vmstat 5.

How do I kill the submitted unix process of the batch job ? 

I tried to kill the submitted process using a batch job using the following
command :
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
kill $var_pid

This works if the output is 
$ ps -ef | grep vmstat
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat

If the output is as below, the program will not work 
$ ps -ef | grep vmstat
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5

Please help. Thanks in advance.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Unix - performance tuning (vmstat 5)

[CHAN Chor Ling Catherine (CSC)]

Hi Jaouich,

The command
kill `ps -ef | grep vmstat |awk '{print $2}'` 
works. Thanks a million.

Peter has also solved the problem for me by advising me to use vmstat 5 5
instead.

Regds,
New Bee in Unix
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 08/22/2001 10:21 PM

I am not sure I understand you question correctly, but here is
what I use when I want to kill some jobs ($BATCHJOB = name of the job to
kill):

kill -9 `ps -ef|grep $BATCHJOB|awk '{print $2}'` 

If I want to kill all of one user's jobs: 
su - user 
kill -9 -1 

Cheers! 

Cyril Jaouich (Conseiller Unix) 
--- 
Centre de support informatique CSI 
-- 
Tél 514-289-1122 x6237 

-- 
De :CHAN Chor Ling Catherine (CSC)[SMTP:[EMAIL PROTECTED]] 
Répondre à :[EMAIL PROTECTED] 
Date :  mercredi 22 août 2001 08:05 
A : Multiple recipients of list ORACLE-L 
Objet : OT: Unix - performance tuning (vmstat 5) 

Hi Unix Gurus, 

I submit a job to monitor the CPU utilization etc every 15 mins
using the 
command vmstat 5. 

How do I kill the submitted unix process of the batch job ? 

I tried to kill the submitted process using a batch job using
the following 
command : 
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )` 
kill $var_pid 

This works if the output is 
$ ps -ef | grep vmstat 
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5 
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat 

If the output is as below, the program will not work 
$ ps -ef | grep vmstat 
   orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat 
   orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5 

Please help. Thanks in advance. 

Regds, 
New Bee 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com  
-- 
Author: CHAN Chor Ling Catherine (CSC) 
  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: CHAN Chor Ling Catherine (CSC)
  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: OT: Unix - performance tuning (vmstat 5)

[CHAN Chor Ling Catherine (CSC)]

Thanks, Peter. U've just solved my problem.

Regds,
New Bee in Unix
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 08/22/2001 9:51 PM

Hi

Have a look at setting the second value with the vmstat command so you
use 
something like vmstat 5 5 instead. This runs vmstat 5 times with a 5
second 
interval
Try it on the command line and see if that  is the result you require


HTH

Peter

At 10:05 PM 22/08/2001, you wrote:
Hi Unix Gurus,

I submit a job to monitor the CPU utilization etc every 15 mins using
the
command vmstat 5.

How do I kill the submitted unix process of the batch job ?

I tried to kill the submitted process using a batch job using the
following
command :
var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`
kill $var_pid

This works if the output is
$ ps -ef | grep vmstat
orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5
orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat

If the output is as below, the program will not work
$ ps -ef | grep vmstat
orahrms 11612 11576  0 18:50:53 pts/11   0:00 grep vmstat
orahrms 11271 11263  0 17:30:00 ?0:00 vmstat 5

Please help. Thanks in advance.

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
   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: Peter McLarty
  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: CHAN Chor Ling Catherine (CSC)
  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).

Oracle Performance in Unix machine with hardware Raid 5

[CHAN Chor Ling Catherine (CSC)]

Hi Guru,

We will be implementing Oracle in unix machine with Hardware Raid 5. We
can't implement Raid 1 as we do not have sufficient disk space. 

Initially, we thought of having many mount points .ie. 1 mount point for
data files, another for index files,  other mount points for redo log,
control file, archive log etc. The vendor consultant told us that having
many mount points may degrade the system performance. Is it true ? We've
decided to have different directories for data files, index files etc but I
am still worry about data contention.

Any advice ? Thanks.

Regds,
new bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: How to create 2 unique indexes (Field1, Field2) and (Field1,

[CHAN Chor Ling Catherine (CSC)]

Hi,

I would like to thank those who replied. Yes, my problem has been resolved
after removing duplicate values in the table. Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

How to encrypt Password in Export script file ?

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

My daily export file (daily_exp.sh) contains :
exp userid='system/password' file=file_name.dmp grants=y rows=y
constraints=y compress=y full=y inctype=complete log=file_name.log 

The system password is stated clearly in the export script file. Has anyone
encrypt/decrypt the system password before passing it as a variable to the
export script ? If yes, could I have a copy of your script ? Thanks.

Regds,
New Bee in Unix 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: How to encrypt Password in Export script file ?

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

Thanks to those who replied. We feel that Unix account is easily hacked, so
we will not implement the method that Rachel mentioned. We will probably
encrypt the password in another file. Before exporting, we will decrypt
the password before passing the password to the export script. Thanks.

Regds,
New Bee
-Original Message-
From:   Fisher, Julie [mailto:[EMAIL PROTECTED]]
Sent:   Thursday, May 31, 2001 11:16 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: How to encrypt Password in Export script
file ?

I also did this on all my databases - works very slick.

Julie Fisher
Sandia National Laboratories
Oracle 8i DBA - OCP8i
Solaris 2.6,7/HP-UX 11.0 System Administrator
Web Server Administrator


-Original Message-
Sent: May 31, 2001 7:20 AM
To: Multiple recipients of list ORACLE-L


instead of that, I create an account in the database that is
identified 
externally (can only run from that server, and does not have
a login 
password). You will need a matching Unix account for it, if
the unix account

is exportacct then create the database account as
ops$exportacct

grant this account create session and exp_full_database

then change your shell script to read userid=/  and run
the script from 
the exportacct account

this way you don't need to hardcode a password ANYWHERE

Rachel


From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: How to encrypt Password in Export script file ?
Date: Thu, 31 May 2001 00:50:22 -0800

Hi Unix Gurus,

My daily export file (daily_exp.sh) contains :
exp userid='system/password' file=file_name.dmp grants=y
rows=y
constraints=y compress=y full=y inctype=complete
log=file_name.log

The system password is stated clearly in the export script
file. Has anyone
encrypt/decrypt the system password before passing it as a
variable to the
export script ? If yes, could I have a copy of your script
? Thanks.

Regds,
New Bee in Unix
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
   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).


_
Get your FREE download of MSN Explorer at
http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Fisher, Julie
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
San Diego, California-- Public Internet access /
Mailing Lists

How to drop unique index

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

I tried to drop unique index using ALTER TABLE table_name DROP UNIQUE
(column_name); unsuccessfully. How should I drop the unique index ? Please
advise. Thanks.

SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT';

INDEX_NAME TABLE_NAME COLUMN_NAME
-- --
--
U_SPYADH_2 SPY_ADHOC_PAYMENT  STDNAME


SQL SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM  USER_INDEXES
WHERE TABLE_NAME='SPY_ADHOC_PAYMENT';

INDEX_NAME   TABLE_OWNERTABLE_NAME
UNIQUENES
 -- --

U_SPYADH_2   SPYSPY_ADHOC_PAYMENT
UNIQUE

SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME);
ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME)
   *
ERROR at line 1:
ORA-02442: Cannot drop nonexistent unique key

SQL ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2;
ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2
  *
ERROR at line 1:
ORA-02443: Cannot drop constraint  - nonexistent constraint

Regds,
New Bee
-Original Message-
From:   Manivannan.M [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 2:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: catrep.sql

Hi 

It will be there under $ORACLE_HOME/rdbms/admin

regards,
Manivannan.M


-- 

 


On Tue, 29 May 2001, Timajo, Joel - Equicom wrote:

 hello oracle gurus!
 
 i just tried a default installation of oracle 8.0.6 to our
hp-unix machine.
 i followed step by step the procedures as stated in the
oracle installation
 guide. my problem is when it comes to the step (pp 4-2 of
the installation
 guide) that says run the catrep.sql. where can i find this
sql script?
 
 thanks!
 oracle newbie 
 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manivannan.M
  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: CHAN Chor Ling Catherine (CSC)
  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: How to drop unique index

[CHAN Chor Ling Catherine (CSC)]

Thanks to all who replied. The command Drop Unique index_name works.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).

How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel

[CHAN Chor Ling Catherine (CSC)]

Hi Gurus,

How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the
same table ?

I created the first index successfully but encountered the error ORA-01452:
cannot CREATE UNIQUE INDEX; duplicate keys found when I tried to create the
2nd index. 

SELECT INDEX_NAME,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE
TABLE_NAME='SPY_ADHOC_PAYMENT'

INDEX_NAME TABLE_NAME UNIQUENES
-- -- -
U_SPYADH_1 SPY_ADHOC_PAYMENT  UNIQUE

SQL SELECT * FROM USER_IND_COLUMNS  WHERE TABLE_NAME='SPY_ADHOC_PAYMENT';

INDEX_NAME TABLE_NAME COLUMN_NAME
-- --
--
U_SPYADH_1 SPY_ADHOC_PAYMENT  STDID
U_SPYADH_1 SPY_ADHOC_PAYMENT  PAYGRP

SQL CREATE UNIQUE INDEX U_SPYADH_2 ON SPY_ADHOC_PAYMENT (ACCTNO,PAYGRP);
CREATE UNIQUE INDEX U_SPYADH_2 ON SPY_ADHOC_PAYMENT (ACCTNO,PAYGRP)
  *
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Any advice ? Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: recruiters. Aargh. (More on them!)

[CHAN Chor Ling Catherine (CSC)]

-- 
Author: Cyril  Thankappan
  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: Christopher Spence
  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: Boivin, Patrice J
  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: CHAN Chor Ling Catherine (CSC)
  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).

OT : Unix Mail

[CHAN Chor Ling Catherine (CSC)]

Hi Unix Gurus,

Does anyone know how to send a file db_backup.log to receipient
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  cc [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  with Subject Backup Log file in Unix ?
Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: OT : Unix Mail

[CHAN Chor Ling Catherine (CSC)]

Hi,

I've found the answer. Thanks.

-Original Message-
From:   CHAN Chor Ling Catherine (CSC) 
Sent:   Tuesday, May 22, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject:OT : Unix Mail

Hi Unix Gurus,

Does anyone know how to send a file db_backup.log to
receipient
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  cc
[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]  with Subject Backup Log
file in Unix ?
Thanks.

Regds,
New Bee
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: CHAN Chor Ling Catherine (CSC)
  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).

Shutdown database abort

[CHAN Chor Ling Catherine (CSC)]

Hi,

To shutdown the database for daily backup, I issue the following commands :
1)  shutdown database abort
2)  startup database normal 
3)  shutdown database normal.

Is this the recommended procedure, could gurus share your experience ?
Thanks.

Regds,
New Bee 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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).