Unable to Start the Admin Server in Forms 12c, due to ORA-28000
How to fix the ORA-28000 : Unable to Start the Admin Server in Forms 12c
During Forms12c installation and configuration, we have to configure a repository. (Fore more details, see the procedure in this blog: https://linecode-notes.com/2016/12/10/rcu-configuration/)
During the repository installation and depending on the choice you made, some of the following schemas are created: DEVPLG, DEV_WLS, DEV_IAU_VIEWER, DEV_STB, DEV_IAU, DEV_OPSS, DEV_IAU_APPEND, DEV_WLS_RUNTIME.
- So, for the puspose of the current post, i will simulate the ORA-28000
- Let’s begin by locking the DEV_OPSS user created in our pluggable database.
alter user DEV_OPSS account lock;
SELECT username, account_status, authentication_type
FROM dba_users
WHERE username LIKE ‘DEV_%’;
DEV_WLS_RUNTIME OPEN PASSWORD
DEV_IAU_APPEND OPEN PASSWORD
DEVPLG OPEN PASSWORD
DEV_OPSS LOCKED PASSWORD
DEV_IAU OPEN PASSWORD
DEV_STB OPEN PASSWORD
DEV_IAU_VIEWER OPEN PASSWORD
- Now, we start our weblogic server in order to see the error
startWeblogic.cmd
Caused by: java.sql.SQLException: ORA-28000: the account is locked
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:507)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:440)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:614)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
… 94 more<2017-09-07, 10:28:19,303 AM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED.>
<2017-09-07, 10:28:19,303 AM EDT> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself
<2017-09-07, 10:28:19,305 AM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN.>
Stopping Derby server…
Derby server stopped.
- To fix the previous error, we just need to unlock the DEV_OPSS user
alter user DEV_OPSS account unlock;
startWeblogic.cmd
……………………………………………………………….
<2017-09-07, 10:31:28,994 AM EDT> <Notice> <Server> <BEA-002613> <Channel “Default[2]” is now listening on 0:0:0:0:0:0:0:1:7003
mp, http.>
<2017-09-07, 10:31:28,994 AM EDT> <Notice> <Server> <BEA-002613> <Channel “Default” is now listening on 10.12.37.17:7003 for pro
p.>
<2017-09-07, 10:31:28,995 AM EDT> <Notice> <WebLogicServer> <BEA-000329> <Started the WebLogic Server Administration Server “Adm
n” running in production mode.>
<2017-09-07, 10:31:28,995 AM EDT> <Notice> <Server> <BEA-002613> <Channel “Default[1]” is now listening on 127.0.0.1:7003 for pr
tp.>
<2017-09-07, 10:31:28,995 AM EDT> <Notice> <Server> <BEA-002613> <Channel “Default[2]” is now listening on 0:0:0:0:0:0:0:1:7003
mp, http.>
<2017-09-07, 10:31:28,997 AM EDT> <Notice> <Server> <BEA-002613> <Channel “Default” is now listening on 10.12.37.17:7003 for pro
p.>
<2017-09-07, 10:31:28,999 AM EDT> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.>
<2017-09-07, 10:31:29,5 AM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>
Oracle Forms 12c Client Deployment Configuration Options Unable to Start the Admin Server in Forms 12c, due to ORA-28001
19 Responses to “Unable to Start the Admin Server in Forms 12c, due to ORA-28000”
Leave a Reply
About Me
Senior oracle DBA/Developer | 9X OCI Certified | OCP | OCE Sql Certified Expert
Hi there, just became alert to your blog through Google, and found that it is really informative. I am going to watch out for brussels. I�ll appreciate if you continue this in future. Numerous people will be benefited from your writing. Cheers!
Information very well regarded.!
A fascinating discussion is worth comment. I do believe that you
should write more on this topic, it may not be a taboo matter but generally folks don’t talk about these issues.
To the next! Cheers!!
It’s awesome to pay a visit this website and reading the views of all mates regarding this post, while I am also keen of getting
knowledge.
I think the admin of this website is actually working hard for
his web site, as here every information is quality based data.
An interesting discussion is definitely worth comment.
I believe that you need to write more on this issue,
it may not be a taboo subject but usually people don’t discuss such topics.
To the next! Many thanks!!
I used to be able to find good information from your blog posts.
Useful info. Lucky me I found your web site by chance, and I am shocked why this coincidence did not took place earlier!
I bookmarked it.
I quite like reading an article that will make people think.
Also, thanks for allowing me to comment!
I’m not sure why but this website is loading extremely slow for me.
Is anyone else having this issue or is it a problem on my end?
I’ll check back later and see if the problem still exists.
Hi there would you mind letting me know which webhost you’re working with?
I’ve loaded your blog in 3 different web browsers and I must
say this blog loads a lot quicker then most. Can you suggest a good web hosting provider at
a fair price? Thanks, I appreciate it!
This piece of writing will help the internet users for setting
up new web site or even a blog from start to end.
Good day! I could have sworn I’ve been to this website before but after going through a few of the posts I realized
it’s new to me. Anyways, I’m certainly delighted I stumbled upon it and I’ll be book-marking it and checking back regularly!
Amazing blog! Do you have any helpful hints for aspiring writers?
I’m hoping to start my own blog soon but I’m a little lost on everything.
Would you recommend starting with a free platform like WordPress or go for a paid option? There are so many
choices out there that I’m completely confused ..Any tips?
Its not my first time to pay a quick visit this website,
i am visiting this web page dailly and take pleasant information from here everyday.
Aw, this was a really nice post. In concept I want to put in writing like this additionally – taking time and actual effort to make a very good article… however what can I say… I procrastinate alot and on no account appear to get one thing done.
Great post. I will be facing some of these issues as well..
Thanks in support of sharing such a nice thinking, post is nice, thats why i
have read it fully
I read this piece of writing completely concerning the comparison of most recent and preceding technologies, it’s remarkable article.