A reader, May 14, 2001 - 3:42 am UTC
All documentation should read this clearly
Rob Kellington, July 31, 2001 - 5:19 pm UTC
Great!
Clear and concise
A reader, December 18, 2001 - 1:07 pm UTC
Thank you for the clear and concise information provided.
One more question on this
Tajana, November 29, 2002 - 12:07 pm UTC
Thanks, I searched for this matter ...
To complete the list of users: There are also
WKSYS
HR,OE,PM,SH
OLAPDBA,OLAPSVR,OLAPSYS
OSE$HTTP$ADMIN
QS,QS_ADM,QS_CB,QS_CBADM,QS_CS,QS_ES,QS_OS,QS_WS
PORTAL30,PORTAL30_DEMO,PORTAL30_PUBLIC,PORTAL30_SSO,PORTAL30_SSO_PS,PORTAL30_SSO_PUBLIC
What are those users all for ? Some of them seem to contain example/demo data (HR,OE,PM,SH).
What about tablespaces EXAMPLE, CWMLITE, DRSYS ?
Which of that users and data (=> tablespaces) can I remove from a production DB ?
SYSTEM & SYS USERS
Jayesh, March 31, 2004 - 11:06 pm UTC
What is the purpose of having two different account SYS and SYSTEM in oracle with both having DBA roles? Is there any special reason for using SYSTEM account in Oracle? Which scenario is it helpful?
April 01, 2004 - 9:38 am UTC
the SYS account in 9i and above is inacessible by default (connect sys/pw will fail)
SYSTEM can and should be LOCKED
and neither should be used by you except during installation/configuration or at the request of support.
How can I tell?
Vaughn Ripley, July 16, 2004 - 4:03 pm UTC
Hi tom,
I was wondering if there is a query I can run against a view or table that would show which usernames were system created and which ones were manually added to the system?
Thanks in advance,
Vaughn
July 16, 2004 - 10:58 pm UTC
they are all "manually added" to the system -- there is no such thing as "system created"
How to manually install Intermedia Text & Java Support Options ?
Muhammad Riaz Shahid, July 17, 2004 - 1:42 pm UTC
At the time of creation of database, Oracle Intermedia Text & Java Support were not selected. How can i manually install them ? (i.e; by running some script in $Oracle_Home$/rdbms/admin or somewhere else).
Regards
July 17, 2004 - 2:59 pm UTC
dbca is used to add options to the database.
8i VS 9i
George, August 27, 2004 - 11:54 am UTC
The default 9i 'general purpose' database does not have AURORA$JIS$UTILTY$, AUROA$ORB$UNAUTHICATED and OSE$HTTP$ADMIN user accounts. When I did a full import into a 9i db from a full 8i .DMP file, these 3 were created. Is it save to drop them or should I just leave them?
August 27, 2004 - 12:58 pm UTC
i'd lock them, but keep them and get guidance from support as to whether you'd actually "need them"
scott/tiger
A reader, December 07, 2004 - 8:40 pm UTC
How can I create the default/demo user SCOTT with all its sample tables in a existing database?
Thanks
December 08, 2004 - 10:11 am UTC
if you have 10g, you'll need to copy demo*.sql from $ORACLE_HOME/sqlplus/demo from a 9i or before install.
then:
sys@ORA10GR1> create user scott identified by tiger;
User created.
sys@ORA10GR1> grant create table, create session to scott;
Grant succeeded.
sys@ORA10GR1> alter user scott default tablespace users quota unlimited on users;
User altered.
connect as scott
scott@ORA10GR1> @demobld
Building demonstration tables. Please wait.
Demonstration table build is complete.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
[tkyte@localhost demo]$ pwd
/home/ora10gr1/OraHome_3/sqlplus/demo
[tkyte@localhost demo]$
scott/tiger
A reader, December 08, 2004 - 9:27 am UTC
OK running 'dbca' is the way to do this. It has various options to install sample schemas, Oracle Text, etc into an existing database.
I ran dbca and left it running overnight. In the morning, I got an error 'Xlib: Resource allocation id exhausted' or something. All the DBCA screens were grayed out.
I killed it. How do I know what it did and where it aborted? Is there a logfile generated somewhere?
December 08, 2004 - 10:48 am UTC
please contact support .
dbca isn't the way I would have thought to create a user?
default username and password of SQL*PLUS Release 9.0.1.01
saleemiqbal, December 29, 2004 - 11:53 am UTC
i installed oracle 9i release 9.0.1.0.1 but could not find username and password of SQL*PLUS so far.
much oblidge if u please help me
December 29, 2004 - 7:19 pm UTC
there aren't any usernames for "sqlplus" -- that is a tool that connects to the database.
When you installed, it asked you "what should they be". what did you answer for SYS and SYSTEM?
mdsys
jas, March 01, 2005 - 6:56 am UTC
hi tom
just wanted to know what should be the default tablespaces of users like AURORA$JIS$UTILITY$, mdsys, ordsys, outln and others as while running this query to find out which users other than sys or system are in system tablespace it gives all these users objects in system tablespace.
select substr(owner,1,20) owner, substr(segment_name,1,30) object_name,
segment_type type
from dba_segments
where owner not in ('SYS', 'SYSTEM')
and tablespace_name = 'SYSTEM'
/
March 01, 2005 - 8:35 am UTC
until the introduction of the SYSAUX tablespace in 10g:
1 select owner, tablespace_name, count(*)
2 from dba_segments
3 group by owner, tablespace_name
4* order by owner, tablespace_name
ops$tkyte@ORA10G> /
OWNER TABLESPACE_NAME COUNT(*)
------------------------------ ------------------------------ ----------
BIG_TABLE USERS 1
CTXSYS SYSAUX 74
DBSNMP SYSAUX 4
DMSYS SYSAUX 87
EXFSYS SYSAUX 21
MDSYS SYSAUX 86
MY_USER USERS 4
OLAPSYS SYSAUX 243
OPS$TKYTE USERS 212
ORDSYS SYSAUX 8
OUTLN SYSTEM 6
PERFSTAT SYSAUX 121
SCOTT USERS 7
SYS SYSAUX 795
SYS SYSTEM 887
SYS UNDOTBS1 12
SYSMAN SYSAUX 742
SYSTEM SYSAUX 92
SYSTEM SYSTEM 253
WKSYS SYSAUX 118
WK_TEST SYSAUX 34
WMSYS SYSAUX 104
XDB SYSAUX 733
23 rows selected.
Those things will be in SYSTEM
if i cahnge
A reader, March 01, 2005 - 11:50 pm UTC
if i change the tablepsace to any other will it cause any problem please give insight.
Thanks
jasdeep
March 02, 2005 - 7:01 am UTC
in order to touch any of these objects, you must work with support and get their blessing that it is a supported and supportable operation.
A reader, March 02, 2005 - 7:23 am UTC
why on one hand oracle says don't create objects of users other than sus and system in system tablespace and on other hand creates objects itself.
Regards
March 02, 2005 - 7:41 am UTC
Q: who owns those other users though?
A: oracle
Difference between DBSNMP, SYSMAN, MGMT_VIEW users
Stuart, December 10, 2008 - 8:41 pm UTC
Hi Tom,
I'm on 10g, and am trying to figure out what the MGMT_VIEW account is used for.
The DBSNMP password is used to change my DB Console password (Metalink 259387.1), and SYSMAN appears to be for Grid Control. What is the MGMT_VIEW account used for? I can't see any doc which explains the difference between them.
Regards
Stuart.
MGMT_VIEW
A reader, December 14, 2008 - 2:34 pm UTC
Thanks for clarifying that.
I presume I can leave MGMT_VIEW off my list of passwords to change every x months (I do change DBSNMP and SYSMAN).
CTXSYS user not created by default
Shipra Singh, February 02, 2011 - 3:37 am UTC
CTXSYS user not created by default during a fresh database installation. Firstly what option did I not select to have missed the user creation(for future reference)? Secondly, kindly suggest the method to create one with all the objects, just like a default installation. Thirdly, is this a proper installation at all, cause i see only limited users.
USERNAME
------------------------------
OUTLN
SYS
SYSTEM
MAXIMO
TSMSYS
DIP
ORACLE_OCM
DBSNMP
February 02, 2011 - 7:51 am UTC
ctxsys is part of Oracle Text, you didn't choose to install Oracle Text when you created the database.
Use dbca to "configure" your database - you can add things like Oracle Text, Oracle OLAP, Oracle Spatial, etc..
http://docs.oracle.com/docs/cd/E11882_01/server.112/e10897/install.htm#ADMQS0233 yes, that is a "proper" installation - without many optional components installed.