Creating manual database oracle 10g

 · Step 1: Login to SQL* Plus with SYS user and unlock the user account DBSNMP. C:\sqlplus SYS as Step 2: Go to command prompt of windows and issue the following command and wait for www.doorway.ruted Reading Time: 7 mins. Create the Oracle Database 10 g user accounts with the CREATE USER and ALTER USER commands. Use the GRANT command to grant the required database privileges or roles as documented in Oracle Database Administrator's Guide. Documentation Part Number Description; Oracle Database Backup and Recovery User's Guide. B Provides in-depth information on the mechanics of backup and recovery, and a guide to performing complex and less frequently performed backup and recovery tasks, including user-managed backup and recovery and performance tuning of backup and recovery.

Creating the Portal Database for Oracle 10g On Windows This topic describes how to create and configure the portal database, tablespace, and user on Oracle10g. Note: These steps create a new, dedicated portal database. See the Oracle Database Net Services Administrator's Guide and the Oracle Database Administrator's Guide. Step 5 Create a server parameter file for the standby database. On an idle standby database, use the SQL CREATE statement to create a server parameter file for the standby database from the text initialization parameter file that was edited. database_logging_clauses. Use the database_logging_clauses to determine how Oracle Database will handle redo log files for this database.. LOGFILE Clause. Specify one or more files to be used as redo log files. Use the redo_log_file_spec form of file_specification to create regular redo log files in an operating system file system or to create Automatic Storage Management disk group redo log.

Step 1: Login to SQL* Plus with SYS user and unlock the user account DBSNMP. C:\sqlplus SYS as Step 2: Go to command prompt of windows and issue the following command and wait for minutes. Documentation Part Number Description; Oracle Database Backup and Recovery User's Guide. B Provides in-depth information on the mechanics of backup and recovery, and a guide to performing complex and less frequently performed backup and recovery tasks, including user-managed backup and recovery and performance tuning of backup and recovery. Oracle Database does this automatically if you are using Oracle-managed files--that is, you have set a value for the DB_CREATE_FILE_DEST initialization parameter. However, if you are not using Oracle-managed files and you specify this clause, then you must also specify the undo_tablespace clause and the default_temp_tablespace clause.