f



Lots of Oracle10g Audit Log Files, Created every one or two second(s)

This is Oracle10g RAC, and there are lots of audit log files created
by default under $ORACLE_HOME/rdbms/audit folder, they got created
every one or two second(s) on each node, for each database instance
running on this RAC.

The following is one entry. As you can see, it does not have "CLIENT
TERMINAL" information, and I don't know how to track this to find out
which processes or application or background process is causing this
sys login, so frequently.

Any ideas?
Thanks,
Hai

Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options
ORACLE_HOME = /home/oracle/app/product/10.1.0.4
System name:    Linux
Node name:      wpprddb1
Release:        2.4.21-37.ELsmp
Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
Machine:        i686
Instance name: oid1
Redo thread mounted by this instance: 1
Oracle process number: 26
Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)

Fri Apr 13 17:25:06 2007
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL:
STATUS: 0

0
haiwu.us (9)
4/13/2007 10:28:30 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

15 Replies
644 Views

Similar Articles

[PageSpeed] 49

haiwu.us@gmail.com wrote:
> This is Oracle10g RAC, and there are lots of audit log files created
> by default under $ORACLE_HOME/rdbms/audit folder, they got created
> every one or two second(s) on each node, for each database instance
> running on this RAC.
> 
> The following is one entry. As you can see, it does not have "CLIENT
> TERMINAL" information, and I don't know how to track this to find out
> which processes or application or background process is causing this
> sys login, so frequently.
> 
> Any ideas?
> Thanks,
> Hai
> 
> Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> With the Partitioning, Real Application Clusters, OLAP and Data Mining
> options
> ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> System name:    Linux
> Node name:      wpprddb1
> Release:        2.4.21-37.ELsmp
> Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> Machine:        i686
> Instance name: oid1
> Redo thread mounted by this instance: 1
> Oracle process number: 26
> Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
> 
> Fri Apr 13 17:25:06 2007
> ACTION : 'CONNECT'
> DATABASE USER: '/'
> PRIVILEGE : SYSDBA
> CLIENT USER: oracle
> CLIENT TERMINAL:
> STATUS: 0

SELECT name, value
FROM gv$parameter
WHERE name LIKE '%audit%';

What are you auditing and how?
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
0
damorgan3 (6326)
4/14/2007 3:29:42 AM
On Apr 13, 10:29 pm, DA Morgan <damor...@psoug.org> wrote:
> haiwu...@gmail.com wrote:
> > This is Oracle10g RAC, and there are lots of audit log files created
> > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > every one or two second(s) on each node, for each database instance
> > running on this RAC.
>
> > The following is one entry. As you can see, it does not have "CLIENT
> > TERMINAL" information, and I don't know how to track this to find out
> > which processes or application or background process is causing this
> > sys login, so frequently.
>
> > Any ideas?
> > Thanks,
> > Hai
>
> > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > options
> > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > System name:    Linux
> > Node name:      wpprddb1
> > Release:        2.4.21-37.ELsmp
> > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > Machine:        i686
> > Instance name: oid1
> > Redo thread mounted by this instance: 1
> > Oracle process number: 26
> > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > Fri Apr 13 17:25:06 2007
> > ACTION : 'CONNECT'
> > DATABASE USER: '/'
> > PRIVILEGE : SYSDBA
> > CLIENT USER: oracle
> > CLIENT TERMINAL:
> > STATUS: 0
>
> SELECT name, value
> FROM gv$parameter
> WHERE name LIKE '%audit%';
>
> What are you auditing and how?
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Even if not enabling audit_trail, Oracle by default will write sysdba
logon information to ~/rdbms/audit folder. The following are the
outputs:

audit_sys_operations                FALSE
audit_file_dest                     /home/oracle/app/product/10.1.0.4/
rdbms/audit
audit_trail                         NONE
audit_sys_operations                FALSE
audit_file_dest                     /home/oracle/app/product/10.1.0.4/
rdbms/audit
audit_trail                         NONE
audit_sys_operations                FALSE
audit_file_dest                     /home/oracle/app/product/10.1.0.4/
rdbms/audit
audit_trail                         NONE
audit_sys_operations                FALSE
audit_file_dest                     /home/oracle/app/product/10.1.0.4/
rdbms/audit

NAME                                VALUE
-----------------------------------
--------------------------------------------------------------------------------
audit_trail                         NONE
audit_sys_operations                FALSE
audit_file_dest                     /home/oracle/app/product/10.1.0.4/
rdbms/audit
audit_trail                         NONE

15 rows selected.

Thanks,
Hai

0
haiwu.us (9)
4/14/2007 3:45:43 AM
haiwu.us@gmail.com wrote:
> On Apr 13, 10:29 pm, DA Morgan <damor...@psoug.org> wrote:
>> haiwu...@gmail.com wrote:
>>> This is Oracle10g RAC, and there are lots of audit log files created
>>> by default under $ORACLE_HOME/rdbms/audit folder, they got created
>>> every one or two second(s) on each node, for each database instance
>>> running on this RAC.
>>> The following is one entry. As you can see, it does not have "CLIENT
>>> TERMINAL" information, and I don't know how to track this to find out
>>> which processes or application or background process is causing this
>>> sys login, so frequently.
>>> Any ideas?
>>> Thanks,
>>> Hai
>>> Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
>>> Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
>>> With the Partitioning, Real Application Clusters, OLAP and Data Mining
>>> options
>>> ORACLE_HOME = /home/oracle/app/product/10.1.0.4
>>> System name:    Linux
>>> Node name:      wpprddb1
>>> Release:        2.4.21-37.ELsmp
>>> Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
>>> Machine:        i686
>>> Instance name: oid1
>>> Redo thread mounted by this instance: 1
>>> Oracle process number: 26
>>> Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>>> Fri Apr 13 17:25:06 2007
>>> ACTION : 'CONNECT'
>>> DATABASE USER: '/'
>>> PRIVILEGE : SYSDBA
>>> CLIENT USER: oracle
>>> CLIENT TERMINAL:
>>> STATUS: 0
>> SELECT name, value
>> FROM gv$parameter
>> WHERE name LIKE '%audit%';
>>
>> What are you auditing and how?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor...@x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
> 
> Even if not enabling audit_trail, Oracle by default will write sysdba
> logon information to ~/rdbms/audit folder. The following are the
> outputs:
> 
> audit_sys_operations                FALSE
> audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> rdbms/audit
> audit_trail                         NONE
> audit_sys_operations                FALSE
> audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> rdbms/audit
> audit_trail                         NONE
> audit_sys_operations                FALSE
> audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> rdbms/audit
> audit_trail                         NONE
> audit_sys_operations                FALSE
> audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> rdbms/audit
> 
> NAME                                VALUE
> -----------------------------------
> --------------------------------------------------------------------------------
> audit_trail                         NONE
> audit_sys_operations                FALSE
> audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> rdbms/audit
> audit_trail                         NONE
> 
> 15 rows selected.
> 
> Thanks,
> Hai

I see no evidence of auditing here. So how has the auditing been
implemented?
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
0
damorgan3 (6326)
4/14/2007 8:32:07 PM
On Apr 13, 6:28 pm, haiwu...@gmail.com wrote:
> This is Oracle10g RAC, and there are lots of audit log files created
> by default under $ORACLE_HOME/rdbms/audit folder, they got created
> every one or two second(s) on each node, for each database instance
> running on this RAC.
>
> The following is one entry. As you can see, it does not have "CLIENT
> TERMINAL" information, and I don't know how to track this to find out
> which processes or application or background process is causing this
> sys login, so frequently.
>
> Any ideas?
> Thanks,
> Hai
>
> Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> With the Partitioning, Real Application Clusters, OLAP and Data Mining
> options
> ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> System name:    Linux
> Node name:      wpprddb1
> Release:        2.4.21-37.ELsmp
> Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> Machine:        i686
> Instance name: oid1
> Redo thread mounted by this instance: 1
> Oracle process number: 26
> Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> Fri Apr 13 17:25:06 2007
> ACTION : 'CONNECT'
> DATABASE USER: '/'
> PRIVILEGE : SYSDBA
> CLIENT USER: oracle
> CLIENT TERMINAL:
> STATUS: 0

You could create an after logon database trigger and get some
additional info from that trigger.  Enable it briefly to get the info
you need then disable it promptly.

0
johnbhurley (2707)
4/15/2007 12:22:20 AM
This looks like it is is a connect / as sysdba which is always audited.  
I think that kind of connect can only come from the Linux database 
server.  You might be able to identify the Linux process by listing all 
processes owned by oracle and trying to match it with the pid in the 
..aud file.  In HPUX, this is 
ps -ef|grep oracle

HTH,
Andy Young

haiwu.us@gmail.com wrote in news:1176503310.079589.89440
@w1g2000hsg.googlegroups.com:

> This is Oracle10g RAC, and there are lots of audit log files created
> by default under $ORACLE_HOME/rdbms/audit folder, they got created
> every one or two second(s) on each node, for each database instance
> running on this RAC.
> 
> The following is one entry. As you can see, it does not have "CLIENT
> TERMINAL" information, and I don't know how to track this to find out
> which processes or application or background process is causing this
> sys login, so frequently.
> 
> Any ideas?
> Thanks,
> Hai
> 
> Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> With the Partitioning, Real Application Clusters, OLAP and Data Mining
> options
> ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> System name:    Linux
> Node name:      wpprddb1
> Release:        2.4.21-37.ELsmp
> Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> Machine:        i686
> Instance name: oid1
> Redo thread mounted by this instance: 1
> Oracle process number: 26
> Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
> 
> Fri Apr 13 17:25:06 2007
> ACTION : 'CONNECT'
> DATABASE USER: '/'
> PRIVILEGE : SYSDBA
> CLIENT USER: oracle
> CLIENT TERMINAL:
> STATUS: 0
> 

0
4/16/2007 5:31:17 AM
If you log into the database as sysdba, there will always be a
ora*.aud file that is created for that session in the audit_file_dest
directory. This cannot be disabled - something to do with C2 (?) level
security.

HTH.

0
wagen123 (118)
4/16/2007 5:10:04 PM
On Apr 16, 12:31 am, Digeratus 2006
<digeratus2...@nospam.hotmaildotcom> wrote:
> This looks like it is is a connect / as sysdba which is always audited.  
> I think that kind of connect can only come from the Linux database
> server.  You might be able to identify the Linux process by listing all
> processes owned by oracle and trying to match it with the pid in the
> .aud file.  In HPUX, this is
> ps -ef|grep oracle
>
> HTH,
> Andy Young
>
> haiwu...@gmail.com wrote in news:1176503310.079589.89440
> @w1g2000hsg.googlegroups.com:
>
>
>
> > This is Oracle10g RAC, and there are lots of audit log files created
> > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > every one or two second(s) on each node, for each database instance
> > running on this RAC.
>
> > The following is one entry. As you can see, it does not have "CLIENT
> > TERMINAL" information, and I don't know how to track this to find out
> > which processes or application or background process is causing this
> > sys login, so frequently.
>
> > Any ideas?
> > Thanks,
> > Hai
>
> > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > options
> > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > System name:    Linux
> > Node name:      wpprddb1
> > Release:        2.4.21-37.ELsmp
> > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > Machine:        i686
> > Instance name: oid1
> > Redo thread mounted by this instance: 1
> > Oracle process number: 26
> > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > Fri Apr 13 17:25:06 2007
> > ACTION : 'CONNECT'
> > DATABASE USER: '/'
> > PRIVILEGE : SYSDBA
> > CLIENT USER: oracle
> > CLIENT TERMINAL:
> > STATUS: 0- Hide quoted text -
>
> - Show quoted text -

The connection were done so fast, it is not possible for me to capture
it.

0
haiwu.us (9)
4/19/2007 11:19:05 PM
On Apr 16, 12:10 pm, wagen...@yahoo.com wrote:
> If you log into the database as sysdba, there will always be a
> ora*.aud file that is created for that session in the audit_file_dest
> directory. This cannot be disabled - something to do with C2 (?) level
> security.
>
> HTH.

I know about this, nobody's doing anything on the database, they got
created autoamatically, I think this might be a RAC related bug.

0
haiwu.us (9)
4/19/2007 11:20:08 PM
On Apr 14, 3:32 pm, DA Morgan <damor...@psoug.org> wrote:
> haiwu...@gmail.com wrote:
> > On Apr 13, 10:29 pm, DA Morgan <damor...@psoug.org> wrote:
> >> haiwu...@gmail.com wrote:
> >>> This is Oracle10g RAC, and there are lots of audit log files created
> >>> by default under $ORACLE_HOME/rdbms/audit folder, they got created
> >>> every one or two second(s) on each node, for each database instance
> >>> running on this RAC.
> >>> The following is one entry. As you can see, it does not have "CLIENT
> >>> TERMINAL" information, and I don't know how to track this to find out
> >>> which processes or application or background process is causing this
> >>> sys login, so frequently.
> >>> Any ideas?
> >>> Thanks,
> >>> Hai
> >>> Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> >>> Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> >>> With the Partitioning, Real Application Clusters, OLAP and Data Mining
> >>> options
> >>> ORACLE_HOME =3D /home/oracle/app/product/10.1.0.4
> >>> System name:    Linux
> >>> Node name:      wpprddb1
> >>> Release:        2.4.21-37.ELsmp
> >>> Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> >>> Machine:        i686
> >>> Instance name: oid1
> >>> Redo thread mounted by this instance: 1
> >>> Oracle process number: 26
> >>> Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
> >>> Fri Apr 13 17:25:06 2007
> >>> ACTION : 'CONNECT'
> >>> DATABASE USER: '/'
> >>> PRIVILEGE : SYSDBA
> >>> CLIENT USER: oracle
> >>> CLIENT TERMINAL:
> >>> STATUS: 0
> >> SELECT name, value
> >> FROM gv$parameter
> >> WHERE name LIKE '%audit%';
>
> >> What are you auditing and how?
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damor...@x.washington.edu
> >> (replace x with u to respond)
> >> Puget Sound Oracle Users Groupwww.psoug.org
>
> > Even if not enabling audit_trail, Oracle by default will write sysdba
> > logon information to ~/rdbms/audit folder. The following are the
> > outputs:
>
> > audit_sys_operations                FALSE
> > audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> > rdbms/audit
> > audit_trail                         NONE
> > audit_sys_operations                FALSE
> > audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> > rdbms/audit
> > audit_trail                         NONE
> > audit_sys_operations                FALSE
> > audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> > rdbms/audit
> > audit_trail                         NONE
> > audit_sys_operations                FALSE
> > audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> > rdbms/audit
>
> > NAME                                VALUE
> > -----------------------------------
> > -----------------------------------------------------------------------=
----=AD-----
> > audit_trail                         NONE
> > audit_sys_operations                FALSE
> > audit_file_dest                     /home/oracle/app/product/10.1.0.4/
> > rdbms/audit
> > audit_trail                         NONE
>
> > 15 rows selected.
>
> > Thanks,
> > Hai
>
> I see no evidence of auditing here. So how has the auditing been
> implemented?
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

According to Oracle doc, these audits are implemented by default.

0
haiwu.us (9)
4/19/2007 11:20:58 PM
On Apr 19, 7:19 pm, haiwu...@gmail.com wrote:
> On Apr 16, 12:31 am, Digeratus 2006
>
>
>
>
>
> <digeratus2...@nospam.hotmaildotcom> wrote:
> > This looks like it is is a connect / as sysdba which is always audited.  
> > I think that kind of connect can only come from the Linux database
> > server.  You might be able to identify the Linux process by listing all
> > processes owned by oracle and trying to match it with the pid in the
> > .aud file.  In HPUX, this is
> > ps -ef|grep oracle
>
> > HTH,
> > Andy Young
>
> > haiwu...@gmail.com wrote in news:1176503310.079589.89440
> > @w1g2000hsg.googlegroups.com:
>
> > > This is Oracle10g RAC, and there are lots of audit log files created
> > > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > > every one or two second(s) on each node, for each database instance
> > > running on this RAC.
>
> > > The following is one entry. As you can see, it does not have "CLIENT
> > > TERMINAL" information, and I don't know how to track this to find out
> > > which processes or application or background process is causing this
> > > sys login, so frequently.
>
> > > Any ideas?
> > > Thanks,
> > > Hai
>
> > > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > > options
> > > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > > System name:    Linux
> > > Node name:      wpprddb1
> > > Release:        2.4.21-37.ELsmp
> > > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > > Machine:        i686
> > > Instance name: oid1
> > > Redo thread mounted by this instance: 1
> > > Oracle process number: 26
> > > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > > Fri Apr 13 17:25:06 2007
> > > ACTION : 'CONNECT'
> > > DATABASE USER: '/'
> > > PRIVILEGE : SYSDBA
> > > CLIENT USER: oracle
> > > CLIENT TERMINAL:
> > > STATUS: 0- Hide quoted text -
>
> > - Show quoted text -
>
> The connection were done so fast, it is not possible for me to capture
> it.- Hide quoted text -
>
> - Show quoted text -

That's why I suggested using an after logon database trigger ... have
it enabled for just a brief period of time.

There's no way for a connection request to escape from the ater logon
trigger.

0
johnbhurley (2707)
4/19/2007 11:25:18 PM
On Apr 19, 6:25 pm, hpuxrac <johnbhur...@sbcglobal.net> wrote:
> On Apr 19, 7:19 pm, haiwu...@gmail.com wrote:
>
>
>
> > On Apr 16, 12:31 am, Digeratus 2006
>
> > <digeratus2...@nospam.hotmaildotcom> wrote:
> > > This looks like it is is a connect / as sysdba which is always audited.
> > > I think that kind of connect can only come from the Linux database
> > > server.  You might be able to identify the Linux process by listing all
> > > processes owned by oracle and trying to match it with the pid in the
> > > .aud file.  In HPUX, this is
> > > ps -ef|grep oracle
>
> > > HTH,
> > > Andy Young
>
> > > haiwu...@gmail.com wrote in news:1176503310.079589.89440
> > > @w1g2000hsg.googlegroups.com:
>
> > > > This is Oracle10g RAC, and there are lots of audit log files created
> > > > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > > > every one or two second(s) on each node, for each database instance
> > > > running on this RAC.
>
> > > > The following is one entry. As you can see, it does not have "CLIENT
> > > > TERMINAL" information, and I don't know how to track this to find out
> > > > which processes or application or background process is causing this
> > > > sys login, so frequently.
>
> > > > Any ideas?
> > > > Thanks,
> > > > Hai
>
> > > > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > > > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > > > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > > > options
> > > > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > > > System name:    Linux
> > > > Node name:      wpprddb1
> > > > Release:        2.4.21-37.ELsmp
> > > > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > > > Machine:        i686
> > > > Instance name: oid1
> > > > Redo thread mounted by this instance: 1
> > > > Oracle process number: 26
> > > > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > > > Fri Apr 13 17:25:06 2007
> > > > ACTION : 'CONNECT'
> > > > DATABASE USER: '/'
> > > > PRIVILEGE : SYSDBA
> > > > CLIENT USER: oracle
> > > > CLIENT TERMINAL:
> > > > STATUS: 0- Hide quoted text -
>
> > > - Show quoted text -
>
> > The connection were done so fast, it is not possible for me to capture
> > it.- Hide quoted text -
>
> > - Show quoted text -
>
> That's why I suggested using an after logon database trigger ... have
> it enabled for just a brief period of time.
>
> There's no way for a connection request to escape from the ater logon
> trigger.

I've been thinking about it, but I am not sure if the information the
logon trigger captures would be helpful or not ...

0
haiwu.us (9)
4/20/2007 6:02:08 AM
On Apr 20, 2:02 am, haiwu...@gmail.com wrote:
> On Apr 19, 6:25 pm, hpuxrac <johnbhur...@sbcglobal.net> wrote:
>
>
>
> > On Apr 19, 7:19 pm, haiwu...@gmail.com wrote:
>
> > > On Apr 16, 12:31 am, Digeratus 2006
>
> > > <digeratus2...@nospam.hotmaildotcom> wrote:
> > > > This looks like it is is a connect / as sysdba which is always audited.
> > > > I think that kind of connect can only come from the Linux database
> > > > server.  You might be able to identify the Linux process by listing all
> > > > processes owned by oracle and trying to match it with the pid in the
> > > > .aud file.  In HPUX, this is
> > > > ps -ef|grep oracle
>
> > > > HTH,
> > > > Andy Young
>
> > > > haiwu...@gmail.com wrote in news:1176503310.079589.89440
> > > > @w1g2000hsg.googlegroups.com:
>
> > > > > This is Oracle10g RAC, and there are lots of audit log files created
> > > > > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > > > > every one or two second(s) on each node, for each database instance
> > > > > running on this RAC.
>
> > > > > The following is one entry. As you can see, it does not have "CLIENT
> > > > > TERMINAL" information, and I don't know how to track this to find out
> > > > > which processes or application or background process is causing this
> > > > > sys login, so frequently.
>
> > > > > Any ideas?
> > > > > Thanks,
> > > > > Hai
>
> > > > > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > > > > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > > > > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > > > > options
> > > > > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > > > > System name:    Linux
> > > > > Node name:      wpprddb1
> > > > > Release:        2.4.21-37.ELsmp
> > > > > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > > > > Machine:        i686
> > > > > Instance name: oid1
> > > > > Redo thread mounted by this instance: 1
> > > > > Oracle process number: 26
> > > > > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > > > > Fri Apr 13 17:25:06 2007
> > > > > ACTION : 'CONNECT'
> > > > > DATABASE USER: '/'
> > > > > PRIVILEGE : SYSDBA
> > > > > CLIENT USER: oracle
> > > > > CLIENT TERMINAL:
> > > > > STATUS: 0- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > The connection were done so fast, it is not possible for me to capture
> > > it.- Hide quoted text -
>
> > > - Show quoted text -
>
> > That's why I suggested using an after logon database trigger ... have
> > it enabled for just a brief period of time.
>
> > There's no way for a connection request to escape from the ater logon
> > trigger.
>
> I've been thinking about it, but I am not sure if the information the
> logon trigger captures would be helpful or not ...

And it would be dangerous as well -- the reason SYSDBA logins are
audited to a file rather than the DB is that you want to be able to
login to the DB as sysdba and fix a startup/mounting/disk error - type
problem. I don't know what type of process is causing the SYS
connections (some sort of RAC heartbeat connection?), but the behavior
doesn't sound like a bug to me...

0
4/20/2007 12:13:36 PM
On Apr 20, 8:13 am, BicycleRepairman <engel.ke...@gmail.com> wrote:
> On Apr 20, 2:02 am, haiwu...@gmail.com wrote:
>
>
>
>
>
> > On Apr 19, 6:25 pm, hpuxrac <johnbhur...@sbcglobal.net> wrote:
>
> > > On Apr 19, 7:19 pm, haiwu...@gmail.com wrote:
>
> > > > On Apr 16, 12:31 am, Digeratus 2006
>
> > > > <digeratus2...@nospam.hotmaildotcom> wrote:
> > > > > This looks like it is is a connect / as sysdba which is always audited.
> > > > > I think that kind of connect can only come from the Linux database
> > > > > server.  You might be able to identify the Linux process by listing all
> > > > > processes owned by oracle and trying to match it with the pid in the
> > > > > .aud file.  In HPUX, this is
> > > > > ps -ef|grep oracle
>
> > > > > HTH,
> > > > > Andy Young
>
> > > > > haiwu...@gmail.com wrote in news:1176503310.079589.89440
> > > > > @w1g2000hsg.googlegroups.com:
>
> > > > > > This is Oracle10g RAC, and there are lots of audit log files created
> > > > > > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > > > > > every one or two second(s) on each node, for each database instance
> > > > > > running on this RAC.
>
> > > > > > The following is one entry. As you can see, it does not have "CLIENT
> > > > > > TERMINAL" information, and I don't know how to track this to find out
> > > > > > which processes or application or background process is causing this
> > > > > > sys login, so frequently.
>
> > > > > > Any ideas?
> > > > > > Thanks,
> > > > > > Hai
>
> > > > > > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > > > > > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > > > > > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > > > > > options
> > > > > > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > > > > > System name:    Linux
> > > > > > Node name:      wpprddb1
> > > > > > Release:        2.4.21-37.ELsmp
> > > > > > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > > > > > Machine:        i686
> > > > > > Instance name: oid1
> > > > > > Redo thread mounted by this instance: 1
> > > > > > Oracle process number: 26
> > > > > > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > > > > > Fri Apr 13 17:25:06 2007
> > > > > > ACTION : 'CONNECT'
> > > > > > DATABASE USER: '/'
> > > > > > PRIVILEGE : SYSDBA
> > > > > > CLIENT USER: oracle
> > > > > > CLIENT TERMINAL:
> > > > > > STATUS: 0- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > The connection were done so fast, it is not possible for me to capture
> > > > it.- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > That's why I suggested using an after logon database trigger ... have
> > > it enabled for just a brief period of time.
>
> > > There's no way for a connection request to escape from the ater logon
> > > trigger.
>
> > I've been thinking about it, but I am not sure if the information the
> > logon trigger captures would be helpful or not ...
>
> And it would be dangerous as well -- the reason SYSDBA logins are
> audited to a file rather than the DB is that you want to be able to
> login to the DB as sysdba and fix a startup/mounting/disk error - type
> problem. I don't know what type of process is causing the SYS
> connections (some sort of RAC heartbeat connection?), but the behavior
> doesn't sound like a bug to me...- Hide quoted text -
>
> - Show quoted text -

Activating for a brief period of time an after logon trigger that is
looking for sysdba logins to gain extra information that the OP hasn't
been able to obtain to date is "dangerous as well" exactly how?

And your helpfule advice "I don't know what type of process is
causing ..."

0
johnbhurley (2707)
4/21/2007 1:06:33 AM
On Apr 20, 9:06 pm, hpuxrac <johnbhur...@sbcglobal.net> wrote:
> On Apr 20, 8:13 am, BicycleRepairman <engel.ke...@gmail.com> wrote:
>
>
>
> > On Apr 20, 2:02 am, haiwu...@gmail.com wrote:
>
> > > On Apr 19, 6:25 pm, hpuxrac <johnbhur...@sbcglobal.net> wrote:
>
> > > > On Apr 19, 7:19 pm, haiwu...@gmail.com wrote:
>
> > > > > On Apr 16, 12:31 am, Digeratus 2006
>
> > > > > <digeratus2...@nospam.hotmaildotcom> wrote:
> > > > > > This looks like it is is a connect / as sysdba which is always audited.
> > > > > > I think that kind of connect can only come from the Linux database
> > > > > > server.  You might be able to identify the Linux process by listing all
> > > > > > processes owned by oracle and trying to match it with the pid in the
> > > > > > .aud file.  In HPUX, this is
> > > > > > ps -ef|grep oracle
>
> > > > > > HTH,
> > > > > > Andy Young
>
> > > > > > haiwu...@gmail.com wrote in news:1176503310.079589.89440
> > > > > > @w1g2000hsg.googlegroups.com:
>
> > > > > > > This is Oracle10g RAC, and there are lots of audit log files created
> > > > > > > by default under $ORACLE_HOME/rdbms/audit folder, they got created
> > > > > > > every one or two second(s) on each node, for each database instance
> > > > > > > running on this RAC.
>
> > > > > > > The following is one entry. As you can see, it does not have "CLIENT
> > > > > > > TERMINAL" information, and I don't know how to track this to find out
> > > > > > > which processes or application or background process is causing this
> > > > > > > sys login, so frequently.
>
> > > > > > > Any ideas?
> > > > > > > Thanks,
> > > > > > > Hai
>
> > > > > > > Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
> > > > > > > Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
> > > > > > > With the Partitioning, Real Application Clusters, OLAP and Data Mining
> > > > > > > options
> > > > > > > ORACLE_HOME = /home/oracle/app/product/10.1.0.4
> > > > > > > System name:    Linux
> > > > > > > Node name:      wpprddb1
> > > > > > > Release:        2.4.21-37.ELsmp
> > > > > > > Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
> > > > > > > Machine:        i686
> > > > > > > Instance name: oid1
> > > > > > > Redo thread mounted by this instance: 1
> > > > > > > Oracle process number: 26
> > > > > > > Unix process pid: 17242, image: oracle@wpprddb1 (TNS V1-V3)
>
> > > > > > > Fri Apr 13 17:25:06 2007
> > > > > > > ACTION : 'CONNECT'
> > > > > > > DATABASE USER: '/'
> > > > > > > PRIVILEGE : SYSDBA
> > > > > > > CLIENT USER: oracle
> > > > > > > CLIENT TERMINAL:
> > > > > > > STATUS: 0- Hide quoted text -
>
> > > > > > - Show quoted text -
>
> > > > > The connection were done so fast, it is not possible for me to capture
> > > > > it.- Hide quoted text -
>
> > > > > - Show quoted text -
>
> > > > That's why I suggested using an after logon database trigger ... have
> > > > it enabled for just a brief period of time.
>
> > > > There's no way for a connection request to escape from the ater logon
> > > > trigger.
>
> > > I've been thinking about it, but I am not sure if the information the
> > > logon trigger captures would be helpful or not ...
>
> > And it would be dangerous as well -- the reason SYSDBA logins are
> > audited to a file rather than the DB is that you want to be able to
> > login to the DB as sysdba and fix a startup/mounting/disk error - type
> > problem. I don't know what type of process is causing the SYS
> > connections (some sort of RAC heartbeat connection?), but the behavior
> > doesn't sound like a bug to me...- Hide quoted text -
>
> > - Show quoted text -
>
> Activating for a brief period of time an after logon trigger that is
> looking for sysdba logins to gain extra information that the OP hasn't
> been able to obtain to date is "dangerous as well" exactly how?
>
> And your helpfule advice "I don't know what type of process is
> causing ..."

tell you what -- why don't you set one up in your production
environment -- then delete a datafile -- and tell us whether you can
connect as sysdba in order to recover the database. If you can, then
setting one up is merely dangerous. If you can't, it's more like
fatal.
Have fun.

0
4/21/2007 4:08:05 AM
On Apr 21, 12:08 am, BicycleRepairman <engel.ke...@gmail.com> wrote:
>
snip
>
> > Activating for a brief period of time an after logon trigger that is
> > looking for sysdba logins to gain extra information that the OP hasn't
> > been able to obtain to date is "dangerous as well" exactly how?
>
> > And your helpfule advice "I don't know what type of process is
> > causing ..."
>
> tell you what -- why don't you set one up in your production
> environment -- then delete a datafile -- and tell us whether you can
> connect as sysdba in order to recover the database. If you can, then
> setting one up is merely dangerous. If you can't, it's more like
> fatal.
> Have fun

You appear to be taking the original question to a whole different
area not that I see the OP ever responding to your posting.

I for one don't see any direct connection ... you want people to
intentionally delete a datafile in their production system?  Not
exactly a really useful suggestion IMHO.

If there's some story that is somehow relevant in this context to what
the OP was asking why don't you let us know what it is.



0
johnbhurley (2707)
4/21/2007 1:33:49 PM
Reply:

Similar Artilces:

Log Shipping to two Databases on One Secondary Server
Is it possible to do SQL log shipping to more than one Databases on same Secondry Server WITH A DIFFERENT SCHEDULE for each log shipping? You can set up log shipping to go to as many servers as you want, but you only get one schedule in the plan. If you set up a second log shipping schedule, you get an error because the server is already set up for log shipping in the other plan. Just wondering if this is possible. For example. I have 2 servers. The Main server needs to ship it's logs to two other databases. (Server A) I want the main server to ship the logs to Server A every 45 min...

How to Add two lines using DCL on open VMS reading one line from one file and second from another file.
Hi All, Can some one please guide me how can i do this using DCL. Problem: We are having two file named Dire.txt Total of 39 files, 61673 blocks. Total of 50 files, 4555 blocks. Second File is size.txt Directory SYS$SYSDEVICE:[000000] Directory SYS$SYSDEVICE:[mandeep] We want output in one file like. Directory SYS$SYSDEVICE:[000000] size of directory will be "Total of 39 files, 61673 blocks". ...... mandeepsangwan1@gmail.com wrote 2014-10-19 12:26: > Hi All, > > Can some one please guide me how can i do this using DCL. > > Problem: We are having two file named Dire.txt > > Total of 39 files, 61673 blocks. > > Total of 50 files, 4555 blocks. > > Second File is size.txt > > Directory SYS$SYSDEVICE:[000000] > Directory SYS$SYSDEVICE:[mandeep] > > We want output in one file like. > > Directory SYS$SYSDEVICE:[000000] size of directory will be "Total of 39 files, 61673 blocks". > > ..... > I do not understand what your files and dirs output is trying to tell, there seems to be missing something. But... 1. Open both input files and the output file. 2. Read one line from each file. 3. Write both lines to the output file. 4. Goto 2. until eof on either file. What to do if the files have different number of lines is up to you. In article <af17e1d7-1d51-4067-91f1-c9bf58704343@googlegroups.com>, mandeepsangwan1@gmail.com writes:...

How to Add two lines using DCL on open VMS reading one line from one file and second from another file.
Hi All, Can some one please guide me how can i do this using DCL. Problem: We are having two file named Dire.txt Total of 39 files, 61673 blocks. Total of 50 files, 4555 blocks. Second File is size.txt Directory SYS$SYSDEVICE:[000000] Directory SYS$SYSDEVICE:[mandeep] We want output in one file like. Directory SYS$SYSDEVICE:[000000] size of directory will be "Total of 39 files, 61673 blocks". ...... Bob Gezelter wrote: > On Sunday, October 19, 2014 6:26:26 AM UTC-4, mandeep...@gmail.com wrote: >> Hi All, >> >> >> >>...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV Girish (kattukuyil@hotmail.co...

How do you combine two JPEG files and create one JPEG file?
I have Adobe Photoshop 5.0 LE and am trying to combine two JPEG files side by side. When I increased the canvas and copied the other JPEG file next to the old one (after moving the old picture to the far left of the canvas) and then tried to save the new picture, it wants to save it as a huge PSD or PDD file. How do I just save it as a JPEG file? Thanks for any help. I am a beginner to this, so I know nothing about layers and masks, etc. Go to Layers/Flatten, then it'll allow you to change your file type to JPG on the save dialog. "ndgreek" <ndgreek@hotmail.com> wrote...

Archive logs files accumulating on my Oracle log mode Database
>From what I understand is that an Oracle log mode Database is the recommended configuration for a production database. However, the problem we have is that Archive Logs files in the ..\RDBMS\ directory are accumulating daily which has implications when you have limited disk space. How should these Archive log files be maintained? ie when should they be deleted from the system? is there an automated procedure which will remove the log files on a weekly basis? I understand that there are two ways for performing a backup of the oracle database, 1) cold backup (requires the oracle database to be shutdown) 2) hot backup Should either of the above backup procedures automatically remove the archive log files once backup has been completed? Thanks in advance. James Osso wrote: >>From what I understand is that an Oracle log mode Database is the > recommended configuration for a production database. However, the Not for all production systems... Data ware houses usually are easier rebuilt than restored. Of course, apply common sense and *your* requirements. > problem we have is that Archive Logs files in the ..\RDBMS\ directory You can configure that - pfile, or spfile - depending on version. > are accumulating daily which has implications when you have limited > disk space. > > How should these Archive log files be maintained? ie when should they > be deleted from the system? is there an automated procedure which will > remove the log file...

Oracle database instance shutdown without logging in log file
oracle database instance shutdown without logging in log file. we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows 2003 R2 for test/simulation purpose, we found that its shutting down the database sometimes unusally without any error/warning message in the SID alert log file. we observerd that the OS service for oracle is not starting the datbase server completely. Just after hitting start icon inside the services panel it displays the status "Starting", instead of "Started" and database is not in the "Open" state. So the method adopted to start the database from services as well using the "Startup" command from server manager utility. Why does this happen? On Apr 17, 12:19 pm, 7guru <7...@naver.com> wrote: > oracle database instance shutdown without logging in log file. > > we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows > 2003 R2 for test/simulation purpose, > we found that its shutting down the database sometimes unusally > without any error/warning message in the SID alert log file. > > we observerd that the OS service for oracle is not starting the > datbase server completely. > Just after hitting start icon inside the services panel it displays > the status "Starting", instead of "Started" > and database is not in the "Open" state. > > So the method adopted to start the database from services as well > using t...

Opening files from one server to another (connect to Apache/Oracle server)
Hi, We have a web setup where we're using two servers, one of which is using an ASP application running a SQL Server database, the other is using Oracle with Apache. Basically, we want users to be able to open files such as Adobe Acrobat PDF documents (which are stored on the Oracle server) via clicking links in pages on the other (SQL) server. We have security set up that each site requires a user ID and password to access site content, so we need to figure out how we can make the sites communicate that when the file link is clicked, the file is opened. We currently get a 404 (Forbidden) message. I've been told that there are stored settings in some header section (not sure if this would be Apache or Oracle doing this) to handle the user ID and password security, so my guess is we need info as to how we can make the sites handshake with this protocol. Any help would be appreciated. Thanks! Brian ...

How to create two pdf files into one pdf file using pdflatex?
Hi, there! I use MikTeX on my PC. I have a tex file, I use pdflatex to create a pdf file. Now my problem is that I have other a pdf file, I want to put two pdf into a pdf file. Does anyone have suggestion to do this? I am like to put some tex code into my tex file, then I run pdflatex, I will create this two pdf files into one pdf file. Thanks! zyx wrote: > Hi, there! > > I use MikTeX on my PC. I have a tex file, I use pdflatex to create a > pdf file. Now my problem is that I have other a pdf file, I want to put > two pdf into a pdf file. Does anyone have suggestion to do this? I am > like to put some tex code into my tex file, then I run pdflatex, I will > create this two pdf files into one pdf file. > Thanks! use the package: pdfpages (remember to read the manual for it) it can do all sorts of nifty things with pdf files -- /daleif (remove RTFSIGNATURE from email address) LaTeX FAQ: http://www.tex.ac.uk/faq AMSMATH Intro: http://www.ams.org/tex/amslatex.html LaTeX Intro: http://people.ee.ethz.ch/~oetiker/lshort/lshort.pdf Graphics Intro: http://www.ctan.org/tex-archive/info/epslatex.pdf Superb Class: http://www.ctan.org/tex-archive/help/Catalogue/entries/memoir.html Remember to post minimal working examples. Dear Madsen; Thank you very much for your answer. It is very useful. However, I want to create a bookmark at first pdf file, I use following lists into my tex file: *****************************************...

how do I transfer files to remote server logging into remote server's $BASH prompt
I'm a nebie and exhausted working with my ISP trying to securely transfer files to the hosting account. I can log into to using PuTTy and get to a $BASH prompt. From there I can use FTP but then I am ftping from THAt server, not my computer. I have tried WinSCP but I don't have SCP on remote server and don't want to load it on server as I am obviously a novice with */nix commands Any ideas? On Mon, 17 Nov 2003 16:43:51 -0500 NotGiven scrawled this disquisition: > I'm a nebie and exhausted working with my ISP trying to securely transfer > files ...

Export two waveforms to one spreadsheet file with one colunm being elapsed time in second?
I'm using LV8.0 under WindowsXP with&nbsp;6024E and BNC-2120&nbsp;board. I am acquiring data from two channel (ai6 and ai7), with 1-d array of waveform. With "index array"&nbsp; I got two waveforms corresponding to data from ai6 and ai7.&nbsp;In this way I&nbsp;can mutiply one waveform with a factor (such as 0.001).&nbsp; Later on, I have to use "Export Waveforms to Spreadsheet File " to get two seperately files. I have to use another For loop to generate an array of time to get the elapsed time (something like 0, 0.1, 0.2, 0.3, ... if the sampling rate is 10Hz). Finally I got three different files. Is there a method to export all data to one file? &nbsp; The ideal format in the final file should have 3 colunms, corresponding to elapsed time, y value of ai7, y value of ai6 multiply some factor(such as 0.001) &nbsp; If I use "Export Waveforms to Spreadsheet File " on the one waveform, I will get a column of time in the format of year/month/day hour/min/second. What I want is the elapsed time, start from 0 till I stop it. &nbsp; Another problem with my current codes is that I always get a error message when I click the "stop" to stop the program, which might because the "close file" at the bottom right is outside the loop. Is there a way to fix it? &nbsp; By the way, is there an easy to do an average on the waveform ( for example, average 5 data points before plot and write to spreads...

Two databases on one server
Is this the wrong approach ? (looking for opinions) Oracle 9.2.0.6 on Solaris 64 We currently have a 10G production database on a first server. We have a copy of that database on another server, used for reporting. The information is copied by having replication turned on for the tables of interest (~100). The update volume generates over 100 * 100Megs redo logs a day. (These include the replication supporting data, right?) We are changing the hardware environment for political reasons, and taking this opportunity to redesign the database environment. We are now going to have a much bigger/more powerfull server, but only one. Does it make sense to have two databases, one for OLTP and one for reporting on the same server? In the short term, it is expected that the historical + denormalization will cause the reporting component of the database to grow to several hundred Gigs of space, while the OLTP component should retain a much slower growth rate (maybe 10G per year). My currents thought were to keep the two DBs, but replace the replication process by using a logical standby. But now I am wondering if everything should be in one database, using multiple schemas and tablespaces, and resource manager ??? Would this noticeably improve performance ? Would I loose or improve the capability to manage resources and performance ? Thanks for your time. Guy. G Quesnel wrote: > Is this the wrong approach ? (looking for opinions) > Oracle 9.2.0.6 on Solaris 64 > We curr...

it's compatible oracle 8i client, compatible whith oracle 9i server (or oracle 10g server)
Hi all, I have a client/server application that work on the client with oracle 8i client connected to oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) , and I wonder if the client will work fine without upgrade version. Thanks Angel R. wrote: > Hi all, > I have a client/server application that work on the client with oracle 8i > client connected to > oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) > , and > I wonder if the client will work fine without upgrade version. > > Thanks If you have access to the metalink then check the connect matrix at http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=207303.1 Regards /Rauf ...

Plotting two files into one plot with different rows in two files
Hello, I browsed all topics about plotting two files into one plot. None of them = mentioned with different rows problems. The scenario I met is as follows: File A is babies standard growth file, which show babies growth chart based= on history data, like 95%, 90%, 75%, 50%, 25%, 10%, and 5%. In this data = file there are only a 5 rows (born, 3 month, 6 month, 9 month and 12 month)= with 8 columns (month + 7 Y values). File B is what parents input. The times they input can be any dates in the= first year (365 possibilities) due to their various measuring time. I nee= d to plot this line also onto the standard's plot. =20 The current code is: plot "A.dat" using 1:2 title '95%' with lines 1, \ "" using 1:3 title '90%' with lines 2, \ "" using 1:4 title '75%' with lines 3, \ "" using 1:5 title '50%' with lines 4, \ "" using 1:6 title '25%' with lines 5, \ "" using 1:7 title '10%' with lines 6, \ "" using 1:8 title '5%' with lines 7, \ "B.dat" using 1:2 title 'your baby' with points 3 But this require rows of A is the same as rows of B. How to handle the problems like this. Do I have to use "least common denom= inator" method, expanding both File A and B into 365 rows and plot? I thin= k this is too clumsy. =20 Any elegant method? Thanks...

create ONE database beyond between 2 server
Hi! I would like to create database. There are two server. But I want to create ONE database between two server.Of course,I install two PostgreSQL in both server. But created database is to be one. Does anyone know how to create one database beyond two server? Regards, Hiro ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match What's the purpose of doing this? Failover? Spread out CPU processing? Why would you want to do this? On M...

create ONE database beyond between 2 server
Hi! I would like to create database. There are two server. But I want to create ONE database between two server.Of course,I install two PostgreSQL in both server. But created database is to be one. Does anyone know how to create one database beyond two server? Regards, Hiro ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match What's the purpose of doing this? Failover? Spread out CPU processing? Why would you want to do this? > On ...

redo log file on Oracle 11g physical database
Parameter 'LOG_FILE_NAME_CONVERT' definition is: " Specify the location of the primary database online redo log files followed by the standby location. This parameter converts the path names of the primary database log files to the path names on the standby database. If the standby database is on the same system as the primary database or if the directory structure where the log files are located on the standby system is different from the primary system, then this parameter is required. Multiple pairs of paths may be specified by this parameter. " As I understand, if the redo log file directory and file name on physical site are the same as on primary site, I don't have to assign any value to this parameter. For example, if '/redo/redo1.log' is one of the redo log files on primary, at the time I create physical db, I just have to create this redo log file as '/redo/redo1.log' on physical site. Correct? Thanks! ...

Oracle management server with only one database going to 9i
We will be changing from a 8.1.7 to Oracle 9i. I would like to impliment some "best practices" right from the start. Being rather green, 5 day dba course, makes you a dba at our shop. I have done some research into Oracle Management server. I was thinking of implementing this in our shop, even though it will only be monitoring one database, possible two. The reason for the management server that perked my interest, in that fact that I can use RMAN for backup, but the real reason was using it for event monitoring. We do not have the man power to continuely look at the alert log, and we are always creating scripts to monitor table sizes, etc. I was wondering if this would be a good thing, and is it commonly used for one database. I am also looking at how much overhead it needs. Size RAM ect. Is there a good READ about this? Is there any best practices for moving to 9i? handl@mts.net (Laura) wrote in message news:<e0ddcf8.0407060608.634328b7@posting.google.com>... > We will be changing from a 8.1.7 to Oracle 9i. > > I would like to impliment some "best practices" right from the start. > Being rather green, 5 day dba course, makes you a dba at our shop. I > have done some research into Oracle Management server. > > I was thinking of implementing this in our shop, even though it will > only be monitoring one database, possible two. > The reason for the management server that perked my interest, in that > fact that I ...

I need to move oracle database from one to another server
Hello. Please take into consideratio a scenarrio... on left and hardware the same server on right SUN server SUN server Solaris Oracle database And now. Left server is working. But I stopped whole server one month ago and did _full_ backup of all filesystems. After that server and database were operating back for one month. Now. I have second SUN identical server on the right. I did full restore on this server (of all filesystems). But of course database is not up to date. I can stop oracle on left and move some files to right server. My idea is to do: On the right (new server) remove all (old) dbf files, controll files, redologs. Copy files from the original server (on left) that are has been in "work" for recent month to the second server: dbf files control files and redo logs. Then start new server on right? Is it all I have to do? Or I will meet any problems? Regards On Fri, 08 Oct 2004 07:07:27 GMT, "marqzik" <marqzik@wp.pl> wrote: >Hello. Please take into consideratio a scenarrio... >on left and hardware the same server on right > >SUN server SUN server >Solaris >Oracle database > >And now. >Left server is working. >But I stopped whole server one month ago and did _full_ backup of all >filesystems. >After that server and database were operating back for one month. >Now. >I have second SUN identical server on the right. ...

Tcl script for creating folders on multiple remote servers from local machines and transfer files to those servers into created folder
Hi all, I am newbie in Tcl. I have just started learning Tcl fundamentals I want to code a script that does the following. 1) Reads a file in which server names and corresponding ip addresses are saved. (Approx 5) name1 <space> xxx.xxx.x.xxx name2 <space> xxx.xxx.x.xxx name3 <space> xxx.xxx.x.xxx name4 <space> xxx.xxx.x.xxx name5 <space> xxx.xxx.x.xxx -this is file which will be having server name and ip addresses as above format. 2) Takes 1st name and ip, telnet to the server, enters username and password. 3) creates a directory. 4) Transfers the file via FTP to created directory. 5) logout from the server. 6) Reads second entry in the file repeats from step2 until all server IPs are not covered. I am able to make a directory by using telnet session and by using list (for server name and IPs). But I am unable to use file for getting name and IPs of server. And also transfer a file via FTP to created Directory. Can you please help me Hi kj, I can't help you with all of that. I have no idea how to do that, but from what I know, Expect is the tool you should look for, which seems to work with Tcl as well: http://wiki.tcl.tk/201 I guess you can write a script and Expect knows Tcl commands and extends Tcl with some more commands to do the server/login-stuff. ############################### namespace eval ::srvupdate {} proc ::srvupdate::ReadSrvs {} { set srv_file "../servers.dat" set ret_list [list] if [catch {open ...

Restore of database file and log file
Hi, I have a Sybase Adaptive Server Anywhere 7 database running. I have a database file that is dated june 12, 2003 I have the database log file from yesterday. The backupsoftware have not backed up the database file since june 12 because it did not back up open files. So, can i merge my database file frome june 12 and my logfile from yesterday and have all the changes since june 12 committed ? If, so how do i do it ? Can't see any tools in the Sybase Central that can help me out... This is a library database and my librarian is not happy at the moment..... Hiya, If the transaction log has not been truncated since, I'd say you can apply the log file. Otherwise you can force the log using dbtran and translate it to SQL and apply the SQL to the database. This is a bit risky, you may miss a lot of transactions since the last checkpoint until the time this log got created. Cheers, Willy -- Posted via http://dbforums.com ...

How do I recover data from SQL Server's log files?
Dear All, One of our employee made a mistake and deleted something from database. I would like to recover that log file without restoring the backup and the other log files. The reason I want to do this is our database is getting real time information I cannot shut down the database. Is there any way to do this please let me know and help me . Kindly regards LS laststubborn wrote: > One of our employee made a mistake and deleted something from database. > I would like to recover that log file without restoring the backup and > the other log files. The reason I want to do this is...

One - Two, One
It's the Gizmondo crew! Yo! Check out this software on tha Gizmondo stand at a recent Cebit exhibition. http://video.google.com/videoplay?docid=-2239941528715060334 Different ta wizzy i was jizzle a boi. PCW 1986 it ain't. The booty-slapp'n hos is doggy stylin' tha attention. The Gizmondo was designed by tha poser of tha ZX Spectrum but this software is bustin' hizzy changed. http://www.theproductdesigners.com/ Noth'n is tha same so show some love. Playas is mackin' this kind of clockin'. http://video.google.com/videoplay?docid=-6775033602778495998 ...

Why Oracle creates two shared memory segments instead of one?
I noticed that on some platforms Oracle always creates two shared memory segments instead of one, even when both segments are much smaller than the limit. For example, on this Tru64 box the limit is set to 2 GB: oracle > sysconfig -q ipc ipc: msg_max = 8192 msg_mnb = 16384 msg_mni = 64 msg_tql = 40 shm_max = 2147483640 <<<---- Limit set to 2 GB shm_min = 1 shm_mni = 1024 Still Oracle creates two segments: one 8 MB, second 900 MB oracle> ipcs -am Shared Memory: T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME m 1024 0x1e34 --rw-rw-rw- root daemon root daemon 4 524288 3679586 4104730 11:32:05 11:32:04 21:14:45 m 2 0 --rw-r----- oracle dba oracle dba 9 8388608 4090358 4115445 8:40:03 8:40:13 10:58:11 m 3 0x1c6492d0 --rw-r----- oracle dba oracle dba 9 947912704 4090358 4115445 8:40:03 8:40:13 10:58:11 On Oct 25, 3:44 pm, Vsevolod Afanassiev <vafanass...@yahoo.com> wrote: > I noticed that on some platforms Oracle always creates two shared > memory > segments instead of one, even when both segments are much smaller than > the > limit. > > For example, on this Tru64 box the limit is set to 2 GB: > > oracle > sysconfig -q ipc > ipc: > msg_max = 8192 > msg_mnb = 16384 > msg_mni = 64 > msg_tql = 40 > shm_max =...

Web resources about - Lots of Oracle10g Audit Log Files, Created every one or two second(s) - comp.databases.oracle.server

Tag Synonyms - Stack Overflow
Q&A for professional and enthusiast programmers

Oracle Database - Wikipedia, the free encyclopedia
produced and marketed by Oracle Corporation . Larry Ellison and two friends and former co-workers, Bob Miner and Ed Oates , started a consultancy ...

Java LDAP Developer - 100006374 jobs at NewsCorp - Princeton
Post a job on the CrunchBoard, the official job board of the TechCrunch Network. The CrunchBoard gives you access to the millions of technology ...

Ciboodle Developer - Princeton, NJ - Technology and IT Jobs from FINS.com
Ciboodle Developer - When you join Dow Jones, you become part of one o

The Four HundredBut Wait, There's More
Two months ago, at LinuxWorld, IBM was talking up the future version of DB2 Integrated Cluster Environment for the Power platform, which was ...

Polls - LinuxInsight
LinuxInsight infinite loops in 5 seconds Home News Books Polls Privacy Contact About Search this site: Navigation Recent posts Feed aggregator ...

Certification Courses
IT Certification Training is a NetCom Learning specialty. We offers dozens of popular IT certification training together with top notch customer ...

ORACLE-BASE - Articles on Oracle 10g new features
ORACLE-BASE - Articles on Oracle 10g new features Oracle10g: New Features For Administrators Exam Tips - Some tips on what to expect when upgrading ...

linux.redhat.release.nahant.general (date)
osdir.com mailing list archive F.A.Q. -since 2001! Monthly Indexes 2006-05 2006-04 2006-03 2006-02 2006-01 2005-12 2005-11 2005-10 2005-09 2005-08 ...

Oracle Patents Verdict Form
Scribd is the world's largest social reading and publishing site.

Resources last updated: 3/20/2016 12:05:24 AM