This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Dec 23, 2011 7:26 AM by JimG RSS

Invalid username or password when trying to start/stop SES

JimG Newbie
Currently Being Moderated
I've recently taken over this project as the previous person left the company. Last week everything was running just fine. This week, when I tried to go to either the search page or the admin page, I see:

Internet Explorer can not display the Webpage.

It seems something died on the server.

When I exectue the searchctl.bat, I get the following error.

oracle.search.config.OESException: Error while executing action: "stopall"
Caused by: oracle.search.config.OESException: Invalid username or password. Unable to connect to Oracle SES.
at oracle.search.config.Ctl.run(Ctl.javva:2119)
at oracle.search.config.Ctl.main(Ctl.java:2173)
Caused by: oracle.search.config.OESException: Invalid username or password. Unable to connect to Oracle SES.

I'm not promoted for a username/password so I don't know if it's trying to use my windows login or if it's reading from a config file somewhere. If it's the former, then I need to give myself access (I do have the admin username/password).

Version info:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0

SES 10.1.8

Windows Server 2002 SP 2

The server was patched and restarted over the weekend.

I also tried rebooting the server to see if it would automatically startup, and it didn't.

Edited by: 903593 on Dec 20, 2011 4:00 PM
  • 1. Re: Invalid username or password when trying to start/stop SES
    damorgan Oracle ACE Director
    Currently Being Moderated
    You are working with software so old it is in desupport mode.

    Has your company paid for extended support?

    If not I'd recommend starting with a phone call to your local sales rep and getting a CSI number you can use to open an SR.
  • 2. Re: Invalid username or password when trying to start/stop SES
    Roger Ford Expert
    Currently Being Moderated
    You should have an option in your start menu to start SES.

    If that doesn't work, try starting the services manually.

    Go to Control Panel -> Administrative Tools -> Services, and start the following services in this order:

    OraclesesTNSListener
    OracleServiceSES

    Then from a command prompt, run:
    sqlplus sys/<password> as sysdba
    startup
    quit

    (it may tell you the database is already started - that's fine)
    then go back to Services and start:

    OraclesesOC4J

    If your server name was created as something other than "ses" then the service names will vary.
  • 3. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    damorgan,

    Sounds about right. We strive to stay two full releases behind.
  • 4. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    Roger,

    Yes, the option is in the help menu, however it didn't work. Cmd window opens some text scrolls by (too fast to read) then it closes. Web site still fails to open. The start menu option really runs the searchctl.bat file with the parameter startall. Executing that manually from the command prompt, allows me to see the error I posted at the top of the thread.

    So next I tried your manual steps. The first two processes were already running. When I try to enter sqlplus as sysdba I get insufficient privileges.

    I went with the assumption that the db was already started so I then started the OracleSESOC4J Service, but I still can't open the website.
  • 5. Re: Invalid username or password when trying to start/stop SES
    Roger Ford Expert
    Currently Being Moderated
    It's done funny things with the formatting there so I'm not sure what you actually entered. You can't do
    sqlplus / as sysdba
    You must do
    sqlplus sys/password as sysdba
    Where password is the SES admin password

    Does that help at all?
  • 6. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    Your directions were fine.
    The only admin account I have is eqsys, not sys. And this account was able to connect to the Admin page last week before the server restart.

    I entered
    sqlplus eqsys/[pwd] as sysdba
    It returns:

    SQL*Plus: Release 10.1.0.5.0 - Production on Wed Dec 21 08:04:01 2011

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    ERROR:
    ORA-01031: insufficient privileges


    Enter user-name:

    If I insetad enter
    sqlplus eqsys/[pwd]
    It connects just fine (but doesn't have sysdba privlege).
    So, of course if I enter
    SQL> startup

    I get
    ORA-01031: insufficient privileges

    Edited by: 903593 on Dec 21, 2011 8:12 AM
  • 7. Re: Invalid username or password when trying to start/stop SES
    Roger Ford Expert
    Currently Being Moderated
    You can't NOT have a sys account.

    You will have sys, system and eqsys. Only sys can run sqlplus if the database isn't started, and only using "sys/password as sysdba".

    However, if eqsys is able to connect, the database is probably started. I would still recommend doing as I said though.

    Once the database is started you can try just

    searchctl start ( not startall ). It should prompt you for a password.
  • 8. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    Hmm... I only have eqsys at this point. I'll have to dig through the notes for the other two.

    Connected to sql as eqsys and entered start, I was not prompted for a password. It just immediately returned with the SQL> prompt

    Update:
    Oops I misread the previous post.

    I ran
    searchctl.bat start
    I was not prompted for a password.
    It returned
    The OracleSESOC4J service is starting.
    The OracleSESOC4J service was started successfully.

    Still can't connect to the website, and when I look at services OracleSESOC4J is not running.

    Edited by: 903593 on Dec 21, 2011 9:46 AM

    Edited by: JimG on Dec 21, 2011 10:54 AM
  • 9. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    As I said earlier, OracleServiceSES and OracleSESTNSListener were both already started.

    When I start OracleSESOC4J, it looks like it starts, however if I wait about 10 seconds, and refresh the Services dialog, it shows that it is not running.

    Just for fun I stopped the other two services as well, and restarted in the correct order. Same issue with OracleSESOC4J. It appears to start just fine, but after 10 seconds or so, refreshing the dialog shows that it's not running.
  • 10. Re: Invalid username or password when trying to start/stop SES
    Roger Ford Expert
    Currently Being Moderated
    The password is - or should be - the same for eqsys, sys and system.

    Sorry, you're right, "searchctl start" doesn't prompt for a password.

    If the service starts but then stops again something has probably caused it to crash. Check the logfile in

    <ses_installation_dir>\oc4j\j2ee\OC4J_SEARCH\log\oc4j.log
  • 11. Re: Invalid username or password when trying to start/stop SES
    damorgan Oracle ACE Director
    Currently Being Moderated
    Unfortunately your organization is not alone. My recommendation to practitioners of the dark arts is to keep their skills current.

    While you can not force your employer to upgrade ... you can upgrade your resume by finding a job with an organization that values their employees and demonstrates it by working with fully supported hardware and software.
  • 12. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    Now we're gettings somewhere, thanks Roger.

    I see this pattern over and over in the log file ever since the reboot on Friday.

    11/12/16 19:26:25 oracle.hooks: Loading extensions
    11/12/16 19:26:25 oracle.hooks: Loading extension class: oracle.oc4j.extensions.CreateStartupCheckpointFile with arguments: startoc4jwaitfile
    11/12/16 19:26:54 Error initializing server: Unable to start HTTP-Server. default-web-site configuartion may not be valid.
    11/12/16 19:26:55 Fatal error: server exiting

    Edited by: JimG on Dec 21, 2011 1:00 PM
  • 13. Re: Invalid username or password when trying to start/stop SES
    JimG Newbie
    Currently Being Moderated
    damorgan,

    After losing my job with a startup that tried to stay on the leading edge, but did a horrible job keeping it's income & expenses in some kind of reasonable balance, I'm happy to be with an organization that shows it values it's employees by making payroll on a timely basis even if my desktop is still running XP and I'm maintaining classic ASP websites.
  • 14. Re: Invalid username or password when trying to start/stop SES
    Roger Ford Expert
    Currently Being Moderated
    Note sure what would cause that. Can you post the contents of the following two files:
    <ses_install_dir>\oc4j\j2ee\OC4J_SEARCH\config\http-web-site.xml
    and
    <ses_install_dir>\oc4j\j2ee\OC4J_SEARCH\config\data-sources.xml

    Make sure that any server names listed look correct.

    You might also want to run
    lsnrctl status
    from a command prompt and check that the service name there matches the service name in the SESConnectionPool towards the end of data-sources.xml.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points