General

How do I install and configure Oracle client?

Cairon Davison

How do I install and configure Oracle client?

To install Oracle Database Client perform the following steps:

  1. Log on as a member of the Administrators group to the computer to install Oracle components.
  2. Insert the Oracle Database Client installation media and navigate to the client directory.
  3. Double-click setup.exe to start Oracle Universal Installer.

How do I manually create a database in Oracle 11g?

Create a Database Manually

  1. Step 1: Decide on Your Instance’s System Identifier (SID)
  2. Step 2: Create the Initialization Parameter File.
  3. Step 3: Connect to and Start the Instance.
  4. Step 4: Issue the CREATE DATABASE Statement.
  5. Step 5: Run Scripts to Build Data Dictionary Views.
  6. Step 6: Run Scripts to Install Additional Options.

How do I create a DBA account?

Steps

  1. Log in to SQL *Plus: sqlplus ‘/ as sysdba’
  2. Create a new user with an administrator password: create user user_name identified by admin_password ;
  3. Assign the sysdba privilege to the new Oracle user: grant sysdba to user_name ;

Where can I find DBA users in Oracle?

SQL> select * from dba_role_privs where granted_role=’DBA’; The v$pwfile_users view contains a list of all users who have been granted the SYSDBA or SYSOPER privilege.

What is default Sysdba password in oracle 11g?

Default user name and password The installation program will install the SYSDBA user with the password masterkey (actually, it’s masterke : characters after the eighth are ignored). If your server is exposed to the Internet at all, you should change this password immediately using the gsec command-line utility.

How do I manually create a database in Oracle 11g Linux?

How to Create Oracle 11g Database Manually on Linux

  1. Create adump folder. mkdir -p /u01/app/oracle/admin/DB_SID/adump.
  2. Create init file such as : *.audit_file_dest=’/u01/app/oracle/admin/DB_SID/adump’ *.audit_trail=’db’
  3. Prepare database creation script:
  4. Follow below steps: $ export ORACLE_SID=DB_SID.

How do I run SQL commands in Oracle 11g Express Edition?

Display the SQL command prompt window. For example, on Windows, click Start, then Programs (or All Programs), then Oracle Database 11g Express Edition, and then Run SQL Command Line….Connect as the SYSTEM user:

  1. Type: connect.
  2. Enter user-name: system.
  3. Enter password: