Windows FAQ

From Oracle FAQ
Jump to: navigation, search

Oracle on Windows FAQ:

How can I automatically start Oracle on Windows?[edit]

Change the Oracle services to startup automatically upon system startup (this is the default after installation). Also ensure that ORA_ORCL_AUTOSTART is set to TRUE in the registry (change ORCL to your SID name).

How does one create a new Oracle service on Windows?[edit]

Use the oradim utility. For details, see Creating an Oracle service on Windows.

Connect as SYSDBA without password[edit]

In SQLNET.ORA, enable NTS autentication:

SQLNET.AUTHENTICATION_SERVICES = (NTS) 

In "Computer Management", navigate to "Local Users and Groups" -> Groups.
Ensure you have a "ora_dba" group and that your Windows user belongs to it.

Open a Command Prompt:

X:\> set ORACLE_SID=orcl
X:\> sqlplus /nolog
SQL> conn / as sysdba
Connected.

How does one lookup Oracle errors on Windows?[edit]

Oracle on Unix and Linux ships with an oerr utility that can do error code lookups. Oracle doesn't, however, ship an "oerr" utility for the Windows platform. The following perl script can be used to simulate oerr behaviour on Windows.

How does one schedule OS jobs on Windows?[edit]

Use the "at" command. Enter "at -?" from a cmd window for help. Alternatively, navigate to Start-> Control Panel -> Scheduled Tasks. Starting from Oracle 10g jobs can also be scheduled using the DBMS_SCHEDULER package.