Oracle - Establish Administrator Authentication to the Server in Oracle

Establish Administrator Authentication to the Server in Oracle

Q

How To Establish Administrator Authentication to the Server in Oracle?

✍: FYIcenter.com

A

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 authentication is easier on Windows system. If you used your own Windows user account to install Oracle server, it will put your Windows user account into a special Window's user group called SYSDBA. This Window's user group will be fully trusted by Oracle server with SYSDBA privilege.

To continue with other steps, make sure you logged into the Windows system with a user account in the SYSDBA group.

⇒Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2019-04-03, 838👍, 0💬

Create an Initialization Parameter File in Oracle
How To Create an Initialization Parameter File in Oracle? 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 create an initialization parameter file to copy from t... 2019-04-03, 889👍, 0💬

Establish Administrator Authentication to the Server in Oracle
How To Establish Administrator Authentication to the Server in Oracle? 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 authentication is easier on Windows system. If you used your ... 2019-04-03, 839👍, 0💬

Create an Oracle Database Manually in Oracle
How To Create an Oracle Database Manually in Oracle? 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 Administrator Authentication Method Step 3: Create t... 2019-04-03, 786👍, 0💬

Connect to Oracle Server as SYSDBA in Oracle
How To Connect the Oracle Server as SYSDBA in Oracle? 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 password and AS SYSDBA option. Here is a sample sessi... 2019-04-03, 769👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.