Re: I am so surprised about the "ctxsys"

Xiaoliang,

The "ctxsys" user is created when you install the Oracle ConText option (later renamed to interMedia). If you are absolutely sure that no one is using, or will use, this option then go ahead and delete "ctxsys".

Otherwise I would change the password from the default.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 370+ Oracle tips, visit:                         <->
<->                                                      <->
<->             www.arikaplan.com                        <->
<->                                                      <->
<->             email: akaplan_at_interaccess.com           <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

On Thu, 27 Jul 2000, Xiaoliang Chen wrote:

> hi, all,
>
> I try to connect my database with username: ctxsys, password: ctxsys, this
> username has DBA roles. It make me shocked. What the hell this user doing?
> Should I just delete this user?
>
> Best wishes!
> Yours sincerely, Xiaoliang Chen
> ___________________________________
> SUN certified Solaris7 System Administrator
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, July 27, 2000 12:54 PM
>
>
> > I have not run into any problems in 816 so far probably because Iam using
> > 2GB datafiles in the test databases so far. I have a necessity to get the
> > data from 816 database and import into 815 database and so I got all the
> > problems. We are also on HP/UX 11.0 64bit. Some of my collegues are facing
> > problems after upgrading to 816, probably they are using 5GB datafiles on
> > the production databases. Iam attaching the messsage below about the
> > problems they are facing. I too would be waiting for their problem to be
> > solved before I upgrade my production databases to 816 as I too am using
> 5GB
> > datafiles for production. If anybody knows the solution how to solve the
> > below mentioned 816 problem, please let us know. It would be appreciated.
> >
> > Here is the text:
> > >We have test instances on 2 of our new N4000 boxes, running HP-UX 11 and
> >
> > >Oracle 8i (8.1.6), a Banner 3.x instance, and a Banner 4.x instance.
> >
> > >
> >
> > >Our database is about 40 GB, with several HP largefiles filesystems
> >
> > >accommodating 5 and 10 GB tablespace datafiles. We are experiencing
> >
> > >intermittent database crashes when Oracle (apparently) detects an HP-UX
> >
> > >error 27: File too large.
> >
> > >
> >
> > >After working with HP and Oracle, we believe this error message is
> >
> > >incorrect, 'tho we suspect that there is an as yet undocumented
> >
> > >"feature" having to do with limits in the 64 bit architecture.
> >
> > >
> >
> > >But I emphasize, at this point we do not know what the problem is. All we
> >
> > >do know is that sooner or later (at least once a day), our test instances
> >
> > >are crashing.
> >
> > >
> >
> > >We are supposed to cutover to the new N4000 servers over Labor Day
> >
> > >weekend, but as of now, that is not going to happen unless we can resolve
> >
> > >this error.
> >
> > -----Original Message-----
> > Sent: Thursday, July 27, 2000 9:09 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hello everyone -
> >
> > I've seen a lot of talk about downgrading back to 8.1.5. May I ask what
> > problems you ran into that made the downgrade necessary? I am interested
> in
> > any comments or war stories anyone may have. We are looking at doing this
> > in the next month or so - someone here is really bent out of shape about
> not
> > having full DBMS_UTILITY functionality. That's his main reason for
> > upgrading. We are HP/UX 11.0 64bit.
> >
> > Thanks in advance...
> >
> > Lisa Rutland Koivu
> > Oracle Database Administrator
> > Qode.com
> > 4850 North State Road 7
> > Suite G104
> > Fort Lauderdale, FL 33319
> >
> > 954.484.3191 x174 [voice]
> > 954.484.2933 [fax]
> > 954.309.4157 [cell]
> > lkoivu_at_qode.com [email]
> > http://www.qode.com <http://www.qode.com> [web]
> >
> >
> > "The information contained herein does not express the opinion or position
> > of Qode.com and cannot be attributed to or made binding upon Qode.com."
> >
> > --
> > Author: Janardhana Babu
> > INET: jbdonga_at_ucdavis.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (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).
>
> --
> Author: Xiaoliang Chen
> INET: ochen_at_netrue.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Thu Jul 27 2000 - 16:52:56 CDT