.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

  Sort: Rank

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, 5418👍, 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, 5244👍, 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, 4952👍, 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, 5722👍, 0💬

How To Use "startup" Command to Start Default Instance
How To Use "startup" Command to Start Default Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition 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: ... 2007-04-24, 5306👍, 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, 5230👍, 0💬

What Happens If You Set the SGA Too Low
What Happens If You Set the SGA Too Low? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Let's you made a mistake and changed to SGA to 16MB from the SYSTEM admin home page. When you run the batch file StartDB.bat, it will return a message saying server stated. However, if you... 2007-04-24, 5140👍, 0💬

How To Change Program Global Area (PGA)
How To Change Program Global Area (PGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. ... 2007-04-24, 5356👍, 0💬

How To Change System Global Area (SGA)
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your serve... 2007-04-24, 7642👍, 0💬

How To Shutdown Your 10g XE Server from Command Line
How To Shutdown Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The ... 2007-04-24, 5149👍, 0💬

How To Unlock the Sample User Account
How To Unlock the Sample User Account? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click t... 2007-04-24, 5443👍, 0💬

How Much Memory Your 10g XE Server Is Using
How Much Memory Your 10g XE Server Is Using? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM. 2007-04-24, 5029👍, 0💬

How To Start Your 10g XE Server from Command Line
How To Start Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can start your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StartDB.bat. The batch... 2007-04-24, 5142👍, 0💬

How To Start Your 10g XE Server
How To Start Your 10g XE Server? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database. 2007-04-24, 4793👍, 0💬

How To Shutdown Your 10g XE Server
How To Shutdown Your 10g XE Server? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition se... 2007-04-24, 5050👍, 0💬

How To Check Your Oracle Database 10g XE Installation
How To Check Your Oracle Database 10g XE Installation? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to check your fresh installation of 10g Express Edition without using any special client programs, you can use a Web browser with this address, http://localhost:8... 2007-04-24, 5097👍, 0💬

How To Install Oracle Database 10g XE
How To Install Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM pas... 2007-04-24, 5090👍, 0💬

How To Download Oracle Database 10g XE
How To Download Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are dow... 2007-04-23, 5239👍, 0💬

What Operating Systems Are Supported by Oracle Database 10g XE
What Operating Systems Are Supported by Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows 2007-04-23, 4902👍, 0💬

What Are the Limitations Oracle Database 10g XE
What Are the Limitations Oracle Database 10g XE? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Data... 2007-04-23, 5075👍, 0💬

What is Oracle Database 10g Express Edition
What is Oracle Database 10g Express Edition? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that... 2007-04-23, 5025👍, 0💬

  Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML