This content has been marked as final. Show 17 replies
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:
Then from a command prompt, run:
sqlplus sys/<password> as sysdba
(it may tell you the database is already started - that's fine)
then go back to Services and start:
If your server name was created as something other than "ses" then the service names will vary.
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.
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.
sqlplus eqsys/[pwd] as sysdbaIt 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.
ORA-01031: insufficient privileges
If I insetad enter
sqlplus eqsys/[pwd]It connects just fine (but doesn't have sysdba privlege).
So, of course if I enter
ORA-01031: insufficient privileges
Edited by: 903593 on Dec 21, 2011 8:12 AM
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.
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
Oops I misread the previous post.
searchctl.bat startI was not prompted for a password.
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
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.
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
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.
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
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.
Note sure what would cause that. Can you post the contents of the following two files:
Make sure that any server names listed look correct.
You might also want to run
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.