Does anyone have any information on security problems using the OPS$
account?
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Hi all!
Does anyone know is it possible to configure OPS between two remote sites?
TIA,
Sonja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
Hi all,
Is there some db parameter I need to set to get the ops$ login to work? I
am using ORACLE V8.1.7 on a Compaq Tru64 V5.1
I have created a unix user called production. I then created the user in
the database called ops$production.
When I login as this user and try to go into SQL*PLUS I
pack 5
We cant go with 8i due to some restriction from the application side.
The application is web based clients as well as typical client server.
We are going for OPS mainly for the purpose of High Availibility, perhaps
think of scalibility at a later stage when we can really partition the
anyone can name their pc "oracle" and then connect in if you set
"remote_os_authent"
--- "Smith, Ron L." <[EMAIL PROTECTED]> wrote:
> Does anyone have any information on security problems using the OPS$
> account?
>
> Ron
> --
> Pleas
Even so, they are still limited by the permissions given to OPS$ORACLE.
Right?
Ron
-Original Message-
Sent: Wednesday, January 30, 2002 1:26 PM
To: Multiple recipients of list ORACLE-L
anyone can name their pc "oracle" and then connect in if you set
"remote_os_authen
They can also set their username to 'SYSTEM'.
Jared
Rachel Carmichael <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/30/02 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
S
]
01/30/02 11:25 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: OPS$
anyone can name their pc "oracle" and then connect in if you set
"remote_os_authent"
--- "S
AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Re: OPS$
>
> anyone can name their pc "oracle" and then connect in if you set
> "remote_os_authent&qu
Well, yes, the can set their name to SYSTEM, SYS, SCOTT, whatever, and so
long as your authentication demands an OPS$ or basically any other non null
string of characters, who cares? OPS$SYSTEM is not going to wind up being a
DBA... now, if OPS$STILL is a DBA, and someone sets their PC to STILL
rmichael <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 01/30/02 11:25 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:Re: OPS$
>
> anyone can name their pc
e respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: OPS$
Can you explain that? You have me scared now.
-Original Message-
Sent: Wednesday, January 30, 2002 4:00 PM
To: Multiple recipients of li
LE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: OPS$
Well, yes, the can set their name to SYSTEM, SYS, SCOTT, whatever, and so
long as your authentication demands an OPS$ or basically any other non
null
string of charact
TED]>
Subject: Re: OPS$
Sent by:
root@f
of list ORACLE-L
>
>
> They can also set their username to 'SYSTEM'.
>
> Jared
>
>
>
>
>
> Rachel Carmichael <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 01/30/02 11:25 AM
> Please respond to ORACLE-L
>
>
> To: M
Carmichael To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
>
> yahoo.com> Subject: Re: OPS$
>
y, January 30, 2002 4:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > They can also set their username to 'SYSTEM'.
> >
> > Jared
> >
> > Rachel Carmichael <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
figuration
remote_os_authent=false
osauth_prefix_domain=true
sqlnet.authentication_services=(nts)
Now I can create externally authenticated database accounts, prefixed with the domain
name instead of OPS$. When they connect to the database Oracle will authenticate them
via Kerberos or NTLM, so thei
ael <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 01/30/02 11:25 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc:
> >
externally authenticated database accounts, prefixed with
> the domain name instead of OPS$. When they connect to the database Oracle
> will authenticate them via Kerberos or NTLM, so their password doesn't even
> have to be passed over the network. And they are authenticated by the
>
"Deshpande, Kirti" wrote:
>
> We use REMOTE_OS_AUTHENT in many of our databases. I know we shouldn't do
> this, but we have to, and that's another topic...
>
> We also use a specific auth prefix.
>
> Now, can someone show me how a Windoze user, 'GOD' get in the database when
> I do not have a u
n 'when remote_os_authent is set to TRUE', in
which case I fully agree with you. Otherwise, my position is :
a) Keep remote_os_authent to FALSE
b) Use an ops$oracle or similar account as DBA for maintenance tasks you
regularly run through cron or similar - you will not have any hard-cod
A user can be both, requiring a passwd and os authenticated. You can create a user
identified externally then change its passwd. With this method, you have sqlplus
client access requiring username/passwd and server access with no passwd required for
cron jobs, etc.
timp>create user ops$j
; > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > > Rachel Carmichael <[EMAIL PROTECTED]>
> > > Sent by: [EMAIL PROTECTED]
> > > 01/30/02 11:25 AM
> > > Please respond to ORACLE-L
> > &g
gt; the
> > default roles, Connect, Resource and most especially NOT DBA.
> >
>
> Rachel,
>
>I assume that you mean 'when remote_os_authent is set to TRUE', in
> which case I fully agree with you. Otherwise, my position is :
> a) Keep remote_os_authe
uiring username/passwd
> and server access with no passwd required for cron jobs, etc.
>
> timp>create user ops$junk identified externally;
> User created.
> timp>alter user ops$junk identified by junk;
> User altered.
> timp>grant create session to ops$junk;
> Grant suc
externally authenticated database accounts, prefixed
> with the domain name instead of OPS$. When they connect to the
> database Oracle will authenticate them via Kerberos or NTLM, so their
> password doesn't even have to be passed over the network. And they
> are authenticated by
one of the nicer little features of 9i is that those accounts come
"locked" when you build the database. The set of privileges for each
has also been greatly restricted.
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> "Deshpande, Kirti" wrote:
> >
> > We use REMOTE_OS_AUTHENT in many of our d
Oh, Sure..
I have seen that in the past (with 7.2.3.0).
Actually, at my current job, we had one 'very special' database (built by an
Oracle Consultant), where the Prod Schema owner was an OPS$ account. How
conveeenient!
The Contractor DBA who managed it when I joined, told me
OK, so there are risks. I will make sure OPS$ORACLE has restricted access.
New question. In 8.1.6 I have set everything up the same as I did in 7.3.4
but when I
try to run SQL*PLUS as sqlplus / I get invalid user name / password. I am
searching
the sorry documentaion CD but I havn't
what a concept... changing production passwords!
hm, I knew I liked your company as my phone provider :)
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> Stephane,
> Thanks. Yes, we are properly fenced
> None of the databases have those default accounts with default
> passwords.
> We
i can just see it now, user ids generated by the security group, there must be lots of
little yellow stickers on everyone's pc :)
>>> [EMAIL PROTECTED] 01/31/02 10:25AM >>>
Stephane,
Thanks. Yes, we are properly fenced
None of the databases have those default accounts with default passwo
We change production password too, but not that often. But I have a DB level
trigger that logs each login and captures OSuser too. Then I have a report
that is run by my good friend "cron" telling me who is logging in as what.
So, if we find somebody, their managers get informed, mentioned in the
Yellow is out, we use our Company colors now. Black/red/white color
stickers (with the V-check mark) ;>)
- Kirti
-Original Message-
Sent: Thursday, January 31, 2002 10:51 AM
To: Multiple recipients of list ORACLE-L
i can just see it now, user ids generated by the security group, th
securities still exist. ( geez I love English :)
So far, no.
Jared
Jared Still <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/30/02 07:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
TED]>
Sent by: cc:
root@fatcity.Subject: Re: OPS$
Title: RE: OPS
There are some clustering technologies that allow
'campus clusters' (such as SunCluster), but I
don't believe it's possible over a wide geographic
separation.
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative ar
For an OPS configuration, disks have to be shared among the nodes,
which usually means some kind of common IO bus (SCSI, FCAL, SSA).
That means that the nodes must be within cca. 2 miles (3 km).
-Original Message-
Sent: Tuesday, March 27, 2001 6:45 AM
To: Multiple recipients of list
FYI: They must also be on Raw Partitions!!
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Tuesday, March 27, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
For an OPS configuration, disks have to be shared among the nodes,
which usually means some kind of
O.P.S. Setup in Benchmark Runs :-
--
2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6
3rd APP Server - SUNe420R
Hi list,
Scenario OPS 2 nodes, Oracle 8.1.7, AIX. (New
dealing with OPS)
What is the best solution for implementing
archiving in OPS. As far as I understand the 2 instances will be
generating archives. If one of the instance goes down, what happen
with the destination of those
Hi list,
Scenario OPS, 2 nodes, 8.1.7, AIX using raw
devices, EMC box.
I am new in OPS and have to implement archiving
in an OPS environment and configure RMAN to use with LEGATO.
My question is how to organize the
archives. What will happen if one of the nodes goes down ?
I think
Hi gurus,
I have a query..Basically we have an OPS set up here (8.0.6) and I have
noticed that the scn on node A is 500 and the scn on node B is 2000. I am
concerned about this w.r.t recovery- surely this would be an issue ??I
logged a call with oracle and they said it wasnt an issue, but then
Hi,
1) I have set up a cluster of INTEL machines on INTEL PIII using
LINUX Redhat 6.2 .
2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database
is on raw devices.
3) When I try to install OPS option , I get a message saying OPS not
supported on LINUX .
Has any one been
In your init.ora, check the value of OS_AUTHENT_PREFIX. If it's not "OPS$",
that's the problem. Most people set it to "" (null string) now, so your
Oracle username would be production, not ops$production.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROT
Title: RE: OPS$users
remote_login_passwordfile = exclusive
os_authent_prefix = "OPS$"
and create the user identified externally.
Lisa Koivu
-Original Message-
From: Bartolo, David [SMTP:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 1:19 PM
To: Multiple
Yes, set the "os_authent_prefix = ops$" in your INIT.ORA
Yigal
"Bartolo, David" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Is there some db parameter I need to set to get the ops$ login to work? I
> am using ORACLE V8.1.7 on a Compaq Tru64 V5.1
> I h
Yes, set the "os_authent_prefix = ops$" in your INIT.ORA
Yigal
"Bartolo, David" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Is there some db parameter I need to set to get the ops$ login to work? I
> am using ORACLE V8.1.7 on a Compaq Tru64 V5.1
> I h
how did you create the user in the database?
should be
create user ops$production identified externally...
>From: "Bartolo, David" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OPS$u
Of course you could leave your parameter the way it is and just
create a user called production. I don't use the ops$ prefix
on my externally identified accounts.
-Original Message-
Sent: Friday, August 31, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L
Yes, se
tion is this - have any of you running OPS come across a similar
issue??
Thanks.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http
Anyone out there using OPS ver7 on Tru64 Alpha?
I'd be interested in swapping DLM parameters.
We just applied an OWS-suggested fix and it apparently
ran the box into the ground.
Any thoughts welcome.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan,
; compaq cluster machine FA-200.
> OAS4.0
> Oracle Forms 5
> Operating System is Windows NT 4, service pack 5
>
> We cant go with 8i due to some restriction from the application side.
>
> The application is web based clients as well as typical client server.
>
> We are
Probably just my bad paraphrase of a dim recollection of a
fast/careless read of previous comments on the list.
Can you give a brief explanation of what will be new/changed
in RAC, and what it means?
thanks,
ep
>...but rest assured that OPS is not going to be
> "replaced&qu
Has anyone here installed ops on linux? ( oralce 8.1.7.0.1)
I just could not start the related daemons by using
$ORACLE_HOME/oracm/bin/ocmstart.sh.
The machine just hanged every time I ran ocmstart.sh.
Any suggestions?
Thanks in advance.
--
Please see the official ORACLE-L FAQ: http
Have a Single Instance Database ( ORA 8.1.7 )Running on a 2-node Cluster (
Digital Unix 5.1)
Any Doc. Listing Steps to Convert it into a 2 instance OPS Database ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City
> O.P.S. Setup in Benchmark Runs :-
> --
> 2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
> 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
> 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6
> 3rd APP Serve
> O.P.S. Setup in Benchmark Runs :-
> --
> 2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
> 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1
> 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6
> 3rd APP Serve
Hi,
We have two 4500 and A1000 from sun.We are planning to implement OPS on this
sun cluster(2.2).If anyone is ahving any documentation on how to set up OPS
on this
cluster pls send me the same.I have done the installation of OPS on Digital
Unix
cluster previously.But now since I have take care
Hi Cyril, Alex,
Oracle Parallel Server 8.1.6 on IBM AIX 4.3.3 requires
HACMP/ESClustering software, Add on to AIX
SSA Serial Storage Array, IBM's Disk Array
provide shared disk
Hi speed Intercon
I have always been comfortable with the idea that Sequences continue to
guarantee
uniqueness even in OPS / RAC environments.
However, a recent Builder.Com article by Scott Stephens on the SYS_GUID
function has these lines :
"Sequence generator numbers are guaranteed to be unique only
Hi all:
I'm tuning an OPS env. and the things are getting quite deep, DLM latch
issues and so on (e.g. lots of waits on "dlm resource hash list"). So I was
wondering if any of you know of any site or doc. which could help me on this
(OPS tuning specific and very deep information).
Dear gurus !
I have to create an OPS 7.3.4 database (yes, there are still Oracle7
installations out there).
Actually we are migrating our current OPS DB to another storage (EMC).
So , the software is installed , i just need to create the DB.
I can not find which scripts to run after the "c
I'm managing an OPS
configuration (4x HP 9000/N, HP-UX 11/64 , RDBMS
8.1.7.1)
and I'm having an
application dependency on a temporal order of sequence
numbers.
With OPS that
becomes a problem because each node caches a set of sequence
numbers
(20 by default).
Oracle has
AIL PROTECTED]>
wrote:
> Hi list,
>
> Scenario OPS 2 nodes, Oracle 8.1.7, AIX. (New
> dealing with OPS)
>
> What is the best solution for implementing archiving
> in OPS. As far as I understand the 2 instances will
> be generating archives. If one of the instance goes
>
ORACLE-LSubject:
Archiving in OPS
Hi list,
Scenario OPS, 2 nodes, 8.1.7, AIX using raw
devices, EMC box.
I am new in OPS and have to implement archiving
in an OPS environment and configure RMAN to use with LEGATO.
My question is how to organize the
archives. What will
tablespaces on that "local"
storage will never work. Likewise, if the rollback tablespaces were also
not in "raw" devices; it would never work (unless you are using a
clustered file-system such as available on Tru64). In both cases, OPS/RAC
would fail to startup...
Hi,
Yes
you are correct.I am using Oracle9i RAC (Real Application
Cluster).
Muqthar Ahmed
DBA
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 4:44
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Archiving in OPS
ver without having to worry about moving
> files around.
>
> Note that if an instance fails, any of the surviving
> instances can and will archive logs on behalf of the
> failed instance to the local instances archive
> destination.
>
> Bill
>
> --- "Ramon E.
Thinking about it logically how can any 2 systems that are used
independently (which in a way is what OPS is)always keep the same SCN
numbers together.
As long as each of the instances has it's own set of redo log files and it's
own set of archived log files (i.e both nodes/instances n
Fawzia,
Oracle it self will keep an eye on that also. It will kick the other instance
if it falls behind. So that the redo file will be switched.
Anjo.
"Malik, Fawzia" wrote:
> Hi gurus,
>
> I have a query..Basically we have an OPS set up here (8.0.6) and I have
> n
Fawzia, What are you querying to get the SCN
information. I would also be curious where you read
about the recovery issues in OPS environment? Oracle
maintains what is called a snapshot SCN and global
SCN. The snapshot SCN is usually maintained in the SGA
and the global SCN is maintained by the
Thank you Scott for supplying a well-written summary of SCN usage within OPS
nodes.
I was interested in "If the gap in the log sequence gets to big Oracle will
force the idle node to do log switches "
I was not aware of that and whilst I believe you, I cannot see what the
reason be
John, I actually have never sat down tested to see
when Oracle actually does the redo kick. I do have a
OPS and RAC test environment so I may have to see how
big the GAP gets before Oracle starts doing log
archive switches on the idle node.
The only reason I have heard why Oracle does this kick
com> cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: RE: OPS and redos
[EMA
Dear list !
I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
I want the clients to connect to the instance OPS1 and , if OPS1 becomes
unavailable , to connect to OPS2 .
The Oracle version is 8.0.5
I put the following lines in clients' tnsnames.ora file :
Shreepad Vaidya wrote:
>
> Hi,
> 1) I have set up a cluster of INTEL machines on INTEL PIII using
> LINUX Redhat 6.2 .
>
> 2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database
> is on raw devices.
>
> 3) When I try to install OPS option , I ge
Hi, I think it works only with 817
oli
[EMAIL PROTECTED] wrote:
> Hi,
> 1) I have set up a cluster of INTEL machines on INTEL PIII using
> LINUX Redhat 6.2 .
>
> 2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database
> is on raw devices.
>
> 3) W
Dear list !
I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
I want the users to connect to OPS1 and ONLY if it is down , to connect to
OPS2.
It's Oracle 8.0.5.1 on NT4.
I put the following lines in clients' tnsnames.ora file :
OPS.world = (D
System : Sun E10K
OS : Sun solaris 2.8
Oracle : 8i Rel 3 64bit option
Database : OPS
Type : OLTP &
# concurrent users : 1000 (including US and international users Europe, Asia
& Australia)
Our System admin suggesting us to go for File system (veritas, without
Veritas quick i/o) instea
exactly the context in which you heard this (NT
> > cluster specific?),
>
> Don,
>
> Probably just my bad paraphrase of a dim recollection of a
> fast/careless read of previous comments on the list.
>
> Can you give a brief explanation of what will be new/changed
> in
e fusion. What this means is a lot less
configuring, tuning, and general dinking around with gc_ parameters. In any
RAC configuration, I would not override this except as a last resort.
A lot of the "complex" reputation that OPS has from its earlier days is
based on the configuration
[EMAIL PROTECTED] wrote:
>
> Well you asked for this. Don't read this if you are faint
> of heart and weak of mind.
ORA-99 : Brain Overload.;-)
this one i'll save and keep rereading until it makes sense.
thanks.
--
Bill "Shrek" Thater Certifiable ORACLE DBA
Telergy, Inc.[EM
t my bad paraphrase of a dim recollection of a
> fast/careless read of previous comments on the list.
>
> Can you give a brief explanation of what will be new/changed
> in RAC, and what it means?
>
> thanks,
> ep
>
>
> >...but rest assured that OPS is not goi
in my 816/Tru64 4.0f instance, I have alot of latch waits/sleeps/longholds
on:
dlm resource table freelist
dlm lock table freelist
I have downloaded Note 72316.1, but this does not contain material exactly
on these
latches.
Further, I have very very high system-level waits for:
"lock manager
Thanks for all your help on this one, guys.
I think it was my udp_sendspace being set too small (smaller
than DBMS block size) that was boinking me.
Anyone out there have a udp_sendspace set to SMALLER than their OPS dbms
block size?
hope not, cuz it would mean I am vomiting up the wrong
Speaking of default accounts with default passwords, here is my list that I
check for. Anyone want to compare notes :) i.e. have I missed any?
Thanks,
Jim
perfstat/perfstat
TRACESVR ??? is only used with 7.x Databases
REPADMIN ???
CTXSYS/CTXSYS
DBSNMP/DBSNMP
INTERNAL/ORACLE
MDSYS/MDSYS
M
James McCann wrote:
>
> Speaking of default accounts with default passwords, here is my list that I
> check for. Anyone want to compare notes :) i.e. have I missed any?
>
> Thanks,
>
> Jim
>
> perfstat/perfstat
> TRACESVR ??? is only used with 7.x Databases
> REPADMIN ???
> CTXSYS/CTXSYS
Hey All,
Anyone remember how to change the DBSNMP password? I know I can change it
in the db easily enough, but how does the server/DBSNMP listener process
know what the new password is? Must be stored in an OS file someplace.
I was just poking around trying to figure it out. The docs have th
It goes in snmp_rw.ora
snmp.connect..password = "dbsnmppwd"
snmp.connect..password = "dbsnmppwd"
-Original Message-
Sent: Thursday, January 31, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Hey All,
Anyone remember how to change the DBSNMP password? I know I can change
it
change it in snmp.ora
which is in clear text on the Unix server.
protect that file!
--- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote:
> Hey All,
>
> Anyone remember how to change the DBSNMP password? I know I can
> change it
> in the db easily enough, but how does the server/DBSNMP l
scary
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> James McCann wrote:
> >
> > Speaking of default accounts with default passwords, here is my
> list that I
> > check for. Anyone want to compare notes :) i.e. have I missed any?
> >
> > Thanks,
> >
> > Jim
> >
> > perfstat/perfstat
> > T
$0);
print qq{
usage: $basename Oracle Default Password Checker
-database ORACLE_SID
-username DBA account
-password account password
use one of the following options
to connect as SYSOPER or SYSDBA
[-sysdba || -sysoper]
};
exit $exitval;
}
Big list.
Didn't think of searching the directories. That would have been easier and
better than searching the docs, as I did, Doh!
I'll have to write a procedure to rename/lock them if they exist,
Jim
-Original Message-
Faroult
Sent: 31 January 2002 17:41
To: Multiple recipients of lis
It only exists if the Oracle Agent is running.
In my case, it (the agent) is not running, so I don't have the file. (and
I'm on NT, so we all know, there is no protection required! :) )
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 31, 2002
asename Oracle Default Password Checker
-database ORACLE_SID
-username DBA account
-password account password
use one of the following options
to connect as SYSOPER or SYSDBA
[-sysdba || -sysoper]
};
exit $exitval;
}
"James McCann" <[EMAIL PROTE
Yes, Andy Duncan and I are collaborating on one.
Jared
"James McCann" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/31/02 12:50 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
S
I are collaborating on one.
Jared
"James McCann" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/31/02 12:50 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: OPS$ / defau
You might also want to check out this web site
http://www.pentest-limited.com/default-user.htm
Steve
-Original Message-
Sent: Thursday, January 31, 2002 9:41 AM
To: Multiple recipients of list ORACLE-L
James McCann wrote:
>
> Speaking of default accounts with default passwords, here
: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: OPS$ / default accounts
Thank you Steve, this is a great resource, as it
will save duplicating effort.
I'll go update my script now...
Jared
Steve Main <[EMAIL PROTECTED]>
Sent by:
1 - 100 of 294 matches
Mail list logo