Oracle Database 10g Release 2

https://web.deu.edu.tr/doc/oracle/B19306_01/
Admin
Oracle Database 10g is a relational database management system (RDBMS) that provides comprehensive...
Tokens:24,581,788
Snippets:184,096
Trust Score:9.5
Update:5 days ago
Show doc for...
Tokens:
Raw
### Run Oracle Universal Installer setup.exe

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/gateways.102/b16211/ch4.htm

Example command to start the Oracle Universal Installer from the command line. The path is an example; replace with the actual path to setup.exe on your system.

```plaintext
D: \Disk1\setup.exe
```

--------------------------------

### Start Oracle Universal Installer with setup.exe

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/gateways.102/b16211/ch4.htm

Run this command from the Run dialog to launch the Oracle Universal Installer. The example assumes the installation media is mapped to the D: drive.

```plaintext
D:\Disk1\setup.exe

```

--------------------------------

### Example: Record Mode with Windows Path

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/gateways.102/b19083/advance.htm

Example command that records installation settings to a response file at C:\response_files\install_oracle10g. This is a concrete example of the setup -record command with a Windows file path.

```shell
setup -record -destinationFile C:\response_files\install_oracle10g

```

--------------------------------

### START command example with output

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/network.102/b14213/lsnrctl.htm

Example of the START command and its output, showing the listener startup and status.

```bash
LSNRCTL> START

Starting /private/dsteiner/sales/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.0.1.0.0 
System parameter file is /oracle/network/admin/listener.ora
Log messages written to /oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sales-server)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.0.1.0.0 
Start Date                15-NOV-2003 18:02:25
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/network/admin/listener.ora
Listener Log File         /oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))
The listener supports no services
The command completed successfully
```

--------------------------------

### srvctl start service examples

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/rac.102/b14197/srvctladmin.htm

Examples of starting services on a database and on a specific instance.

```bash
srvctl start service -d crm -s crm
```

```bash
srvctl start service -d crm -s crm -i crm2
```

--------------------------------

### srvctl start asm examples

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/rac.102/b14197/srvctladmin.htm

Examples of starting a single ASM instance and all ASM instances on a node.

```bash
srvctl start asm -n crmnode1 -i asm1
```

```bash
srvctl start asm -n crmnode2
```

--------------------------------

### STARTUP command example

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/network.102/b14213/cmctl.htm

Example output after successfully issuing the STARTUP command.

```text
CMCTL:CMAN_user-sun.us.oracle.com> STARTUP
Starting CMAN instance: CMAN_user-sun.us.oracle.com, please wait...
TNS-04090: *** CMCTL WARNING: No password set in the CMAN instance ***
CMAN for Solaris: Version 10.1.0.0.0 - Beta
Status of the Instance
----------------------
Instance name             CMAN_user-sun.us.oracle.com
Version                   CMAN for Solaris: Version 10.1.0.0.0 - Beta
Start date                20-JAN-2003 19:04:25
Uptime                    0 days 0 hr. 0 min. 3 sec
Num of gateways started   2
Average Load level        0
Log Level                 SUPPORT
Trace Level               OFF
Instance Config file      /ade/user_cman_test/oracle/network/admin/cman.ora
Instance Log directory    /ade/user_cman_test/oracle/network/log/
Instance Trace directory  /ade/user_cman_test/oracle/network/trace/
The command completed successfully
```

--------------------------------

### PL/SQL Example: Get Bulk Load Version and Begin Bulk Loading

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/appdev.102/b14253/long_ref.htm

This example gets a bulk load version number for the W1 workspace and starts the bulk load operation into the EMP table in that workspace. It calls DBMS_WM.GetBulkLoadVersion and DBMS_WM.BeginBulkLoading. The example is shown as a PL/SQL block terminated with a slash.

```plsql
DECLARE
  version INTEGER;
BEGIN
  SELECT DBMS_WM.GetBulkLoadVersion ('W1') INTO version FROM DUAL;
  DBMS_WM.BeginBulkLoading ('EMP', 'W1', version);
END;
/

```

--------------------------------

### runInstaller -help command (additional options)

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b15660/app_nonint.htm

Shows help for other runInstaller options. This is the same command as the first example, but it is presented separately in the source.

```shell
$ /directory_path/runInstaller -help


```

--------------------------------

### Start instance with default parameters

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/server.102/b14357/ch12045.htm

Starts an instance using the standard parameter file, mounts the default database, and opens it.

```sql
STARTUP 
```

--------------------------------

### Example log filename format

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b15660/app_ts.htm

The log files follow a naming convention including the date and time of the installation start.

```text
installActionsdate_time.log
```

--------------------------------

### Display Oracle Universal Installer help options

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b14312/advance.htm

Run the setup.exe executable with the -help flag to view all available command-line options.

```text
SYSTEM_DRIVE:\setup.exe_location> setup -help
```

--------------------------------

### Commit method example

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/win.102/b14307/OracleTransactionClass.htm

C# example demonstrating the Commit method. It starts a transaction, inserts two records with the same value, and commits or rolls back depending on whether a primary key constraint is violated. The example includes database setup comments and prints row counts before and after the transaction.

```csharp
// Database Setup, if you have not done so yet
/*
connect scott/tiger@oracle
DROP TABLE MyTable;
CREATE TABLE MyTable (MyColumn NUMBER);
--CREATE TABLE MyTable (MyColumn NUMBER PRIMARY KEY);
 
*/
 
// C#
 
using System;
using System.Data;
using Oracle.DataAccess.Client; 
 
class CommitSample
{
  static void Main()
  {
    // Drop & Create MyTable as indicated in Database Setup, at beginning
    
    // This sample starts a transaction and inserts two records with the same
    // value for MyColumn into MyTable.
    // If MyColumn is not a primary key, the transaction will commit.
    // If MyColumn is a primary key, the second insert will violate the 
    // unique constraint and the transaction will rollback.
 
 
    string constr = "User Id=scott;Password=tiger;Data Source=oracle";
    OracleConnection con = new OracleConnection(constr);
    con.Open();
 
    OracleCommand cmd = con.CreateCommand();
 
    // Check the number of rows in MyTable before transaction
    cmd.CommandText = "SELECT COUNT(*) FROM MyTable";    
    int myTableCount = int.Parse(cmd.ExecuteScalar().ToString());
 
    // Print the number of rows in MyTable
    Console.WriteLine("myTableCount = " + myTableCount);
 
    // Start a transaction
    OracleTransaction txn = con.BeginTransaction(
      IsolationLevel.ReadCommitted);
 
    try
    {
      // Insert the same row twice into MyTable
      cmd.CommandText = "INSERT INTO MyTable VALUES (1)";
      cmd.ExecuteNonQuery();
      cmd.ExecuteNonQuery(); // This may throw an exception
      txn.Commit();
    }
    catch (Exception e)
    {
      // Print the exception message
      Console.WriteLine("e.Message    =  " + e.Message);
 
      // Rollback the transaction
      txn.Rollback();
    }    
 
    // Check the number of rows in MyTable after transaction    
    cmd.CommandText = "SELECT COUNT(*) FROM MyTable";
    myTableCount = int.Parse(cmd.ExecuteScalar().ToString());
 
    // Prints the number of rows
    // If MyColumn is not a PRIMARY KEY, the value should increase by two.
    // If MyColumn is a PRIMARY KEY, the value should remain same.
    Console.WriteLine("myTableCount = " + myTableCount);
 
    txn.Dispose();
    cmd.Dispose();
 
    con.Close();
    con.Dispose();
  }
}

```

--------------------------------

### Create tables for examples

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/network.102/b14266/apdvcntx.htm

Setup data structures required for the examples to work.

```sql
CREATE TABLE apps.customers (cust_no NUMBER(4), cust_name VARCHAR2(20));
CREATE TABLE scott.orders_tab (order_no NUMBER(4));
```

--------------------------------

### Start Oracle Universal Installer from DVD

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b15668/toc.htm

Command to start the installer when installing from a DVD.

```bash
$ /mount_point/db/runInstaller


```

--------------------------------

### Release directory product examples

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b15667/app_nas.htm

Example paths for installing different products from the same release.

```text
/u01/app/oracle/product/10.2.0/crs
/u01/app/oracle/product/10.2.0/db_1
/u01/app/oracle/product/10.2.0/companion_1
```

--------------------------------

### Pass ORACLE_HOME_NAME as a command-line argument to setup

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b14313/advance.htm

Example of passing the ORACLE_HOME_NAME variable as a command-line argument when running Oracle Universal Installer. The variable and its setting must be enclosed in quotes.

```plaintext
SYSTEM_DRIVE:\setup.exe_location> setup -silent "ORACLE_HOME_NAME=OraDBHome1" ...

```

--------------------------------

### Setup for Object Type Examples

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/appdev.102/b14251/adfns_extern_proc.htm

Provides the SQL commands to set up the necessary data structures for the object type examples. It connects as SYS, grants CREATE ANY LIBRARY to scott, connects as scott, and creates a library SOMELIB pointing to /tmp/lib.so.

```sql
CONN SYS/CHANGE_ON_INSTALL AS SYSDBA;
GRANT CREATE ANY LIBRARY TO scott;
CONNECT scott/tiger
CREATE OR REPLACE LIBRARY SOMELIB AS '/tmp/lib.so';
```

--------------------------------

### Start installer from hard disk

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b19078/toc.htm

Command to start the Oracle Universal Installer when installation files are located on the hard disk.

```bash
$ ./runInstaller


```

--------------------------------

### Start Oracle Universal Installer

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b25145/oemqi.htm

Start Oracle Universal Installer from the top directory of the DVD to install Grid Control.

```bash
./runInstaller

```

--------------------------------

### srvctl start listener example

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/rac.102/b14197/srvctladmin.htm

Example of starting the default listener on mynode1.

```bash
srvctl start listener -n mynode1
```

--------------------------------

### setup.exe -help command

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/gateways.102/b19083/advance.htm

Run setup.exe with the -help option to display help information on the full set of Oracle Universal Installer options.

```plaintext
C:\ORACLE_BASE\ORACLE_HOME\oui\bin> setup.exe -help

```

--------------------------------

### srvctl start nodeapps example

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/rac.102/b14197/srvctladmin.htm

Example of starting node applications on mynode1.

```bash
srvctl start nodeapps -n mynode1
```

--------------------------------

### Setup for external procedure examples

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/appdev.102/b14251/adfns_extern_proc.htm

SQL*Plus commands to set up directories and Java resources needed for certain examples.

```sql
CONNECT system/manager
GRANT CREATE ANY DIRECTORY to scott; 
CONNECT scott/tiger
CREATE OR REPLACE DIRECTORY bfile_dir AS '/tmp';
CREATE OR REPLACE JAVA RESOURCE NAMED "appImages" USING BFILE (bfile_dir,'bfile_audio');
```

--------------------------------

### Display Oracle Universal Installer help with setup -help

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b14324/advance.htm

Run setup.exe with the -help option to display help information for all Oracle Universal Installer options. The command is executed from the setup.exe location directory.

```plaintext
SYSTEM_DRIVE:\setup.exe_location> setup -help

```

--------------------------------

### Start Oracle Universal Installer

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b15662/remove_oracle_sw.htm

Start Oracle Universal Installer to remove Oracle software.

```shell
$ $ORACLE_HOME/oui/bin/runInstaller

```

--------------------------------

### Start extproc demonstration

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/server.102/b15658/ldr_demo.htm

Run the extproc demonstration from SQL*Plus.

```sql
SQL> @extproc

```

--------------------------------

### srvctl start instance example

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/rac.102/b14197/srvctladmin.htm

Example of starting instances crm1 and crm4 for the crm database.

```bash
srvctl start instance -d crm -i "crm1,crm4"
```

--------------------------------

### Run setup.exe with command line arguments

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/install.102/b14312/advance.htm

Example of passing variable settings directly as command line arguments when running the installer.

```bash
SYSTEM_DRIVE:\setup.exe_location> setup -silent "ORACLE_HOME_NAME=OraDBHome1" ...
```

--------------------------------

### srvctl start database example

Source: https://web.deu.edu.tr/doc/oracle/B19306_01/rac.102/b14197/srvctladmin.htm

Example of starting a database named crm with open options.

```bash
srvctl start database -d crm -o open
```
Tokens:
Raw