BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation








EnterpriseDB: Starting and Stopping the Database Server

Oracle Tips by Burleson Consulting


EnterpriseDB comes with a control program for starting and stopping the database.  This program is named pg_ctl.  pg_ctl is an executable in Windows and a shell script in Linux.

The syntax of pg_ctl is:

pg_ctl start [-w] [-s] [-D datadir] [-l filename] [-o options] [-p path]
pg_ctl stop [-W] [-s] [-D datadir] [-m s[mart] | f[ast] | i[mmediate] ]
pg_ctl restart [-w] [-s] [-D datadir] [-m s[mart] | f[ast] | i[mmediate] ] [-o options]
pg_ctl reload [-s] [-D datadir]
pg_ctl status [-D datadir]
pg_ctl kill [signal_name] [process_id]

pg_ctl resides in the bin directory under the EnterpriseDB Home.  On a default installation in Microsoft Windows, that would be c:\EnterpriseDB\8.1\dbserver\bin.  On Linux, the file would reside in /opt/ EnterpriseDB/8.1/dbserver/bin. 

In most cases, you will not need to run pg_ctl directly.  You will normally run the included shell scripts from an icon that EnterpriseDB includes in the installation package.

If for some reason you do need to run pg_ctl directly, you can contact support or view the exact syntax in the provided EnterpriseDB documentation.  When you do run pg_ctl directly, the two most common options that you will need to include are the –D option and the –l option.

-D is the data directory that you specified above (see Figure 2.8).  –l is the filename of your log file. 

Starting the Database in Windows

Starting the database in MS-Windows is as easy as running a batch file.  After a successful installation, you should have a menu option to start and stop the database.  The Start Database command is under Start --> Programs --> EnterpriseDB Advanced Server --> Start Database.

The Remote DBA Management Server will also be started by running this menu option.

In Windows, by default, EnterpriseDB is configured as a Service and is configured to automatically start when Windows starts, Figure 2.17.  This means it runs without a console and can be auto-started when the machine boots.  You can get to the Services program by running Start --> Settings --> Administrative Tools --> Services.

Figure 2.17: EnterpriseDB Services

There are two services installed: The EDB Database Server (high-lighted above) and the EDB Management Server.   You can tell if the service is running by looking at the Status column and you can see if it is configured to auto-start by looking at the Startup Type column.

You can view the properties of the service by right-clicking and choosing properties, Figure 2.18.

Figure 2.18: EnterpriseDB Database Server Service

You can turn off auto-start by changing the Startup type from Automatic to Manual.

Notice that the executable being called is the program, pg_ctl.exe.  pg_ctl.exe must be run as the unprivileged user created earlier (enterprisedb by default).  You can see that in the logon credentials for this service, Figure 2.19.

Figure 2.19: EnterpriseDB Database Service Logon Credentials

The Remote DBA Management Server service, Figure 2.20, runs the program, wrapper.exe in the Management Server home directory.  You can run the database without running the Management Server if you want to save resources (although, in my experience, the Management Server really doesn’t consume much in the way of resources).

Figure 2.20: Remote DBA Management Server Service

This is an excerpt from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.

Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.



Remote DBA Service

Oracle Tuning Book


Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software







BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.

Hit Counter