Oracle Server is running but when I try to add through Applications Manager it is saying "Service is not running".

Oracle Server is running but when I try to add through Applications Manager it is saying "Service is not running".

Solution: Kindly do the following checks:

1) The "Connect String" given when you are connecting through the SQLPlus should be given as Database Name in Applications Manager.

2) Kindly check whether the "Database Name" that you have given is properly configured in following files in Oracle Installation.

Go to the following directory in Oracle Installation:

<Oracle_Installed_Dir>/products/10.1.0/<DBName>/NETWORK/ADMIN

a) In <listener.ora> file, check whether the HOST and ORACLE_HOME is configured properly.
b) In <tnsnames.ora> file, check whether the HOST and SERVICE_NAME is configured properly.

HOST - The machine name in which Oracle Server is running.
ORACLE_HOME - <Oracle_Installed_Dir>/products/10.1.0/<DBName>/
SERVICE_NAME - It is the DatabaseName you have given in Applications Manager.

Go to the following directory in Oracle Installation:

<Oracle_Installed_Dir>/products/10.1.0/admin/<DBName>/pidfile

In the <init.ora> file, check whether the db_name is configured correctly, where db_name is the Database Name. Also let us know what is the value of "db_domain".

If possible, restart the Oracle Server TNS Listener and Database. Then try adding the Oracle Server in Applications Manager.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Service is not running error troubleshooting

                      Follow the below steps to troubleshoot the error Ensure that the service you are trying to configure is actually running on the designated Host/IP and Port. If the service is running, ensure it is accessible from the machine where applications ...
                    • How to import certificates for monitoring Oracle database with SSL authentication?

                      For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...
                    • Setup Applications Manager as Service in Ubuntu 16 and above

                      From v16140 : Support to install and start Applications Manager as a wrapper service in Linux platforms is provided within the product. For more information, see Starting Applications Manager as a Linux Service. Follow the steps mentioned below to ...
                    • Enabling gMSA Account Authentication for SQL Server In Applications Manager

                      Using a gMSA Account for Applications Manager's SQL Server Backend Important prerequisites before starting the installation: A gMSA account can only be used when Applications Manager is running as a service on Windows platform. To use gMSA account ...
                    • Mail Server Monitor - Troubleshooting

                      Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...