How To Start Your 10g XE Server from Command Line

Q

How To Start Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition

✍: FYIcenter.com

A

You can start your 10g XE server from command line by:

Open a command line window.
Change directory to \oraclexe\app\oracle\product\10.2.0\server\BIN\.
Run StartDB.bat.

The batch file StartDB.bat contains:

net start OracleXETNSListener
net start OracleServiceXE
@oradim -startup -sid XE -starttype inst > nul 2>&1

2007-04-24, 5157👍, 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, 5457👍, 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, 5396👍, 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, 5166👍, 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, 5160👍, 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, 5158👍, 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, 5119👍, 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, 5110👍, 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, 5064👍, 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, 5043👍, 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.