Show the Server Version in Oracle

Q

How To Check the Server Version in Oracle?

✍: FYIcenter.com

A

Oracle server version information is stored in a table called: PRODUCT_COMPONENT_VERSION. You can use a simple SELECT statement to view the version information like this:

>.\bin\sqlplus
Enter user-name: SYSTEM/fyicenter AS SYSDBA
Connected to an idle instance

SQL> COL PRODUCT FORMAT A35
SQL> COL VERSION FORMAT A15
SQL> COL STATUS FORMAT A15
SQL> SELECT * FROM PRODUCT_COMPONENT_VERSION;

PRODUCT                             VERSION     STATUS
----------------------------------- ----------- ----------
NLSRTL                              10.2.0.1.0  Production
Oracle Database 10g Express Edition 10.2.0.1.0  Product
PL/SQL                              10.2.0.1.0  Production
TNS for 32-bit Windows:             10.2.0.1.0  Production

⇒ Introduction to Command-Line SQL*Plus Client Tool

⇐ Change Settings in Binary SPFile in Oracle

⇑ Introduction to Oracle Database 10g Express Edition

⇑⇑ Oracle Database Tutorials

2020-09-15, 2875🔥, 0💬

StartDB.bat Failed to Start the XE Instance in Oracle
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not be started. One good approach to start the default instance is... 2020-09-30, 4722🔥, 0💬

Introduction to Command-Line SQL*Plus Client Tool
Where to find answers to frequently asked questions on Command-Line SQL*Plus Client Tool? I want to learn simple ways to run commands on Oracle database server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Command-Line SQL*Plus Client Tool. Cle... 2020-08-25, 3802🔥, 0💬

Requirements for SQL*Plus Connection in Oracle
What Information Is Needed to Connect SQL*Plus an Oracle Server in Oracle? If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server: The network hostname, or IP address, of the Oracle server. The network port number where the Orac... 2020-08-25, 3697🔥, 0💬

Main Features of SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface. SQL*Plus has its own comm... 2020-08-25, 3501🔥, 0💬

Help at the SQL Prompt in Oracle
How To Get Help at the SQL Prompt in Oracle? Once SQL*Plus is started, you will get a SQL prompt like this: SQL>. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP command as shown in the following tutorial example: SQL&... 2020-08-25, 3029🔥, 0💬

Change Settings in Binary SPFile in Oracle
What To Do If the Binary SPFile Is Wrong for the Default Instance in Oracle? Let's say the SPFile for the default instance is a binary file, and some settings are wrong in the SPFile, like SGA setting is bellow 20MB, how do you change a setting in the binary file? This seems to be a hard task, becau... 2020-09-15, 3016🔥, 0💬

Start the Default Instance in Oracle
How To Use "startup" Command to Start Default Instance in Oracle? If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode: >.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SY... 2020-09-15, 2913🔥, 0💬

Login to Server without an Instance in Oracle
How To Login to the Server without an Instance in Oracle? If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. Here is how to use SQL*Plus to log in as a system BDA: >... 2020-09-15, 2909🔥, 0💬

Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle? Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A paramete... 2020-09-15, 2899🔥, 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.