Re: alter system reset

[Mladen Gogala]

Arup, problem is in the version. I've had the very same problem, plus
some more (occasionally, database wouldn't start after changing parameters)  
with 9.2.0.1. The latest & greatest version is, as you are very well aware,
9.2.0.4 and it works like a charm.

On 2003.09.01 15:14, Arup Nanda wrote:
Does the entry even exist in the SPFILE? Open up the spfile in notepad and
check the existence of the parameter in there. Do the following:
SQL> alter system set undo_suppress_errors = false scope=spfile
sid='ananda';
System altered.

SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda';

System altered.

HTH.

Arup

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 2:14 PM
> Hello list I am using Oracle 9.2.0.1.0 enterprise on windows.
>
> When I run the following ( connected as sysdba , and using an spfile
called
> %oracle_home%\database\spfilelahiri.ora )
>
> SQL> show user
> USER is "SYS"
>
> SQL> host echo %oracle_sid%
> LAHIRI
>
> SQL> sho parameter db_name
>
> NAME TYPE  VALUE
> db_namestring   lahiri
>
> SQL> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri';
> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'
> *
> ERROR at line 1:
> ORA-32010: cannot find entry to delete in SPFILE
>
> Any ideas ?  I get the same problem irrespective of the parameter I try to
> reset.
> ..
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: alter system reset

[Prem Khanna J]

.wanted to know how you gurus handle SPFILE.
Thanx Mladen.

Regards,
Prem.





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Arup Nanda]

Sami,

Setting up replication is pretty straight forward as long as you follow all
the steps dilligently. Unfortunately if a step is missed, it's hard to
diagnose the problem until one is at the terminal looking at the actual
database. In this case there are several steps that my not have been
correctly executed. Here are some:

(1) Have you built the replication support for the master group?

begin
dbms_repcat.generate_replication_support(
sname=>'HR',
oname=>'DEPATMENTS',
type=>'TABLE',
min_communication=>TRUE);
end;

(2) Have you started replication activity?

begin
dbms_repcat.resume_master_activity(
gname=>'HR_REPG');
end;

(3) Have you created the snaphsot group at the MV Site using
dbms_refresh.make?

You should do this steps before you create the MV RepGroup. You may find an
article I wrote for DBAZine (http://www.dbazine.com/nanda2.html), a related
but separate issue. And please let us know your progress.

HTH.

Arup


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 5:09 PM
mastered at ORC1.WORLD


> Dear Arup,
>
> Thanks for your response. But i have done the same
> which is mentioned in page # 3-6(Replication API
> Reference Manual). Please see below. What else could
> be wrong? TIA
>
> CONNECT repadmin/[EMAIL PROTECTED]
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPGROUP (
> gname => 'hr_repg');
> END;
> /
>
> BEGIN
> DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
> gname => 'hr_repg',
> type => 'TABLE',
> oname => 'departments',
> sname => 'hr',
> use_existing_object => TRUE,
> copy_rows => FALSE);
> END;
> /
>
>
>
> --- Arup Nanda <[EMAIL PROTECTED]> wrote:
> > Before you create the Materialized View Group, you
> > must create the REPGROUP
> > at the Master site, which in you case is ORC1.world.
> >
> > In the database ORC1, use the
> > DBMS_REPCAT.CREATE_MASTER_REPGROUP and
> > DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling
> > the procedure
> > DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
> >
> > HTH.
> >
> > Arup Nanda
> >
> > - Original Message - 
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > Sent: Monday, September 01, 2003 4:24 PM
> > mastered at ORC1.WORLD
> >
> >
> > > Hi list
> > >
> > > I am using Oracle 9.2.0.1.0 enterprise on windows.
> > >
> > > I am going thru the examples provided in
> > "Replication
> > > Management API Reference-Part No. A96568-01".
> > >
> > > While creating MVIEW REPLICATION GROUP, getting
> > the
> > > following error (page # 5-7)
> > >
> > >
> > > SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
> > > Connected.
> > > SQL> BEGIN
> > >   2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
> > >   3  gname => 'hr_repg',
> > >   4  master => 'orc1.world',
> > >   5  propagation_mode => 'ASYNCHRONOUS');
> > >   6  END;
> > >   7  /
> > > BEGIN
> > > *
> > > ERROR at line 1:
> > > ORA-23313: object group "PUBLIC"."HR_REPG" is not
> > > mastered at ORC1.WORLD
> > > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> > > ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> > > ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> > > ORA-06512: at line 2
> > >
> > >
> > > Any help would be really greatful.
> > >
> > > Thanks
> > > Sami
> > >
> > > __
> > > Do you Yahoo!?
> > > The New Yahoo! Search - Faster. Easier. Bingo.
> > > http://search.yahoo.com
> > > -- 
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > -- 
> > > Author: Oracle DBA
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > > San Diego, California-- Mailing list and
> > web hosting services
> > >
> >
> -
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from).  You may
> > > also send the HELP command for other information
> > (like subscribing).
> > >
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > -- 
> > Author: Arup Nanda
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also 

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Oracle DBA]

Dear Arup,

Thanks for your response. But i have done the same
which is mentioned in page # 3-6(Replication API
Reference Manual). Please see below. What else could
be wrong? TIA

CONNECT repadmin/[EMAIL PROTECTED]
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP (
gname => 'hr_repg');
END;
/

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT (
gname => 'hr_repg',
type => 'TABLE',
oname => 'departments',
sname => 'hr',
use_existing_object => TRUE,
copy_rows => FALSE);
END;
/



--- Arup Nanda <[EMAIL PROTECTED]> wrote:
> Before you create the Materialized View Group, you
> must create the REPGROUP
> at the Master site, which in you case is ORC1.world.
> 
> In the database ORC1, use the
> DBMS_REPCAT.CREATE_MASTER_REPGROUP and
> DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling
> the procedure
> DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
> 
> HTH.
> 
> Arup Nanda
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Monday, September 01, 2003 4:24 PM
> mastered at ORC1.WORLD
> 
> 
> > Hi list
> >
> > I am using Oracle 9.2.0.1.0 enterprise on windows.
> >
> > I am going thru the examples provided in
> "Replication
> > Management API Reference-Part No. A96568-01".
> >
> > While creating MVIEW REPLICATION GROUP, getting
> the
> > following error (page # 5-7)
> >
> >
> > SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
> > Connected.
> > SQL> BEGIN
> >   2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
> >   3  gname => 'hr_repg',
> >   4  master => 'orc1.world',
> >   5  propagation_mode => 'ASYNCHRONOUS');
> >   6  END;
> >   7  /
> > BEGIN
> > *
> > ERROR at line 1:
> > ORA-23313: object group "PUBLIC"."HR_REPG" is not
> > mastered at ORC1.WORLD
> > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> > ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> > ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> > ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> > ORA-06512: at line 2
> >
> >
> > Any help would be really greatful.
> >
> > Thanks
> > Sami
> >
> > __
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > -- 
> > Author: Oracle DBA
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from).  You may
> > also send the HELP command for other information
> (like subscribing).
> >
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Arup Nanda
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Arup Nanda]

Before you create the Materialized View Group, you must create the REPGROUP
at the Master site, which in you case is ORC1.world.

In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and
DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure
DBMS_REPCAT.CREATE_MVIEW_REPGROUP.

HTH.

Arup Nanda

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 4:24 PM
mastered at ORC1.WORLD


> Hi list
>
> I am using Oracle 9.2.0.1.0 enterprise on windows.
>
> I am going thru the examples provided in "Replication
> Management API Reference-Part No. A96568-01".
>
> While creating MVIEW REPLICATION GROUP, getting the
> following error (page # 5-7)
>
>
> SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
> Connected.
> SQL> BEGIN
>   2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
>   3  gname => 'hr_repg',
>   4  master => 'orc1.world',
>   5  propagation_mode => 'ASYNCHRONOUS');
>   6  END;
>   7  /
> BEGIN
> *
> ERROR at line 1:
> ORA-23313: object group "PUBLIC"."HR_REPG" is not
> mastered at ORC1.WORLD
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
> ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
> ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
> ORA-06512: at "SYS.DBMS_REPCAT", line 1262
> ORA-06512: at line 2
>
>
> Any help would be really greatful.
>
> Thanks
> Sami
>
> __
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle client and DNS

[Niall Litchfield]

It almost entirely depends on what the error you get back from tnsping
says. 

Niall 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of John Dunn
> Sent: 01 September 2003 09:59
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle client and DNS
> 
> 
> Having problems getting Oracle 8 client working with DNS.
> 
> I can ping the server hostname from my Windows 2000 client, 
> but I cannot tnsping it
> 
> Do I need to do anything at the server end. The listener is 
> running on the server.
> 
> John
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: John Dunn
>   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: Niall Litchfield
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Oracle DBA]

Hi list 

I am using Oracle 9.2.0.1.0 enterprise on windows. 

I am going thru the examples provided in "Replication
Management API Reference-Part No. A96568-01".

While creating MVIEW REPLICATION GROUP, getting the
following error (page # 5-7)


SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
Connected.
SQL> BEGIN
  2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
  3  gname => 'hr_repg',
  4  master => 'orc1.world',
  5  propagation_mode => 'ASYNCHRONOUS');
  6  END;
  7  /
BEGIN
*
ERROR at line 1:
ORA-23313: object group "PUBLIC"."HR_REPG" is not
mastered at ORC1.WORLD
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2


Any help would be really greatful.

Thanks
Sami

__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

REPLICATION: ORA-23313: object group "PUBLIC"."HR_REPG" is not mastered at ORC1.WORLD

[Oracle DBA]

Hi list 

I am using Oracle 9.2.0.1.0 enterprise on windows. 

I am going thru the examples provided in "Replication
Management API Reference-Part No. A96568-01".

While creating MVIEW REPLICATION GROUP, getting the
following error (page # 5-7)


SQL> CONNECT mviewadmin/[EMAIL PROTECTED]
Connected.
SQL> BEGIN
  2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
  3  gname => 'hr_repg',
  4  master => 'orc1.world',
  5  propagation_mode => 'ASYNCHRONOUS');
  6  END;
  7  /
BEGIN
*
ERROR at line 1:
ORA-23313: object group "PUBLIC"."HR_REPG" is not
mastered at ORC1.WORLD
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 2424
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1757
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2


Any help would be really greatful.

Thanks
Sami

__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Oracle DBA
  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: alter system reset

[Arup Nanda]

Does the entry even exist in the SPFILE? Open up the spfile in notepad and
check the existence of the parameter in there. Do the following:

SQL> alter system set undo_suppress_errors = false scope=spfile
sid='ananda';

System altered.

SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda';

System altered.

HTH.

Arup

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 2:14 PM


> Hello list I am using Oracle 9.2.0.1.0 enterprise on windows.
>
> When I run the following ( connected as sysdba , and using an spfile
called
> %oracle_home%\database\spfilelahiri.ora )
>
> SQL> show user
> USER is "SYS"
>
> SQL> host echo %oracle_sid%
> LAHIRI
>
> SQL> sho parameter db_name
>
> NAME TYPE  VALUE
> db_namestring   lahiri
>
> SQL> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri';
> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'
> *
> ERROR at line 1:
> ORA-32010: cannot find entry to delete in SPFILE
>
> Any ideas ?  I get the same problem irrespective of the parameter I try to
> reset.
> ..
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

alter system reset

[bulbultyagi]

Hello list I am using Oracle 9.2.0.1.0 enterprise on windows.

When I run the following ( connected as sysdba , and using an spfile called
%oracle_home%\database\spfilelahiri.ora )

SQL> show user
USER is "SYS"

SQL> host echo %oracle_sid%
LAHIRI

SQL> sho parameter db_name

NAME TYPE  VALUE
db_namestring   lahiri

SQL> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri';
ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE

Any ideas ?  I get the same problem irrespective of the parameter I try to
reset.
..

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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: get sid (session id) and serial#?

[Arup Nanda]

It's hardly illogical. The purpose of this view is not to provide the SID of
the current session, but to show statistics, some of which the DBA may not
want a user to know in all cases. Therefore the view is granted to a role
SELECT_CATALOG_ROLE, similar to most other dictionary views. Any user with
that role can see the view.

However, granting the role SELECT_CATALOG_ROLE to all users is not advisable
at all. If a user needs it, a very simple "grant select on v_$mystat to
" can be issued which will resolve the problem. At a development
site, or a site where the security for this view is not quite pronounced,
you can issue the follwing which will make everyone see this view.

grant select on v_$mystat to public;

This will make the view visible to even the users created after this
command. The decision to hide this view from normal users is deliberate; but
breaking that lock is not hard either using a simple grant as shown.

Going back to the discussion on why it has been so hard for a user to know
his/her SID - why does a user need to know the SID? To alter the DBA for
some monitoring action and seeing the SID will help the DBA see that in
V$SESSION? In that case, the proper technique is to set the client
identifier using DBMS_APPLICATION_INFOR.SET_IDENTIFIER procedure. The value
shows up in v$session, no need to know the SID.

What else? In a web app maintain state between pages using SID? this
approach is fraight with errors. First, SID is not guaranteed to be unique;
SID and SERIAL# combination is. To guarantee a unique identifier, use the
function DBMS_SESSION.UNIQUE_SESSION_ID to get an id that is unique in a
session and use it to maintain state.

If it is necessary that the user must know the SID, then the V$MYSTAT can be
queried.

Hope this helps.

Arup Nanda

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 4:54 AM


> It does seem illogical than Oracle provide a view called mystat which
tells you about your own statistics, including SID and yet a normal user
does not have access to that view unless specifically given.
>
> John
>
> -Original Message-
> Sent: 30 August 2003 15:04
> To: Multiple recipients of list ORACLE-L
>
>
> > But the user need select access to v$mystat
>
> connect as sysdba and grant select on v_$mystat to ;
>
> HTH
> GovindanK
>
> > Thanks all for the input.
> >
> > the script is select sid,serial# from v$session where sid=(select sid
from
> > v$mystat where rownum=1)
> >
> > But the user need select access to v$mystat
> >
> > Chuan
> >
> > -Original Message-
> > Sent: Friday, 29 August 2003 15:19
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Chuan,
> >
> > can v$session help you
> >
> > this view has information like machine, osuser, username, sid, program,
> > and
> > others
> >
> > SQL> desc v$session
> >
> > SQL> select columns,... from v$session where username = 'SCOTT' and
> > machine
> > = 'YOUR_HOSTNAME'
> >
> > if you do telnet you will get 2 rows (if scoot is only use by you)
> >
> > is not
> >
> > Sinardy
> >
> > -Original Message-
> > Sent: 29 August 2003 12:34
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > DABs,
> >
> >   Is there any way in my connection to get the sid and serial# for my
own
> > connection?
> >
> > Suppose I connect to Oracle db by >sqlplus scott/[EMAIL PROTECTED]
> > In this connection,
> >
> > SQL>
> >
> > What shoud I input to get this sid and serial#?
> >
> > TIA
> >
> > Chuan
> > Important: This transmission is intended only for the use of the
addressee
> > and may contain confidential or legally privileged information.  If you
> > are
> > not the intended recipient, you are notified that any use or
dissemination
> > of this communication is strictly prohibited.  If you receive this
> > transmission in error please notify the author immediately by telephone
> > and
> > delete all copies of this transmission together with any attachments.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Sinardy Xing
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > 

Re: Help in installation Redhat Linux 8

[M Rafiq]

Stephen,

Thanks for pointer. I am subscribing to that list. My ultimate goal after 
installing Linux is to install Oracle. I am still waiting response from 
Mladen about this subject, who may be enjoying long weekend in USA.

My problem may be new hardware most possibly built in video on board. I did 
not see any help on redhat site.

Regards
Rafiq


To: [EMAIL PROTECTED],[EMAIL PROTECTED]
Date: Mon, 01 Sep 2003 01:21:57 -0600
I've found the Phoenix Linux User Group to be helpful when you have a
problem.  Just ignore the "my distro is better than yours" garbage.
FWIW, I'm happy with Red Hat 7.3.  I tried to get 8 running on my old
hardware and was having problems, so I am staing where I am for a
long time.
If you ever want to unsubscribe or change your options (eg, switch to
or from digest mode, change your password, etc.), visit your
subscription page at:
http://lists.PLUG.phoenix.az.us/mailman/options/plug-discuss/stephenandert%40hotmail.com

BTW, This message probably shoud have had OT in the subject line since
the connection to Oracle is not direct.
Stephen

>>> [EMAIL PROTECTED] 08/30/03 10:24AM >>>
Env AMD 1.6 processor 512 Ram WD 120G HD (Personal computer)
While installing Redhat Linux 8 from a CD (came with a book) on newly
purchased 120G WD harddrive(manufacturing date of HD is 07/2003) it is
keep
hanging after recognizing mouse. I tried both gui as well as text
option.
The bios disk came with the disk ran successfully and bios were
updated.
Is this the size problem or Redhat patch may be required to handle new

harddrive?

Any pointer or help?

Regards
Rafiq
_
Get MSN 8 and enjoy automatic e-mail virus protection.
http://join.msn.com/?page=features/virus
--
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).
_
Get MSN 8 and enjoy automatic e-mail virus protection.   
http://join.msn.com/?page=features/virus

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

Re: book

[Arup Nanda]

What exactly do you want to see in the book on internals and kernel?

As some others have mentioned already, Steve Adam's book is excellent for
undertanding the internal workings; but it may not be appropriate for a
beginner. If you want the knowledge as a beginner, do check out Tom Kyte's
book - Expert One-to-One; it has a clear explnation of the Oracle processes
and file interaction. This book is for 8i, too; but will help you in
understanding 9i stuff as well.

If you are lookin fro internal latches, locks, waits information, then Steve
Adam's book is unparalled. You have to supplement your learning with
tid-bits of informaion from other sources such as MetaLink, articles, OTN,
and more.

HTH.

Arup

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 5:44 AM


>
> Sorry to repost but forgot to mention, that I needed a book for Oracle 9i
>
> > Hello list
> > any recommendations about buying a book on oracle internal working ,
> oracle
> > kernel ?
> >
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: <[EMAIL PROTECTED]
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Error Log

[Hemant K Chitale]

Yes, I could ignore ORA-001.  But there are cases where I might want
to know of ORA-001's occurring.
Hemant
At 11:59 PM 31-08-03 -0800, you wrote:
Can't you tell your trigger to ignore this error as well.

-Original Message-
Sent: Saturday, August 30, 2003 7:19 AM
To: Multiple recipients of list ORACLE-L


Use a Database Trigger AFTER SERVERRROR.

[careful, the table might fill up pretty quickly -- e.g at my site a load
job ignores ORA-0001 errors but this table gets a lot of ORA-0001 errors !!]
Try this :

drop table system.oracle_errors;
create table system.oracle_errors
(db_username  varchar2(30),
 db_session_id  number,
 db_process_id  number,
 unix_process_id varchar2(9),
 client_process_id  varchar2(9),
 client_program  varchar2(48),
 client_machine  varchar2(64),
 client_terminal varchar2(30),
 client_os_user  varchar2(30),
 appl_user_name  varchar2(100),  -- exclude if not
using Oracle Apps
 appl_responsibility_name  varchar2(100), -- exclude if not
using Oracle Apps
 appl_form_name  varchar2(80),-- exclude if not
using Oracle Apps
 err_timestamp date,
 error_msg varchar2(2000))
tablespace customd   -- or any other TBS
storage (initial 4M next 1M maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx1
on system.oracle_errors(appl_login_name,err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx2
on system.oracle_errors(err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/
create index system.oracle_errors_ndx3
on system.oracle_errors(error_msg)
tablespace customx  -- or any other TBS
storage (initial 1M next 1M maxextents 500 pctincrease 0)
/
drop trigger system.oracle_errors_trg;

create or replace trigger system.oracle_errors_trg
after servererror on database
begin
insert into system.oracle_errors
select s.username, s.sid, p.pid, p.spid, s.process,
s.program, s.machine, s.terminal, s.osuser,
f.user_name, f.responsibility_name, f.user_form_name,   -- exclude
all three if not using Oracle Apps
sysdate, dbms_utility.format_error_stack
from apps.fnd_signon_audit_view f, v$session s, v$process p  -- exclude
apps.fnd_signon_audit_view
where s.audsid = userenv( 'sessionid' )
and s.paddr=p.addr
and p.pid=f.pid(+);  -- exclude this join if not
using Oracle Apps
end;
/
At 06:19 PM 29-08-03 -0800, you wrote:

>Is there anyway to setup oracle on the server side to log all fail and
>error transaction in a file or something? I mean, error/fail
>transaction due to,
>eg: Integrity Contraint violation, Check constraint, Not Null constraint,
any
>other error.
>
>It would simply debugging since then we don't have to output / catch
>and send error and SQL statement on the application level.
>
>System: ORACLE 9i on Redhat Linux 7.3
>
>Thanks.
>RDB
>--
>Reuben D. Budiardja
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Reuben D. Budiardja
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of
>mailing list you want to be removed from).  You may also send the HELP
>command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  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: Jack van Zanen
  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 o

Re: get sid (session id) and serial#?

[Arup Nanda]

Title: Message



Oracle _officialy_doesn't support it even now. It 
is included in the sources with a caveat that it will be installed only under 
instructions from the Support Analysts only. That is why the package is not 
installed as a part of a normal installation.
 
Think of it this way - even if it was not included 
"by mistake" in 8.1.5, there were two releases of 8i after that, 8.1.6 and 
8.1.7, not to mention several patchkits. The mistake could have been easily 
fixed by including the source. However, that was not done. Similarly, if it was 
a mistake, Oracle support should have been more than happy to send out the 
source upon request; but they weren't.
 
HTH.
 
Arup

  - Original Message - 
  From: 
  Hitchman, Peter 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, September 01, 2003 10:09 
  AM
  Subject: RE: get sid (session id) and 
  serial#?
  
  Hi,
  It 
  is my understanding that Oracle do support the dbms_support package and that 
  it should have been in the 8i distribution, but was missed out by mistake. 
  It's calls to sys.dbms_system.set_ev they do not supoprt since this enables 
  you to set any debug event in the kernel.
   
  Regards
   
  Pete
  
-Original Message-From: Arup Nanda 
[mailto:[EMAIL PROTECTED]Sent: 30 August 2003 
00:30To: Multiple recipients of list ORACLE-LSubject: 
Re: get sid (session id) and serial#?
Oracle officially "desupported" the package in 
8i; but then included (by mistake?) in 9i. In 8i, however, you could pester 
your friendly neuighborhood Support Analyst to give you the package. You 
could try from 9i sources, too; but not sure if they work.
 
Arup

  - Original Message - 
  From: 
  Igor 
  Neyman 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Friday, August 29, 2003 5:29 
  PM
  Subject: RE: get sid (session id) and 
  serial#?
  
  
  It's not in 
  8.1.5
   
  
  Igor Neyman, OCP 
DBA
  [EMAIL PROTECTED]
   
   
  -Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On 
  Behalf Of John KanagarajSent: Friday, August 29, 2003 3:20 
  PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: get sid (session id) and 
  serial#?
   
  
  Need 
  to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on 
  all platforms 8.0.6+ I understand.
  
   
  
  John 
  KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment 
  is inevitable, but Discouragement is optional!** The opinions and 
  facts contained in this message are entirely mine and do not reflect those 
  of my employer or customers **
  
-Original Message- 
From: 
Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] 
Sent: Friday, August 29, 
2003 3:35 PM To: Multiple recipients of list 
ORACLE-L Subject: RE: get sid (session id) and 
serial#? 

Raj, 
Which version of db are you on? This is not 
available on 9.2.0.3 
Murali. 
 
 __The 
  information contained in this email is confidential and intended only for 
  the use of the individual or entity named above. If the reader of this 
  message is not the intended recipient, you are hereby notified that any 
  dissemination, distribution, or copying of this communication is strictly 
  prohibited. Thomson Scientific will accept no responsibility or 
  liability in respect to this email other than to the addressee. If you 
  have received this communication in error, please notify us immediately 
  via email: 
  [EMAIL PROTECTED]__

RE: get sid (session id) and serial#?

[Hitchman, Peter]

Title: Message



Hi,
It is 
my understanding that Oracle do support the dbms_support package and that it 
should have been in the 8i distribution, but was missed out by mistake. It's 
calls to sys.dbms_system.set_ev they do not supoprt since this enables you to 
set any debug event in the kernel.
 
Regards
 
Pete

  -Original Message-From: Arup Nanda 
  [mailto:[EMAIL PROTECTED]Sent: 30 August 2003 00:30To: 
  Multiple recipients of list ORACLE-LSubject: Re: get sid (session 
  id) and serial#?
  Oracle officially "desupported" the package in 
  8i; but then included (by mistake?) in 9i. In 8i, however, you could pester 
  your friendly neuighborhood Support Analyst to give you the package. You could 
  try from 9i sources, too; but not sure if they work.
   
  Arup
  
- Original Message - 
From: 
Igor 
Neyman 
To: Multiple recipients of list ORACLE-L 

Sent: Friday, August 29, 2003 5:29 
PM
Subject: RE: get sid (session id) and 
serial#?


It's not in 
8.1.5
 

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
 
 
-Original 
Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf 
Of John KanagarajSent: Friday, August 29, 2003 3:20 
PMTo: Multiple recipients 
of list ORACLE-LSubject: 
RE: get sid (session id) and serial#?
 

Need 
to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all 
platforms 8.0.6+ I understand.

 

John 
KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is 
inevitable, but Discouragement is optional!** The opinions and facts 
contained in this message are entirely mine and do not reflect those of my 
employer or customers **
-Original Message- From: 
  Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] 
  Sent: Friday, August 29, 
  2003 3:35 PM To: Multiple recipients of list 
  ORACLE-L Subject: RE: get sid (session id) and 
  serial#? 
  
  Raj, 
  Which version of db are you on? This is not 
  available on 9.2.0.3 
  Murali. 
   
   



__

The information contained in this email is confidential and 
intended only for the use of the individual or entity named 
above. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly 
prohibited. Thomson Scientific will accept no responsibility 
or liability in respect to this email other than to the addressee. 
If you have received this communication in error, please 
notify us immediately via email: [EMAIL PROTECTED]
__

Re: C program won't run in 9.0.2.3

[Pete Finnigan]

Hi Ruth

Try running under truss or equivalent and check what libraries are being
linked in, maybe you have linked against an incorrect ORACLE_HOME?. 

Also I have seen a similar issue going from 7.3.4 to 8.0.6 a long time
back but if I remember correctly it was caused by a previous printf
statement with incorrect number of format args called before the place
there was a similar error to yours. We could only assume at the time
that the different Pro*C libs / calls built a slightly different stack /
heap and caused the overwrite to happen in a different place between
versions. 

It could of course be a bug in Pro*C, check metalink?

hth

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  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).

Compaq ADG

[Craig Healey]

Has anyone had any experience with Compaq Advanced Data Guard? We've had
3 disk failures in the past year, and each one has caused file
corruptions that have eventually stopped our application. Rebooting the
Oracle 8i instance has sorted the problem out, so I was wondering
whether Oracle and ADG are somehow incompatible.

Regards

Craig Healey


**

This email and any files transmitted with it are confidential and intended solely
for the use of the individual or entity to whom they are addressed and may contain
confidential and/or privileged material.  Any review, retransmission, dissemination
or other use of, or taking of any action in reliance upon, this information by 
persons or entities other than the intended recipient is prohibited.  Statements
and opinions expressed in this e-mail may not represent those of the company.
  
If you have received this email in error please notify [EMAIL PROTECTED] 
 
This footnote also confirms that this email message has been swept by MIMEsweeper
for the presence of computer viruses (www.mimesweeper.com)

***

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Craig Healey
  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: Fw: book

[Prem Khanna J]

Hope "Steve Adams" will give an answer for your question.

Jp.

01-09-2003 18:44:26, <[EMAIL PROTECTED]> wrote:
>Sorry to repost but forgot to mention, that I needed a book for Oracle 9i



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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 keep "root" out?

[Tanel Poder]

Hi!

> I have an idea
>
> 1. Use let say My_Tursted_SA schema, write a trigger that will disconnect
new login as SYS or SYSTEM

How exactly are you planning to disconnect the login? You can't kill your
own session, there's no disconnect or exit command in pl/sql. Only way I
know is to generate an unhandled exception which doesn't allow to log on (or
use an external library to kill your own server process from OS level, but
this gets unnecessarily complicated).

> 2. If you want to use sys or system, you login as My_Trusted_SA disable
the trigger.

Sys & system do have the administer database trigger privilege, thus they
can log on even if the logon trigger fires an unhandled exception.

Cheers,
Tanel.


>
> What do you think?
>
>
> Sinardy
>
> -Original Message-
> Richard Ji
> Sent: 31 August 2003 13:39
> To: Multiple recipients of list ORACLE-L
>
>
> A strange loop eh?  You must have read GEB. :)
>
>
> -Original Message-
> From: Tim Gorman [mailto:[EMAIL PROTECTED]
> Sent: Sat 8/30/2003 12:49 AM
> To: Multiple recipients of list ORACLE-L
> Cc:
> Subject: Re: How to keep "root" out?
> A...
>
> But if you encrypt it, where do you keep the key?  How do you retrieve it
> for use?  Don¹t forget to follow the problem to the next step...
>
> ...and when you do, you realize that if nobody can be trusted, then the
> problem of security becomes an Escher print, or a Mobius strip, or the
> infinity symbol, or the exact value of ³pi²...
>
>
>
> on 8/29/03 9:29 AM, Richard Ji at [EMAIL PROTECTED] wrote:
>
> > We assume the SA don't know much about Oracle.  But if some one is
> > particularly interested in
> > getting into the database, he might be on this list as well learning all
our
> > defense mechanisms. :)
> > Or doesn't have to be subscribed to it since this list is mirrored other
> > places and google is his friend.
> > I think the bottom line is, if you absolutely don't want the data to be
seen,
> > encrypt it.
> >
> > My 2 cents.
> >
> > Richard Ji
> >> -Original Message-
> >> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]
> >> Sent: Friday, August 29, 2003 10:31 AM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: RE: How to keep "root" out?
> >>
> > Walt,
> >
> > Something that has not been suggested - migrate your database to 9.2.
Connect
> > as internal goes away.
> >
> > Other than that, I think the best suggestion you got was a conversation,
and
> > granting access to the v$ tables thru a specific account for that
person.
> >
> > And then put a long trigger in place tracking all connections to the
database.
> > Keep track of all SYS connections.  At least you know when things
happen.  And
> > periodically review the init.ora file for the database to make sure that
> > nobody changes anything.
> >
> > Good Luck!
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >>
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >> Sent: Thursday, August 28, 2003 4:50 PM
> >> To: Multiple recipients of list ORACLE-L
> >> Subject: Re: How to keep "root" out?
> >>
> >>
> >> But someone determined to get in the database can simply edit
sqlnet.ora
> >>
> >>
> >>
> >> "Tanel Poder" <[EMAIL PROTECTED]>
> >> Sent by: [EMAIL PROTECTED]  08/28/2003 10:24 AM
> >>  Please respond to ORACLE-L
> >>
> >> To:Multiple recipients of list ORACLE-L
> >> <[EMAIL PROTECTED]>
> >> cc:
> >> Subject:Re: How to keep "root" out?
> >>
> >>
> >> Hi!
> >>
> >> Put sqlnet.authentication_services = none in your server's sqlnet.ora.
Then
> >> everyone has to use a password.
> >>
> >> Tanel.
> >>
> >> - Original Message -
> >> From: Walter K 
> >> To: Multiple recipients of list ORACLE-L 
> >> Sent: Thursday, August 28, 2003 6:34 PM
> >> Subject: How to keep "root" out?
> >>
> >> Just for grins, I'll ask this question... Is there any way to keep the
Unix
> >> "root" user from logging into the database (i.e. connect internal or /
as
> >> sysdba)? Currently using 8.1.7.4 on Solaris 8 here.
> >>
> >> We have a couple people in our Unix admin group that feel the need to
"help"
> >> by writing their own DB monitoring scripts. Of course, they don't know
what
> >> they're talking about. They do not have formal logins for the database,
but
> >> since they are root users they are connecting via "connect internal".
This is
> >> not only counterproductive but actually a potential security
issue--just
> >> because someone has root doesn't necessarily entitle them to see the
data in
> >> the database. What if it is a payroll database?
> >>
> >> So, I'm curious, is there any way to prevent access via "connect
internal" or
> >> "/ as sysdba"?
> >>
> >> Thanks in advance.
> >>
> >> W
> >>
> >
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 ht

RE: book

[Hitchman, Peter]

Hi,
I am not aware of a 9i book, but I don't think you can go wrong by getting
hold of Steve Adam's book on 8i internals.

Regards

Pete

-Original Message-
Sent: 01 September 2003 10:44
To: Multiple recipients of list ORACLE-L



Sorry to repost but forgot to mention, that I needed a book for Oracle 9i

> Hello list
> any recommendations about buying a book on oracle internal working ,
oracle
> kernel ?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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 information contained in this email is confidential and 
intended only for the use of the individual or entity named 
above. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly 
prohibited. Thomson Scientific will accept no responsibility 
or liability in respect to this email other than to the addressee. 
If you have received this communication in error, please 
notify us immediately via email: [EMAIL PROTECTED]
__
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hitchman, Peter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: book

[Prem Khanna J]

Hi,

"Oracle8i Internal Services for Waits, Latches, Locks, and Memory" by Steve Adams
O'Reilly & Associates, Paperback, Published October 1999, ISBN 156592598X

This is a good one i know.

Regards,
Jp.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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).

Fw: book

[bulbultyagi]

Sorry to repost but forgot to mention, that I needed a book for Oracle 9i

> Hello list
> any recommendations about buying a book on oracle internal working ,
oracle
> kernel ?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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).

book

[bulbultyagi]

Hello list
any recommendations about buying a book on oracle internal working ,  oracle
kernel ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  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 client and DNS

[Tanel Poder]

If you would be so kind to send us the tnsping output, then we'd be able to
help :)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 11:59 AM


> Having problems getting Oracle 8 client working with DNS.
>
> I can ping the server hostname from my Windows 2000 client, but I cannot
> tnsping it
>
> Do I need to do anything at the server end. The listener is running on the
> server.
>
> John
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: John Dunn
>   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: Tanel Poder
  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 client and DNS

[Stephane Faroult]

John,

   It may be a firewall configuration problem.

HTH

SF

>- --- Original Message --- -
>From: John Dunn <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 01 Sep 2003 00:59:26
>
>Having problems getting Oracle 8 client working
>with DNS.
>
>I can ping the server hostname from my Windows 2000
>client, but I cannot
>tnsping it
>
>Do I need to do anything at the server end. The
>listener is running on the
>server.
>
>John
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle client and DNS

[John Dunn]

Having problems getting Oracle 8 client working with DNS.

I can ping the server hostname from my Windows 2000 client, but I cannot
tnsping it

Do I need to do anything at the server end. The listener is running on the
server.

John


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Dunn
  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: get sid (session id) and serial#?

[Hallas, John, Tech Dev]

It does seem illogical than Oracle provide a view called mystat which tells you about 
your own statistics, including SID and yet a normal user does not have access to that 
view unless specifically given.

John

-Original Message-
Sent: 30 August 2003 15:04
To: Multiple recipients of list ORACLE-L


> But the user need select access to v$mystat

connect as sysdba and grant select on v_$mystat to ;

HTH
GovindanK

> Thanks all for the input.
>
> the script is select sid,serial# from v$session where sid=(select sid from
> v$mystat where rownum=1)
>
> But the user need select access to v$mystat
>
> Chuan
>
> -Original Message-
> Sent: Friday, 29 August 2003 15:19
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Chuan,
>
> can v$session help you
>
> this view has information like machine, osuser, username, sid, program,
> and
> others
>
> SQL> desc v$session
>
> SQL> select columns,... from v$session where username = 'SCOTT' and
> machine
> = 'YOUR_HOSTNAME'
>
> if you do telnet you will get 2 rows (if scoot is only use by you)
>
> is not
>
> Sinardy
>
> -Original Message-
> Sent: 29 August 2003 12:34
> To: Multiple recipients of list ORACLE-L
>
>
> DABs,
>
>   Is there any way in my connection to get the sid and serial# for my own
> connection?
>
> Suppose I connect to Oracle db by >sqlplus scott/[EMAIL PROTECTED]
> In this connection,
>
> SQL>
>
> What shoud I input to get this sid and serial#?
>
> TIA
>
> Chuan
> Important: This transmission is intended only for the use of the addressee
> and may contain confidential or legally privileged information.  If you
> are
> not the intended recipient, you are notified that any use or dissemination
> of this communication is strictly prohibited.  If you receive this
> transmission in error please notify the author immediately by telephone
> and
> delete all copies of this transmission together with any attachments.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sinardy Xing
>   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).
> Important: This transmission is intended only for the use of the addressee
> and may contain confidential or legally privileged information.  If you
> are
> not the intended recipient, you are notified that any use or dissemination
> of this communication is strictly prohibited.  If you receive this
> transmission in error please notify the author immediately by telephone
> and
> delete all copies of this transmission together with any attachments.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Corniche Park
  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 

RE: Error Log

[Jack van Zanen]

Can't you tell your trigger to ignore this error as well. 


-Original Message-
Sent: Saturday, August 30, 2003 7:19 AM
To: Multiple recipients of list ORACLE-L



Use a Database Trigger AFTER SERVERRROR.

[careful, the table might fill up pretty quickly -- e.g at my site a load
job ignores ORA-0001 errors but this table gets a lot of ORA-0001 errors !!]

Try this :

drop table system.oracle_errors;
create table system.oracle_errors
(db_username  varchar2(30),
 db_session_id  number,
 db_process_id  number,
 unix_process_id varchar2(9),
 client_process_id  varchar2(9),
 client_program  varchar2(48),
 client_machine  varchar2(64),
 client_terminal varchar2(30),
 client_os_user  varchar2(30),
 appl_user_name  varchar2(100),  -- exclude if not 
using Oracle Apps
 appl_responsibility_name  varchar2(100), -- exclude if not 
using Oracle Apps
 appl_form_name  varchar2(80),-- exclude if not 
using Oracle Apps
 err_timestamp date,
 error_msg varchar2(2000))
tablespace customd   -- or any other TBS
storage (initial 4M next 1M maxextents 500 pctincrease 0)
/

create index system.oracle_errors_ndx1
on system.oracle_errors(appl_login_name,err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/

create index system.oracle_errors_ndx2
on system.oracle_errors(err_timestamp)
tablespace customx  -- or any other TBS
storage (initial 256K next 256K maxextents 500 pctincrease 0)
/

create index system.oracle_errors_ndx3
on system.oracle_errors(error_msg)
tablespace customx  -- or any other TBS
storage (initial 1M next 1M maxextents 500 pctincrease 0)
/

drop trigger system.oracle_errors_trg;

create or replace trigger system.oracle_errors_trg
after servererror on database
begin
insert into system.oracle_errors
select s.username, s.sid, p.pid, p.spid, s.process,
s.program, s.machine, s.terminal, s.osuser,
f.user_name, f.responsibility_name, f.user_form_name,   -- exclude 
all three if not using Oracle Apps
sysdate, dbms_utility.format_error_stack
from apps.fnd_signon_audit_view f, v$session s, v$process p  -- exclude 
apps.fnd_signon_audit_view
where s.audsid = userenv( 'sessionid' )
and s.paddr=p.addr
and p.pid=f.pid(+);  -- exclude this join if not 
using Oracle Apps
end;
/

At 06:19 PM 29-08-03 -0800, you wrote:

>Is there anyway to setup oracle on the server side to log all fail and 
>error transaction in a file or something? I mean, error/fail 
>transaction due to,
>eg: Integrity Contraint violation, Check constraint, Not Null constraint,
any
>other error.
>
>It would simply debugging since then we don't have to output / catch 
>and send error and SQL statement on the application level.
>
>System: ORACLE 9i on Redhat Linux 7.3
>
>Thanks.
>RDB
>--
>Reuben D. Budiardja
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Reuben D. Budiardja
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- 858-538-5051 http://www.fatcity.com
>San Diego, California-- Mailing list and web hosting services
>-
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the 
>message BODY, include a line containing: UNSUB ORACLE-L (or the name of 
>mailing list you want to be removed from).  You may also send the HELP 
>command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  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: Jack van Zanen
  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

RE: How to keep "root" out?

[Sinardy Xing]

I have an idea

1. Use let say My_Tursted_SA schema, write a trigger that will disconnect new login as 
SYS or SYSTEM 
2. If you want to use sys or system, you login as My_Trusted_SA disable the trigger.

What do you think?


Sinardy

-Original Message-
Richard Ji
Sent: 31 August 2003 13:39
To: Multiple recipients of list ORACLE-L


A strange loop eh?  You must have read GEB. :)


-Original Message-
From:   Tim Gorman [mailto:[EMAIL PROTECTED]
Sent:   Sat 8/30/2003 12:49 AM
To: Multiple recipients of list ORACLE-L
Cc: 
Subject:Re: How to keep "root" out?
A...

But if you encrypt it, where do you keep the key?  How do you retrieve it
for use?  Don¹t forget to follow the problem to the next step...

...and when you do, you realize that if nobody can be trusted, then the
problem of security becomes an Escher print, or a Mobius strip, or the
infinity symbol, or the exact value of ³pi²...



on 8/29/03 9:29 AM, Richard Ji at [EMAIL PROTECTED] wrote:

> We assume the SA don't know much about Oracle.  But if some one is
> particularly interested in
> getting into the database, he might be on this list as well learning all our
> defense mechanisms. :)
> Or doesn't have to be subscribed to it since this list is mirrored other
> places and google is his friend.
> I think the bottom line is, if you absolutely don't want the data to be seen,
> encrypt it.
>  
> My 2 cents.
>  
> Richard Ji
>> -Original Message-
>> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]
>> Sent: Friday, August 29, 2003 10:31 AM
>> To: Multiple recipients of list ORACLE-L
>> Subject: RE: How to keep "root" out?
>> 
> Walt,
>  
> Something that has not been suggested - migrate your database to 9.2.  Connect
> as internal goes away.
>  
> Other than that, I think the best suggestion you got was a conversation, and
> granting access to the v$ tables thru a specific account for that person.
> 
> And then put a long trigger in place tracking all connections to the database.
> Keep track of all SYS connections.  At least you know when things happen.  And
> periodically review the init.ora file for the database to make sure that
> nobody changes anything.
>  
> Good Luck!
>  
> Tom Mercadante 
> Oracle Certified Professional
>> 
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, August 28, 2003 4:50 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Re: How to keep "root" out?
>> 
>> 
>> But someone determined to get in the database can simply edit sqlnet.ora
>> 
>> 
>> 
>> "Tanel Poder" <[EMAIL PROTECTED]>
>> Sent by: [EMAIL PROTECTED]  08/28/2003 10:24 AM
>>  Please respond to ORACLE-L
>> 
>> To:Multiple recipients of list ORACLE-L
>> <[EMAIL PROTECTED]>
>> cc: 
>> Subject:Re: How to keep "root" out?
>> 
>> 
>> Hi! 
>>   
>> Put sqlnet.authentication_services = none in your server's sqlnet.ora. Then
>> everyone has to use a password.
>>   
>> Tanel. 
>>   
>> - Original Message -
>> From: Walter K 
>> To: Multiple recipients of list ORACLE-L 
>> Sent: Thursday, August 28, 2003 6:34 PM
>> Subject: How to keep "root" out?
>> 
>> Just for grins, I'll ask this question... Is there any way to keep the Unix
>> "root" user from logging into the database (i.e. connect internal or / as
>> sysdba)? Currently using 8.1.7.4 on Solaris 8 here.
>>   
>> We have a couple people in our Unix admin group that feel the need to "help"
>> by writing their own DB monitoring scripts. Of course, they don't know what
>> they're talking about. They do not have formal logins for the database, but
>> since they are root users they are connecting via "connect internal". This is
>> not only counterproductive but actually a potential security issue--just
>> because someone has root doesn't necessarily entitle them to see the data in
>> the database. What if it is a payroll database?
>>   
>> So, I'm curious, is there any way to prevent access via "connect internal" or
>> "/ as sysdba"? 
>>   
>> Thanks in advance.
>>   
>> W 
>> 
> 



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sinardy Xing
  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).