Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Java application fails when upgrading to Java 8 321 or later.

User_L28VGApr 21 2022

Java application fails when upgrading to Java 8 321 or later. Tried build 331, also fails. Is oracle looking into this. This is a known issue and high impact to security.

Comments

OrionNet
Hello,

So you created database isntance using dbca or using scripts? Did you try login thru command line?
On Windows

sqlplus "/as sysdba" 
or 

On linux/unix
sqlplus '/as sysdba'


SQL> ALTER USER username IDENTIFIED BY "mypassword";

Once logged in successfully you can change password for the users created and use orapwd utility to generate a password file for sys/system user

orapwd example
Create a new password file: 

orapwd file=orapwSID password=oracle entries=5
If the password file already exists: 

orapwd file=orapwSID password=oracle entries=5 FORCE=Y
Regards
678242
I used the install executable for Oracle 11g, at one point it asked me for a default password to use, I typed one in, had to type it in twice (two different boxes, one for the password, one for verification)
I just tried your sqlplus suggestion it says I have insufficient privileges.
I just simply downloaded the installer and ran it, went through the prompts and left everything at its default.
Unfortunately now, I can't use admin or sysdba for login user with the password I used and the manuel doesn't state that there is another password that the system has by default.
Thanks for the continued help with this, it is greatly appreciated.
OrionNet
Helllo,

You just installed oracle software ( and I assume that was a succesful installation), is that right? Also, did you create database instance usign dbca(database configuration assistant)?
If not , please create database first and its pretty interactive and self explaintory to understand.

Regards
678242
Correct, I just installed Oracle software via its installation wizard and it was a successful install, during the install it asked me if I wish for it to create a default example database using the template provided and I choose yes to that option so it created a sample database for me. I followd your instructions and created a database using the dbca and called it dbGlobal, in this wizard I also told it to add in the samples provided into the database schema. The database configuration assistant finished successfully.

I then tried the sqlplus command like you mentioned before and got the same insufficient privileges error. I presume somewhere something is not set right?
OrionNet
Hello,

Most of the time its configuration or some silly step :) and that can be overcome as you have successfully creation of database From command line perform this and post here.
You can also verify under window Services if you have both the database services are running or not. It wil show something liek "OracleServicedbGlobal".
Post last 20 lines from alert.log from /oracle/product/admin/dbGlobal/bdump/
(it should say database open).

C:> set ORACLE_SID=dbGlobal
C:>sqlplus username/password
C:> sqlplus scott/tiger
or
C:>sqlplus "/as sysdba"

Regards
678242
Thanks again for this help, I tried to find the folder you were talking about, I am running Oracle11g on Windows Vista Premium, so the folder is as follows:
k:\app\usert\admin\dbGlobal

There are 3 folders all of which I have no access to, they are:
adump
bpdump
pfile

But like I said, no access so I can't get any info from them.
I went through the database creation process again this time selecting the advanced button for security and saw a list of possible names like HR, SYS etc, of which only the last two didn't have "locked" on them, so I used SYS as the user name and the password I used, this time I was able to get into the Oracle Enterprise Manager web page on the server. After further review, this account has super adminstrator privileges so I will see about creating a basic user to use on the database from .Net, I installed the .Net developer kit from Oracle download area but when the database was created, it showed NET as not an option so this is probably another thing I need to research.

Thanks again for your help, I will mark this question as answered since through your assistance I was able to find the actual user account which is not sysdba nor is it admin but instead it is SYS.
Maybe part of my problem is also the fact that I am running this in Vista Premium, I will install this on Windows 2003 Server tonight and see if I get the same results.
Once again, many thanks for your time, you have been very helpful.
OrionNet
Hello,

You can use the 11g tutorial to for installation and creating sample database
http://www.oracle.com/technology/obe/11gr1_db/install/dbinst/windbinst2.htm

Regards

Edited by: OrionNet on Jan 5, 2009 4:44 PM

Edited by: OrionNet on Jan 5, 2009 4:48 PM
678242
Thanks again, I have marked them all as helpful and marked the thread as answered.
683385
Hi,

I am also having the same problem. I installed Oracle 11g from oracle.com.
While installation, did not change the passwords for SYS, SYSTEM etc. Now am not able to log on as administrator.
I can only logon as scott/tiger.

Do I have to uninstall and reinstall?Is there any other solution?
I also tried system/manager and sys/change_on_install. they are not working.

Pl help me.

Thanks

Edited by: user5743748 on Feb 4, 2009 4:28 PM
601496
Use OS authentication to login to the database with sysdba privileges as per OrionNet's instructions above; follow the steps to change the password for users and steps mentioned for the use of orapwd utility for modifying the password file for sys/system.
108305
Thanks for posting this!

I had exactly the same problem (and was able to log in with SYS and my default install password).
712369
Having same problem, still can't log in. Why doesn't the install give you an ID to log in with? All it does is ask you for a password, not associated w/ any login ID. Very confusing. And people wonder why everyone's going SQL Server!
721111
hi,
how can i get the installation executable for enterprise edition 11g. can i find just the compressed setup.exe and when that is executed ,it extract itself and create a database? can this be done?.
835330
Hi,
I am very new to Oracle.
I read this thread but getting more confused.

I completed installation of "Oracle 11g R2" on windows vista platform successfully.
During install, installer asked for default password to use, which I entered.
Then it asked if I wish for it to create a default database and I choose yes to that option so it created a sample database for me (its name = edm).
Now my question is how do I login to this database using SQLPLUS?

1) What will be my user name to login?? Admin, or admin, or root or sysadmin?
This is so confusing - other database installer "clearly" specifies the username for the database !
Can anyone tell what should be my next step?

My requirement is very simple - I just need to create a database, then a database-user so that I can connect to it using JDBC.
Can anyone suggest the simplest steps to achieve this in "Oracle 11g r2" ?

Thanks in advance.

=======================
DON'T WORRY FOUND THE SOLUTION.

I have to first create/allocate a tablespace (as sysdba)
Then create an user and GRANT all necessary permissions to that tabe space (as sysdba)
Then create few tables in that table space
Then login that user and access tables.

Oracle has so million no. of tutorials but none of those are really useful for the beginners.


Edited by: user8828023 on Jan 29, 2011 4:08 PM

Edited by: user8828023 on Jan 29, 2011 4:10 PM

Edited by: user8828023 on Jan 29, 2011 6:10 PM
Philippe Florent
Hi,
Oracle Database is a good product even if the first approach can seem a bit frustrating. In this case I think you just miss the information though : the default users are specified in some screen at install time.
I suggest you try :
sqlplus system/password_you_chose 
or
sqlplus "/ as sysdba"
Best regards
Phil
Jerry Ireland
I have a similar problem. I just installed 11gr2.02. I am able to log in to sys through sqlplus with the password I created during install, but when I try to log in to Enterprise Manager with the same user password it gives me an authentication error. I specified "as sysdba" in both cases.
836896
Hi,
same problem,
no answer?
Georg
837048
I had the same problem; the installer prompts you for a password but gives no indication as to what username to use when logging into Enterprise Manager for the first time. Seems like a major oversight, doesn't it? Anyway, I stumbled upon the answer just a few minutes ago. Not sure why this has proved so difficult to succinctly answer in this thread until now, but here is what worked for me:

User Name: SYS
Password: <the password you entered during the installation process>
Connect As: SYSDBA

Hope this helps. This is one of many items I've come across lately (as I try to learn Oracle 11g and OBIEE) that, IMO, is much more difficult than it needs to be.

Chris
856500
Thank you so much Chris, I found this information very helpful and was able to access Enterprise Manager for Oracle 11g, however I am still unable to access SQL Plus, I have tried all the suggestions in the thread and no luck so far. I am prompted to enter a username and password and the password I entered during setup has not work however it did work to access Enterprise Manager.

Thanks for your help.

TechyM
EdStevens
853497 wrote:
Thank you so much Chris, I found this information very helpful and was able to access Enterprise Manager for Oracle 11g, however I am still unable to access SQL Plus, I have tried all the suggestions in the thread and no luck so far. I am prompted to enter a username and password and the password I entered during setup has not work however it did work to access Enterprise Manager.

Thanks for your help.

TechyM
It is surprisingly difficult to debug that which cannot be seen. Please open a command prompt and attempt to connect with sqlplus. Then use the handy "copy" capability to copy the entire session and paste that into your next post here.
861312
The simple answer to your question is:

SYSMAN

the password would be what you specified during installation.

I hope this helps
Sam
876041
I faced the problem .. i was able to logib as scott/tiger@orcl1 .. , remember " ORCL1" is the name that i and anyone could mistakenly give in net configuratuin assistant . my actual SID name is "ORCL" .

but i could not login as sys or system.

it coccured to me that it is sytem authentication problem though i am logged in as "Administrator' in my laptop.
i checked user accounts .. i m being notified as "administrator' .
then i rember that when installing oracle .. one option came to me " changing password" for accounts of diff users ..
i remember doing some changes in that but it was all uniform i.e. the password i m using to logon as "scott".
it baffelled me why i am able to login as "scott/password@orcl1' but not as "sys"/'system'.

then i tried the following ..
create a new admin account in windows as "sas" for the computer.
switich user ..login as "sas' with admin privilrge .
start oracle services .. i.e . "listener" and "ORCL" SID. go to admin services in windows . strt both these services .
login as system/"(password which u gave during installation")@connect string ( in my case it is ORCL1.
logged in successfully.
try to connect as sys as sysdba with the same "Password" and "connect string ' . it will give error .
again reconnect as system user.
alter user SYS modify password *****
try to connect as sys with the new password .. and connect string.
get connected ...
quit SQL .
quit windows as the new user .
login as old user i.e. "ADMIn " or what ever user u were during installation .
start the oracle services i.e. listener and SID .
login as scott/password@Orcl1
then login as sys/password@orcl1 ..
success.

Moral of the story .. " It is accidental or some discrepancy " between authentication synchronization between "Windows OS" and Oracle 'Software' .. accidentally some parametrs or orcle files/windows files get changed .
still if u have the windows admin facility without going through hell i.e. " changing password files , reading thousands of responses and trying them " , de installing and re installing oracle .. try this .. it should work most of the times .. if u have valid windows admin "privilege" when installing Oracle.
sb92075
873038 wrote:
I faced the problem .. i was able to logib as scott/tiger@orcl1 .. , remember " ORCL1" is the name that i and anyone could mistakenly give in net configuratuin assistant . my actual SID name is "ORCL" .

but i could not login as sys or system.

it coccured to me that it is sytem authentication problem though i am logged in as "Administrator' in my laptop.
i checked user accounts .. i m being notified as "administrator' .
then i rember that when installing oracle .. one option came to me " changing password" for accounts of diff users ..
i remember doing some changes in that but it was all uniform i.e. the password i m using to logon as "scott".
it baffelled me why i am able to login as "scott/password@orcl1' but not as "sys"/'system'.

then i tried the following ..
create a new admin account in windows as "sas" for the computer.
switich user ..login as "sas' with admin privilrge .
start oracle services .. i.e . "listener" and "ORCL" SID. go to admin services in windows . strt both these services .
login as system/"(password which u gave during installation")@connect string ( in my case it is ORCL1.
logged in successfully.
try to connect as sys as sysdba with the same "Password" and "connect string ' . it will give error .
again reconnect as system user.
alter user SYS modify password *****
try to connect as sys with the new password .. and connect string.
get connected ...
quit SQL .
quit windows as the new user .
login as old user i.e. "ADMIn " or what ever user u were during installation .
start the oracle services i.e. listener and SID .
login as scott/password@Orcl1
then login as sys/password@orcl1 ..
success.

Moral of the story .. " It is accidental or some discrepancy " between authentication synchronization between "Windows OS" and Oracle 'Software' .. accidentally some parametrs or orcle files/windows files get changed .
still if u have the windows admin facility without going through hell i.e. " changing password files , reading thousands of responses and trying them " , de installing and re installing oracle .. try this .. it should work most of the times .. if u have valid windows admin "privilege" when installing Oracle.
{quote:title=873038 wrote:}{quote}
I faced the problem .. i was able to logib as scott/tiger@orcl1 .. , remember " ORCL1" is the name that i and anyone could mistakenly give in net configuratuin assistant . my actual SID name is "ORCL" .

but i could not login as sys or system.

it coccured to me that it is sytem authentication problem though i am logged in as "Administrator' in my laptop.
i checked user accounts .. i m being notified as "administrator' .
then i rember that when installing oracle .. one option came to me " changing password" for accounts of diff users ..
i remember doing some changes in that but it was all uniform i.e. the password i m using to logon as "scott".
it baffelled me why i am able to login as "scott/password@orcl1' but not as "sys"/'system'.

then i tried the following ..
create a new admin account in windows as "sas" for the computer.
switich user ..login as "sas' with admin privilrge .
start oracle services .. i.e . "listener" and "ORCL" SID. go to admin services in windows . strt both these services .
login as system/"(password which u gave during installation")@connect string ( in my case it is ORCL1.
logged in successfully.
try to connect as sys as sysdba with the same "Password" and "connect string ' . it will give error .
again reconnect as system user.
alter user SYS modify password *****
try to connect as sys with the new password .. and connect string.
get connected ...
quit SQL .
quit windows as the new user .
login as old user i.e. "ADMIn " or what ever user u were during installation .
start the oracle services i.e. listener and SID .
login as scott/password@Orcl1
then login as sys/password@orcl1 ..
success.

Moral of the story .. " It is accidental or some discrepancy " between authentication synchronization between "Windows OS" and Oracle 'Software' .. accidentally some parametrs or orcle files/windows files get changed .
still if u have the windows admin facility without going through hell i.e. " changing password files , reading thousands of responses and trying them " , de installing and re installing oracle .. try this .. it should work most of the times .. if u have valid windows admin "privilege" when installing Oracle.
below works for me when logged onto OS as user "oracle"
sqlplus
/ as sysdba
876857
Had the exact same problem, thanks for the instructions Chris, using the SYS as caps worked.
RizwanWangde
user6100733 wrote:
I used the install executable for Oracle 11g, at one point it asked me for a default password to use, I typed one in, had to type it in twice (two different boxes, one for the password, one for verification)
I just tried your sqlplus suggestion it says I have insufficient privileges.
I just simply downloaded the installer and ran it, went through the prompts and left everything at its default.
Unfortunately now, I can't use admin or sysdba for login user with the password I used and the manuel doesn't state that there is another password that the system has by default.
Thanks for the continued help with this, it is greatly appreciated.
Hi,

As you are on windows, to use "/ as sysdba" while logging in, your OS user needs to be a member of the ora_dba group.

1. Right Click on My Computer -> Manage
2. Local Users and Groups --> Groups

Here you will see ora_dba group. Double Click on it, add your user in it.

You should be able to login using *"/ as sysdba"*.

Also, I noticed something. The password entered during installation & after installation are case sensitive.

I entered Oracle$123 while installation, but tried logging in by entering "oracle$123" -- gave me wrong password error.

Hope this helps ! if it does, please click on helpful or answered appropriately.

Regards,
Rizwan
1 - 25

Post Details

Added on Apr 21 2022
6 comments
157 views