Getting Started: Basic Oracle 9i Database Operation Guide

I have been learning Oracle 9i Database for many years. Now I will give a brief description of the basic entry-level operations of Oracle 9i Database. I hope I will be able to learn from Oracle 9i Database beginners.

Initial user
Username: Password (Case Insensitive)
Sys
System
The system administrator of the Oracle database is verified by the operating system by default.
You can modify the C: \ oracle \ ora92 \ network \ admin \ sqlnet. ora file to cancel operating system verification.
Use SQL * Plus to manage Oracle databases
View SQL * Plus commands
SQL> help index
Connect to or disconnect from an instance

 
 

  
  
SVRMGR>Connect sys/oracle @ orcl as sysdba | sysoper (sys user can, system cannot .)
  
  
SQL>Connect/as sysdba | sysoper
  
  
SQL>Disconnect
 
 

Logon as a common user cannot be shutdown or startup.
Use dgmgrl to manage Oracle databases

 
 

  
  
C:\dgmgrl  
  
  
dgmgrl> connect sys/oracle@orcl  
  
  
dgmgrl>help  
  
  
dgmgrl>shutdown abort  
  
  
dgmgrl>startup  
 
 

Modify the password of the sys User:
Sys is an instance user whose password is stored in a dedicated password file.

 
 

  
  
C:\>orapwd file=C:\oracle\ora92\database\pwdorcl.ora password=oracle entries=5     
 
 

(Delete the original file first !)
Be sure to restart the instance service.
Use the graphical interface to modify the password of the sys user.

1. Code required to modify the Oracle Stored Procedure
2. Summary of Oracle stored procedures
3. Code for implementing the Oracle Stored Procedure
4. In-depth high-performance dynamic Oracle SQL Development
5. Analysis of Oracle SQL optimization rules