Home > Uncategorized > Quick Hands-on Oracle

Quick Hands-on Oracle

After a long time, I got change to setup Oracle 10g on Windows. The task was to setup Cognos8 with Oracle connectivity. Thanks to my ex-colleague (Riaz Ahmed), who helped me to recollect the basic commands in Oracle:

1) Creating a Database:
– Used Database Configuration Assistant (dbca)

2) Creating new users for Database:

Using SQL*Plus, login as SYSTEM user to the DB Instance and use the command
SQL> CREATE USER crn8 IDENTIFIED BY crn8;
SQL> GRANT CONNECT, RESOURCE, DBA to crn8;

3) Restore a Oracle Dump File that comes as Cognos Samples:
From Command Prompt, use the command

imp fromuser=crn8 touser=crn8
file=filepath.dmp
commit=y
log=filename.log

The tnsnames.ora needs to be configured at the Client PC to communicate with the Oracle Database Server. This file is usually found at ORACLE_HOME\network\admin folder.

Some more additional command to verify the Oracle Server/Instance status:

– lsnrctl status
– lsnrctl status DB_NAME
– tnsping DB_NAME

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: