SLTechnology News&Howtos › Database ›

[learning] SQL Foundation-001-preliminary preparation

Shulou Source: shulou.com Published: 2022-06-01 05:33:55 10月05日 Update

1. Environment parameter setting

@? / sqlplus/admin/glogin.sql

Export ORACLE_SID=XXX

two。 Start

Sqlplus / as sysdba

SQL > startup

SQL > select status from v$instance

3. (optional) rebuild the scott scenario

@? / rdbms/admin/utlsampl.sql

4. Unlock scott account

Unlock using sys user

Sqlplus / as sysdba

SQL > alter user scott identified by tiger unlock