How To Check the Server Version

Q

How To Check the Server Version? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition

✍: FYIcenter.com

A

Oracle server sersion 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

2007-04-25, 4851👍, 0💬

How To Login to the Server without an Instance
How To Login to the Server without an Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition 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. He... 2007-04-24, 4979👍, 0💬

How To Run the Anonymous Block Again
How To Run the Anonymous Block Again? - Oracle DBA FAQ - Introduction to PL/SQL If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script: SQL> set serveroutput on; SQL> begin 2 dbms_output.put_line('This is a PL/SQL FAQ... 2007-04-25, 4883👍, 0💬

How To Check the Server Version
How To Check the Server Version? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle server sersion 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... 2007-04-25, 4852👍, 0💬

What To Do If the StartBD.bat Failed to Start the XE Instance
What To Do If the StartBD.bat Failed to Start the XE Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If StartBD.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 b... 2007-04-24, 4651👍, 0💬

What To Do If the Binary SPFile Is Wrong for the Default Instance
What To Do If the Binary SPFile Is Wrong for the Default Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition 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 se... 2007-04-25, 4627👍, 0💬

How Many Anonymous Blocks Can Be Defined
How Many Anonymous Blocks Can Be Defined? - Oracle DBA FAQ - Introduction to PL/SQL An anonymous block is stored in the user's current session without any name. So you can only define one anonymous block at any time. If you define another anonymous block, the new block will replace the previously de... 2007-04-25, 4558👍, 0💬

What Is PL/SQL
What Is PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional sta... 2007-04-25, 4555👍, 0💬

What Are the Types PL/SQL Code Blocks
What Are the Types PL/SQL Code Blocks? - Oracle DBA FAQ - Introduction to PL/SQL There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name.... 2007-04-25, 4548👍, 0💬

Where Are the Settings Stored for Each Instance
Where Are the Settings Stored for Each Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition 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 sho... 2007-04-25, 4499👍, 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.