ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Newbie Guide to Oracle 11g Database Common Problems - Create & Start Database, Listener , Enterprise Manager and more

Updated on July 4, 2009
Database Configuration Assistant
Database Configuration Assistant
DBCA Complete, Be sure to enter all your passwords before continuing
DBCA Complete, Be sure to enter all your passwords before continuing

Oracle Database 11g Setup and Problems

I recently setup the Oracle database 11g on my server at home, and went through a lot of troubleshooting to solve the many different errors I came across thought I would make this hub to help fellow database newbies find answers to there questions. :)

Create an Oracle Database

Creating an oracle database can be done in two basic ways either through sql (sqlplus used with oracle 11g) or using the Database configurarion Assistant.

The simplest way to setup a database is to use the database configuration assistant or dbca , but this of course can only be used for people installing there oracle database on a gui interface operating system such as a linux desktop O/S.

Now to run the database configuration assistant locate the home directory for your Oracle database installation from here ensure that you are logged in as the user with permissions to use and setup the oracle database.

Many people will install oracle using the ROOT user but this is a very bad idea and you will run into security issues down the line as well the fact that Oracle hates to use the root user for the database user.

So once your in your Oracle Database directory simply run


or sh dbca ( to shell to the database configuration assistant)

The Gui will then startup and you can simply follow the prompts to install the database you require.

Common Problem Oracle Permission Denied

Another very common problem you may run into is the permission denied error message and this can occur when you try to perform an action that is not permitted by the user you are logged in as , and this is usually the most common reason.

The best thing to do when using a GUI operating system is to actually check the permissions of specific files that are giving you problems and for an example this is how I do it on Ubuntu. Make sure you are doing everything with the USER that installed the Oracle Database to avoid these sorts of problems.

Checking Permissions

Press F2

now type sudo nautilus in the textbox and hit enter

You can now browse folders with root permissions and check permissions as well as alter them ( be careful with this you can end up creating quite a mess if you don't know what you're doing)

Through Command Line

Otherwise you can do it straight through the command line by viewing the files in your current directory

ls -l

a file will look like the following d rwx r-x ---

here we have Read Permissions, Write Permissions, and whether or not it is Executable

You can use the chmod command to alter permissions

An example of the chmod command is

chmod u-x,g+w,o+rw yourfile

Oracle Common Problem - SID or DISPLAY not set correctly

This is another very common error and it simply the Oracle System asking you to specify the SID (system identifier = Oracle DB name) or your DISPLAY which simply refers to whereabouts your server is located as in IP address.

For a simple Oracle SID not specified error simple use the follow

export ORACLE_SID = "database name"

For a DISPLAY error

export DISPLAY =

In the format above, is my server address with no specific port setup, where the oracle database is installed, alternatively you can simply specify localhost as your server location but the IP usually is best.

Creating your Listener
Creating your Listener

Oracle Database - Creating Listener, Listener Services and Status

So a major part of the Oracle database system is the Listener and its role is to listener to a specified port for request to the database, and your database setup will not function correctly without it and you will receive errors such as no listener setup or listener supports no services.

To create a database and start it we can first create it using the Net configuration assistant, which can be found in you oracle home directory

by running sh netca or ./netca , may differ depending on your linux o/s

Once setup we can access all the listener controls using the listener comand line we can login to that using "lsnctrl" , from here we can start or shutdown the listener.

Listener Supports no Services

For most new to database this error usually occurs when we start our listener before our database has actually been created and mounted, the listener will support no services as it will be the only thing running at the time. For me it always worked fine starting the listener after the database was mounted correctly.

The best way to startup everything without the use of a script was to login to SQL and start all database services then start the listener after that.

Starting SQL*PLUS and mounting your Database, Followed by Listener initialization

From your home directory run SQL by the following

sqlplus 'as sysdba' ( this is a default way to get in and the easiest to setup more users later on)

From here simply type startup

This will then go through the process of starting up the database and mounting it, you will be presented with database created and mounted when it is successful.

from here you can now start the listener using the listener control lsnctrl and everything should be fine, if you are still getting no services supported by the listener you should take a look at the setup of your listener.ora and tsnames.ora (check the settings there and ensure its pointing to the correct directory), also using lsnctrl status can show you what is registed with your listener

can be foundĀ  /oracle/product/11/db_1/network/admin

Starting Oracle Enterprise Manager

The oracle Enterprise Manager is a great software program that comes with Oracle 11g and can be used to carry out administrator tasks and even startup listeners and database's as well as check on the health of the server.

To run the Enterprise Manager once again, you have to be in the Oracle home directory and use the emctl

now type emctl start dbconsole to start the enterprise manager it will then give you the address of the Enterprise Manager which is usually https://serverip/em

Use emctl status dbconsole to see details of your Enterprise Manger and URL


    0 of 8192 characters used
    Post Comment
    • profile image


      8 years ago

      Thanks a lot!!

    • profile image 

      8 years ago

      ????oracle?????????????Listener??????netca???????????[oracle@bogon /]$ cd /u01/database/

      [oracle@bogon database]$ netca

      Oracle Net Services Configuration:


      # An unexpected error has been detected by HotSpot Virtual Machine:


      # SIGSEGV (0xb) at pc=0xa45b9420, pid=6466, tid=3086436560


      # Java VM: Java HotSpot(TM) Client VM (1.5.0_17-b02 mixed mode)

      # Problematic frame:

      # C []


      # An error report file with more information is saved as hs_err_pid6466.log


      # If you would like to submit a bug report, please visit:



      /u01/oracle/bin/netca: line 178: 6466 Aborted $JRE $JRE_OPTIONS -classpath $CLASSPATH $*

      [oracle@bogon database]$

      ????????????????????????????????????????????? QQ?527188553 ?????

    • profile image


      8 years ago

      i just currently craeted a database using the configuration assistant and after i clicked finish everything disappeared?? is there anywere that i have to loacte my database from ?? im very new to racle and i have to learn it for my university, please help , thank you

    • profile image


      8 years ago

      i m having problems with oracle 11g R2 installed on winxp vmware

      every time i restart my virtual machine and my database and listner don't start i m totally new and just google for the answer

      i logg in to enterprise manager and it shows there aswell

      kindly can u plz give me some commands to setup database and listner in sqlplus


    • profile image


      9 years ago from Cyprus

      How u can port Oracle 10g database to 11G?

    • expectus profile imageAUTHOR


      9 years ago from Land Downunder

      glad it helped zax

    • profile image


      9 years ago

      Hey expectus,

      Thanks for the article. Really appreciate it. This will definitely help me set up some databases.

    • expectus profile imageAUTHOR


      9 years ago from Land Downunder

      haven't used oracle for a while now , goodluck to your forum hope you can help people find solutions

    • profile image

      DBA Help 

      9 years ago

      Post your Oracle DBA questions at for quick reply


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)