I have tried to compile a list of USERS provided by Oracle along with their default PASSWORDS. A little description about their purpose and scripts to re-create them is also added as a value add. Hoping that it would be useful for the readers.
Related Posts:
- ORA-01017: invalid username/password; logon denied
- How to connect sqlplus without tnsnames.ora
- SQLNET: How does Oracle Client connect with Oracle Server
- How to configure Case Sensitive Password in Oracle
- ORA-28002: the password will expire within 7 days
- ORA-01031: insufficient privileges
User Name | Default Password | Script (in $ORACLE_HOME) | Additional Information |
ANONYMOUS | ANONYMOUS | /rdbms/admin/catqm.sql | Allows HTTP access to Oracle XML DB. |
APEX_PUBLIC_USER | APEX_PUBLIC_USER | /apex/apexins.sql | The Oracle Database Application Express account |
BI | CHANGE_ON_INSTALL / BI | /demo/schema/bus_intelligence/bi_main.sql | Sample Schema |
CTXSYS | CHANGE_ON_INSTALL / CTXSYS | /ctx/admin/ctxsys.sql | To administer Oracle Text |
DBSNMP | DBSNMP | /rdbms/admin/catsnmp.sql | Used by the Management Agent of OEM to monitor and manage DB |
DIP | DIP | /rdbms/admin/catdip.sql | for Oracle Internet Directory-enabled Oracle Label Security |
EXFSYS | EXFSYS | /rdbms/admin/exfsys.sql | Used internally and enables us to build complex PL/SQL rules and expressions |
FLOWS_FILES | FLOWS_FILES | /apex/apexins.sql | Owns objects created during installation of Oracle Database Application Express |
HR | CHANGE_ON_INSTALL / HR | /demo/schema/human_resources/hr_main.sql | Sample Schema |
IX | CHANGE_ON_INSTALL / IX | /demo/schema/info_exchange/ix_main.sql | Sample Schema |
MDDATA | MDDATA | /md/admin/catmd.sql | Used by Oracle Spatial Feature |
MDSYS | MDSYS | /ord/admin/ordinst.sql | The Oracle Spatial and Oracle Multimedia Locator administrator account |
MGMT_VIEW | MGMT_VIEW | /sysman/admin/emdrep/bin/RepManager | Used by Oracle Enterprise Manager Database Control |
OE | CHANGE_ON_INSTALL / OE | /demo/schema/order_entry/oe_main.sql | Sample Schema |
OLAPSYS | MANAGER / OLAPSYS | /olap/admin/amdsys.sql | Owns the OLAP Catalog, has been deprecated |
ORACLE_OCM | ORACLE_OCM | /rdbms/admin/catocm.sql | Associate the configuration information of Database instance with OracleMetaLink |
ORDPLUGINS | ORDPLUGINS | /ord/admin/ordinst.sql | Enables Oracle Database to store, manage and retrieve heterogeneous media data |
ORDSYS | ORDSYS | /ord/admin/ordinst.sql | Oracle Multimedia administrator account |
OUTLN | OUTLN | /rdbms/admin/sql.bsq (after recovery) | Provides plan stability prevents certain db environment changes from affecting performance characteristics |
OWBSYS | OWBSYS | /owb/UnifiedRepos/cat_owb.sql | For administrating the Oracle Warehouse Builder repository |
PM | CHANGE_ON_INSTALL / PM | /demo/schema/product_media/pm_main.sql | Sample Schema |
SCOTT | TIGER | /rdbms/admin/utlsampl.sql | Sample Schema |
SH | CHANGE_ON_INSTALL / SH | /demo/schema/sales_history/sh_main.sql | Sample Schema |
SI_INFORMTN_SCHEMA | SI_INFORMTN_SCHEMA | /ord/admin/ordinst.sql | Stores the information views for the SQL/MM Still Image Standard |
SPATIAL_CSW_ADMIN_USR | SPATIAL_CSW_ADMIN_USR | /md/admin/sdocswpv.sql | Used by Oracle Spatial CSW Cache Manager to load record-type metadata andrecord instances |
SPATIAL_WFS_ADMIN_USR | SPATIAL_CSW_ADMIN_USR | /md/admin/sdowfspv.sql | Used by Oracle Spatial WFS Cache Manager to load all feature type metadata and feature instances |
SYS | CHANGE_ON_INSTALL | /rdbms/admin/sql.bsq (after recovery) | An account used to perform database administration tasks |
SYSMAN | OEM_TEMP | /rdbms/admin/sql.bsq (after recovery) | The account used to perform Oracle Enterprise Manager administration tasks |
SYSTEM | MANAGER | /rdbms/admin/sql.bsq (after recovery) | Default generic database administrator account |
WMSYS | WMSYS | /rdbms/admin/owmctab.plb | Used to store the metadata information for Oracle Workspace Manager. |
XDB | CHANGE_ON_INSTALL / XDB | /rdbms/admin/catqm.sql | Provides high-performance XML storage and retrieval |
XS$NULL | /rdbms/admin/sql.bsq (after recovery) | Represents the absence of a user in a session |
Related Posts:
- ORA-01017: invalid username/password; logon denied
- How to connect sqlplus without tnsnames.ora
- SQLNET: How does Oracle Client connect with Oracle Server
- How to configure Case Sensitive Password in Oracle
- ORA-28002: the password will expire within 7 days
- ORA-01031: insufficient privileges
Dear Nimish,
ReplyDeleteThank you very much for the useful post.
Could you please clarify me on , If we forgot the SYS account password or any account which have DBA privilege, how to reset/ recover it.
Thanks
login in windows as administrator, in linux with use as ora_dba group [like that] and simply run following
Deletesqlplus /nolog
connect / as sysdba
ALTER USER sys IDENTIFIED BY "new_password";
Yes! Finally someone writes about %keyword1%.
ReplyDeletehadoop training
hadoop online training
Thanks for sharing.....
ReplyDeleteSitecore Training
AEM Training
Dellboomi Training
IBM Maximo Training
Guidewire Training
Kronos Training
Communication with the audience through blog is one of the core functions of dynamic work culture. Speak highly of by your peers to enhance the ability for building good relationships with your readers. Apartments for Purchase
ReplyDeleteAmazing information, thank you so much for sharing with us. Visit Kalakutir for Commercial Vechicle Branding Services, Warehouse Painting, and Industrial Floor Marking. For more information in detail visit our website.
ReplyDeleteCommercial Vechicle Branding Services
Antalya
ReplyDeleteAntep
Burdur
Sakarya
istanbul
5İRYBS
Batman
ReplyDeleteArdahan
Adıyaman
Antalya
Giresun
JF323
Antalya
ReplyDeleteAntep
Burdur
Sakarya
istanbul
İR36T
van
ReplyDeleteerzincan
sivas
ağrı
manisa
BBZX
whatsapp görüntülü show
ReplyDeleteücretli.show
4XV5
ankara parça eşya taşıma
ReplyDeletetakipçi satın al
antalya rent a car
antalya rent a car
ankara parça eşya taşıma
M1EDND
kırşehir evden eve nakliyat
ReplyDeletegiresun evden eve nakliyat
tekirdağ evden eve nakliyat
ardahan evden eve nakliyat
izmir evden eve nakliyat
MU8RSA
A83D1
ReplyDeleteMalatya Lojistik
Çorum Lojistik
Adıyaman Evden Eve Nakliyat
Samsun Evden Eve Nakliyat
Zonguldak Parça Eşya Taşıma
0C84E
ReplyDeletekocaeli parasız sohbet siteleri
random görüntülü sohbet
Muğla Bedava Görüntülü Sohbet
kayseri canlı sohbet uygulamaları
yabancı görüntülü sohbet
niğde görüntülü sohbet odaları
burdur sesli sohbet sitesi
trabzon yabancı görüntülü sohbet uygulamaları
düzce canlı sohbet siteleri ücretsiz
8DFF0
ReplyDeleteBinance Referans Kodu
Likee App Takipçi Satın Al
Clubhouse Takipçi Satın Al
Binance Madencilik Nasıl Yapılır
Binance'de Kaldıraç Var mı
Binance Referans Kodu
Tumblr Takipçi Satın Al
Görüntülü Sohbet Parasız
Linkedin Beğeni Hilesi
7EAFC
ReplyDeleteStar Atlas Coin Hangi Borsada
Ön Satış Coin Nasıl Alınır
Spotify Dinlenme Hilesi
Mexc Borsası Güvenilir mi
Referans Kimliği Nedir
Parasız Görüntülü Sohbet
Loop Network Coin Hangi Borsada
Soundcloud Dinlenme Hilesi
Coin Nasıl Alınır
pgสล็อต สล็อตออนไลน์ เว็บตรง แตกง่าย จุดเริ่มของพวกเรานั้นพวกเราก็จำเป็นต้องขอย้อนไปในช่วงเวลาที่พวกเรานั้นยังปฏิบัติงานประจำอยู่เลย pg slot ช่วยให้ท่านได้สนุกไปกับเรา
ReplyDeletedgdrtgryrsewsrfserf
ReplyDeleteشركة مكافحة حشرات
GJHGYJMK
ReplyDeleteشركة تسليك مجاري بالدمام