Sort: Date

How To Select an Oracle System ID (SID)
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 1. If you are planning to create a new database, you need to select an Oracle System ID (SID). This ID will be used to identify the new Oracle database and its Oracle instance. SID must b...
2007-04-22, 7699👍, 0💬

What is Oracle Forms and what is it used for?
What is Oracle Forms and what is it used for? Oracle Forms is a 4GL Rapid Application Development (RAD) environment. Forms Builder is used to create applications to enter, access, change, or delete data from Oracle (and other) databases. The Forms Runtime environment is required to execute compiled ...
2011-03-15, 5340👍, 0💬

How To Create an Initialization Parameter File
How To Create an Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters. The easiest way to creat...
2007-04-22, 4986👍, 0💬

How To Do Clean Up If CREATE DATABASE Failed
How To Do Clean Up If CREATE DATABASE Failed? - Oracle DBA FAQ - Creating New Database Instance Manually To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Tr...
2007-04-23, 4917👍, 0💬

How To Start an Oracle Instance
How To Start an Oracle Instance? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOM...
2007-04-23, 4849👍, 0💬

How To Create an Oracle Database
How To Create an Oracle Database? - Oracle DBA FAQ - Creating New Database Instance Manually There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually.
2007-04-22, 4800👍, 0💬

How To Start a Specific Oracle Instance
How To Start a Specific Oracle Instance? - Oracle DBA FAQ - Creating New Database Instance Manually A simple way to start a specific Oracle instance is to start the instance with the PFILE option as shown in the following example: >.\bin\sqlplus /nolog SQL> CONNECT / AS SYSDBA Connected. SQL> STARTU...
2007-04-23, 4774👍, 0💬

How To Create an Oracle Database Manually
How To Create an Oracle Database Manually? - Oracle DBA FAQ - Creating New Database Instance Manually Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Adm...
2007-04-22, 4770👍, 0💬

How To Create a Server Parameter File
How To Create a Server Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter ...
2007-04-23, 4769👍, 0💬

How To Establish Administrator Authentication to the Server
How To Establish Administrator Authentication to the Server? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authenticati...
2007-04-22, 4724👍, 0💬

How To Connect the Oracle Server as SYSDBA
How To Connect the Oracle Server as SYSDBA? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank pass...
2007-04-23, 4700👍, 0💬

How To Build Data Dictionary View an New Database
How To Build Data Dictionary View an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 9. The Oracle Administrator Guide suggests to run two SQL scripts provided by Oracle as shown bellow: SQL> @/u01/oracle/rdbms/admin/catal og.sqlSQL> @/u01/oracle/rdbms/admin/cat.. .
2007-04-23, 4694👍, 0💬

How To Start Instance with a Minimal Initialization Parameter File
How To Start Instance with a Minimal Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually The sample initialization parameter file provided by Oracle seems to be not working. But we can try to start the new instance with a minimal initialization parameter file (P...
2007-04-23, 4686👍, 0💬

How To Run CREATE DATABASE Statement Again
How To Run CREATE DATABASE Statement Again? - Oracle DBA FAQ - Creating New Database Instance Manually After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below: SQL> @$ORACLE_HOME\config\scripts\c reate_database_fyi...
2007-04-23, 4636👍, 0💬

How To Run CREATE DATABASE Statement
How To Run CREATE DATABASE Statement? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sq...
2007-04-23, 4552👍, 0💬

How To Create Additional Tablespaces for an New Database
How To Create Additional Tablespaces for an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL> CREATE TABLESPACE users 2 DATAFILE '...
2007-04-23, 4530👍, 0💬

  Sort: Date