Oracle installation and related configuration

Oracle Windows Environment Requirements

oracle10g memory should be at least 512M, preferably 1GB or above;

oracle11g memory preferably 2GB or above

oracle10g and oracle11g must use an Internet browser to log in to ORACLE Database Enterprise Manager, and the best way to get HTTPS ports is to $oracle_home\install. The author of the computer is: D:\app\prodect\11.2.0\db_home1\install find Portlist.ini.

Unlocking an Oracle user and setting a password

Alter User  by tiger account unlock;

Scott users and their object maintenance

Run the Scott.sql script in the $oracle\rdbms\admin directory to restore the Scott user object

1 SQL>@D: \app\chay\product\11.2. 0\dbhome_1\rdbms\admin\scott.sql

Full backup

Because of operational errors that could crash the database system and sometimes have to reload the Oracle system, to prevent this "catastrophe" we can do an Oracle full backup

• Locate the directory where the control file is located, which is where all the online redo log files and data files are located (all files are placed in the same directory when Oracle is installed by default)
• Close the database
• Copy all online redo logs, control files, and data files
• Copying parameter files and password files
• Start the database

If the database crashes, you can copy the backup to the original directory after shutting down the database so that the database can be restored to its pre-backup state and start working with the startup command to start the database.

Sql>Connect SYS/Oracle asSysdba; SQL>Col Name forA60sql>Slect*  fromV$controlfile; SQL>shutdownImmediatesql>Host Copy D:\app\Chay\oradata\orcl\*.*D:BackupSQL>Host Copy D:\app\Chay\product\11.2.0\dbhome_1\Database\*.*D:\Backup\DatabaseSQL>Startup

Oracle installation and related configuration