DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Prblems acessing 10G Database running under XP

  1. #1
    Join Date
    Jul 2005
    Posts
    4

    Unhappy Prblems acessing 10G Database running under XP

    After recently installing 10G on my XP box to do an eval I am experiencing some difficulties.

    My installation seemed to go well except for some warnings about choosing
    the default IP address.

    I was able to create several database. Now I just need to access them to create tables, Sps, etc.. I can't seem to do this.

    I was told on an Oracle forum to just use this browser address
    http://localhost:5500/etc. But when I do this I get A Java error message.

    It was also suggested that I try to see if the console is running hwich I tried using this command, emctl start dbconsole. Ir responded with ORACLE_SID variable not defined ? I thought that I did this when I created the database.

    Also I tried accessing trhe database via SQL plus. I assume that you enter the user name and password created for the desired database and the "host name" would be my pc name or "localhost" . I get an error message that states ORA-12541 TNS: no listener.

    But when I look at my services 10G_homeTNSListener has started.

    All in all setting up Oracle is pretty frustrating. And it shouldn't be.

    Setting up other db products have been pretty straight foward i.e. SQL Server or My SQL.

    Thanks you in advance for any input,

    GMann

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    oracle is a little more advanced than sql*Server or mysql therefore it needs a bit more knowledge, if those are easy to use for you - go ahead and use them

    so.

    from a command prompt so this

    lsnrctl status if it returns something about no listener do lsnrctl start
    set ORACLE_SID=
    then sqlplus "/ as sysdba"

    what do you get here? connected to an idle instance or a full SQL prompt?

    iF it says connected to an idle instance type startup to start the database then try your web page again, btw it is http://localhost:5500/em not /etc

  3. #3
    Join Date
    Jul 2005
    Posts
    4

    Reply

    Thanks for your response.

    I tried issuing the command but got this message:

    Microsoft Windows XP [Version 5.1.2600]
    (C) Copyright 1985-2001 Microsoft Corp.


    H:\OraHome_1\BIN>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 08-JUL-2005 11:28
    :45

    Copyright (c) 1991, 2004, Oracle. All rights reserved.

    Starting tnslsnr: please wait...

    Failed to open service , error 1060.
    TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
    Log messages written to H:\OraHome_1\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gordonxp)(PORT=1521)))

    Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
    ction
    Start Date 08-JUL-2005 11:28:53
    Uptime 0 days 0 hr. 0 min. 27 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File H:\OraHome_1\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gordonxp)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    H:\OraHome_1\BIN>

    Did that last line mean that it worked, the command that is ?

    I thought about buying the Adminstrators Handbook but they only have the 9i version. Could I generalize from that book to some of the basic set up stuff that I am doing ? I really don't want to order a book when I am only evaluating the product at this time.

    Thanks,

    GMAnn

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    ok, the listeber is running - how about the database using the sqlplus command line tool

  5. #5
    Join Date
    Jul 2005
    Posts
    4
    Thanks for your earlier suggestion.

    I was able to log into SQL Plus via a DOS prompt.

    Still can't log in via the windows GUI.

    Also when trying to start the dbconsole I get the following:

    H:\OraHome_1\BIN>SET ORACLE_SID = ATestDB

    H:\OraHome_1\BIN>emctl
    Environment variable ORACLE_SID not defined. Please define it.

    It is my understanding the all nedd to enter is:

    1. SET ORACLE_SID = myDatabaseName
    2. Issue the infamous command emtcl start dbconsole.

    Thanks Again,

    GMann

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, remove the spaces from the set command and use sqlplus to see if it is started

    forget enterprise manager for moment, check your database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width