Posts Tagged ‘oracle’

How To Check Oracle Licencing

Posted: June 28, 2011 in Misc
Tags: ,

$ sqlplus “/ as sysdba”
SQL> select * from v$version;
SQL> exit
Here is some sample output from 11g Standard Edition:

BANNER
——————————————————————————–
Oracle Database 11g Release 11.2.0.1.0 – 64bit Production
PL/SQL Release 11.2.0.1.0 – Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 – Production
NLSRTL Version 11.2.0.1.0 – Production

What is the difference between the Enterprise, Standard and Personal Editions of Oracle?
Submitted by admin on Sat, 2005-10-15 04:19

Oracle Enterprise Edition:

Enterprise Edition is the full (top of the range) version or the Oracle Database Server. Options like RAC, Partitioning, Spatial, etc. can be purchased separately to enhance the functionality of the database.

Oracle Standard Edition:

Standard Edition is designed for smaller businesses and enterprises. It offers a subset of the features/ functionality implemented in Enterprise Edition. Database options like Data Guard, Partitioning, Spatial, etc. is not available with Standard Edition (from 10g one can use RAC with Standard Edition). Standard Edition can only be licensed on servers with a maximum capacity of four processors.

Oracle Standard Edition One:

Standard Edition One is a low cost, entry-level version of the Oracle Standard Edition database server. Standard Edition One can only be licensed on small servers with a maximum capacity of two processors.

Oracle Personal Edition:

Personal Oracle is a single user version of the database server. It is mostly the same as Enterprise Edition, but doesn’t support advanced options like RAC, Streams, XMLDB, etc.

Oracle Lite:

Oracle Light is a database engine that can be used on mobile platforms like cell phones and PDA’s.

Oracle XE:

Express Edition (XE) is a free, downloadable version of the Oracle database server. Oracle XE can only be used on single processor machines. It can only manage up to 4 GB of data and 1 GB of memory. ISVs can embed XE in 3rd party products and redistribute it freely.


To Shutdown Oracle :

1. Log in to Oracle Server as user oracle . You can log in as root and then su to oracle as well.

[root@hkrhel33 ~]# su –
[root@hkrhel33 ~]# su oracle
[oracle@hkrhel33 root]$ ps -ef | grep pmon

root     25524 25413  0 15:14 pts/7    00:00:00 grep pmon
oracle   27243     1  0 May16 ?        00:00:06 ora_pmon_WMS852 <— This is DB name

[oracle@hkrhel33 root]$ . oraenv

ORACLE_SID = [ora_pmon_WMS852] ? WMS852
The Oracle base has been set to /u01/app/oracle
[oracle@hkrhel33 root]$ sqlplus ‘/as sysdba’

SQL*Plus: Release 11.2.0.2.0 Production on Thu May 19 15:22:53 2011

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

Connected to:
Oracle Database 11g Release 11.2.0.2.0 – 64bit Production

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

To Start up Oracle :

[oracle@hkrhel33 root]$ ps -ef | grep pmon
oracle    4720  4516  0 15:42 pts/2    00:00:00 grep pmon
[oracle@hkrhel33 root]$ . oraenv
ORACLE_SID = [oracle] ? WMS852
The Oracle base has been set to /u01/app/oracle
[oracle@hkrhel33 root]$ sqlplus ‘/as sysdba’

SQL*Plus: Release 11.2.0.2.0 Production on Thu May 19 15:43:07 2011

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

Connected to:
Oracle Database 11g Release 11.2.0.2.0 – 64bit Production

SQL> startup