RSINFOMINDS: 10 Jun 2014

About Us

RSInfoMinds, a web based IT Training and Consultancy firm. It is established with high dreams in training people in IT Infrastructure Field. We provide Online and Class Room training in various fields of IT Infrastructure Management.

Join Us: http://www.facebook.com/RSInfoMinds

Mail Us: rsinfominds@gmail.com

Twitter: @RSInfoMinds

We are specialized in the below courses:

Redhat Linux Admin Redhat Linux Cluster

Redhat Virutualization IBM AIX Admin

IBM AIX Virtualization IBM AIX Cluster

HP Unix Admin HP Unix Cluster

HP Unix Virtualization Shell Scripting

Veritas Volume Manager Veritas Cluster

Oracle Core DBA VMWare

We provide training in such a way, So that you get in depth knowledge on the Courses you look for.

And we ensure you are very confident from each and every Techincal aspect that the IT Industry needs and expects from you.

We also conduct Workshops on the latest technology and the real time faculties sharing their work experiences to make you the best.

Tuesday, 10 June 2014

How To Connect To Oracle11g Running on Linux VM using Toad : Part II

TNSNames ?????

This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.183.148)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl.cluster.com)

)

Host could be your server running 11g name or the IP.

Make sure the port is opened on the server.

Now Open Toad and connect with the user ID:

How To Connect To Oracle11g Running on Linux VM using Toad : Part I

1) First we need to install oracle11g Client.

During the installation make sure you select "Run Installer".

Proceed with the installation.

2) Download Toad for Windows and do the installation.

Now login to the oracle11g server and copy the contents of “tnsnames.ora” to the below location on the windows where the oracle11g Client is installed.

/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

Create A Boot Partition In Linux

We need to use fdisk utility to create a boot partition.

Using the flag "a" we can toogle between "Boot Flag" Enable and Disable.

Oracle Listener Stop/Start/Status

[oracle@node1 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-JUN-2014 10:12:57

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/node1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.oracle.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 10-JUN-2014 10:12:57
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.oracle.com)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@node1 ~]$

Command to start the Listener.

[oracle@node1 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 10-JUN-2014 10:12:27

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

[oracle@node1 ~]$

Connect To Oracle11g

[oracle@node1 ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 10 10:11:06 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

sqlplus is the wizard to connect to ORACLE DBA.

Every DBA will have a base table.

SQL> select name from v$database;

NAME

---------

ORCL

SQL>

ORCL is the name of the Base Table.