?
Solved

ORA-01017: invalid username/password; logon denied ( Very urgent)

Posted on 2011-09-06
14
Medium Priority
?
2,556 Views
Last Modified: 2012-05-12
hello
i am trying to install Oracle vm manager 3.0.1 from last 2 days.. and i am stuck with same problem ...

I have created a question on oracle from , but no luck yet

here is my story :
http://download.oracle.com/docs/cd/E20065_01/doc.30/e18548/toc.htm

its suppose to be really easy installation!!
just run

createOracle.sh
runInstaller.sh

it should do everytihng with a easy password ...
but every time its give me error :

ORA-01017: invalid username/password; logon denied

09-06 14:15 ovm.installer.database ERROR Failed to find Oracle VM schema in Oracle Database

ORA-01017: invalid username/password; logon denied



dont really understand what is the issue
my understanding is environment variable is not set .. hence its issue

but i really want a help from oracle expert to see if you can help me ...

i really need to finish this project its very urgent ..


note : i read almost all link in google for those problem... that did not help me too much , i realy need some one who can spot the problem

thanks

0
Comment
Question by:fosiul01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36491175
Which install option did you select from ./runInstaller.sh?

Can you post the results?
0
 
LVL 29

Author Comment

by:fosiul01
ID: 36491206
according to document and oracle forum .. for testing purpose  i should select 1

however i chose 1 and 2

simple and standard

with simple (1) , it just ask for one password
and its should try to configure everything with that one password


with Standard (2) i can provide different password for different account

i use both but same result
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 36491267
Let's stick with 'Simple' for now.

Did the password you selected meet the requirements talked about in the doc link you provided:  Password requirements are outlined in Section 3.3.2.6, "Installation Ports and Passwords".

http://download.oracle.com/docs/cd/E20065_01/doc.30/e18548/manager.htm#CHDIADGC
0
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 
LVL 29

Author Comment

by:fosiul01
ID: 36491302
yes. i am using simpliest passoword not hard one like symboll..

password is like


Utcluw1yb

so this is not the issue..

some I saw. that oraclel Xe .. is case sensitive .. dont know if that cause the issue
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36491357
Oracle 11g databases are case sensitive not just XE.

11g XE was just released and is likely to have a few bugs/quirks.

Are you seeing any of the output after entering the password or do you receive the invalid username/password immediately and the setup stops?

For grins try entering the password inside double quotes to see if that fixes it:

Enter a password for all logins used during the installation: "Utcluw1yb"

If that doesn't work, you might try installing/creating XE independently of VM Manager and try using the pre-existing database option.

Try 11g XE first (you can configure it to ignore password 'case' as a test).'If it still will not install, try 10g XE.
0
 
LVL 29

Author Comment

by:fosiul01
ID: 36491542
ok so you saying

install oracle Xe in this server first. then change the case sensivity then try again ??

that could be an option..

if you read this

http://download.oracle.com/docs/cd/E20065_01/doc.30/e18548/manager.htm#CCHBJHEH

whats the

Enter the Oracle Database System ID (SID) [XE]: mySID


from where you get XE ??
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36491581
>>install oracle Xe in this server first. then change the case sensivity then try again ??

Yes.  11g first.  If it still fails, try the 10g XE version to help narrow down the 'bug'.

>>from where you get XE ??
 
http://www.oracle.com/technetwork/indexes/downloads/index.html?ssSourceSiteId=ocomen
0
 
LVL 29

Author Comment

by:fosiul01
ID: 36491663
about XE , what i meant was

what shall i type in Oracle DAtabase system id ???



just one more question...


although sh runinstall.sh failed
but its installed the oracle databse..

i can connect to oracle database by using


sqlplus / as sysdba ------------ this works

 but when i try to connect

$ sqlplus SYSTEM/"password"

SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 6 21:39:37 2011

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

ERROR:
ORA-01017: invalid username/password; logon denied

but look at bellow output

SQL> SELECT username, password_versions FROM dba_users;

USERNAME                       PASSWORD
------------------------------ --------
SYS                            10G 11G
SYSTEM                         10G 11G
ANONYMOUS
APEX_PUBLIC_USER               10G 11G
APEX_040000                    10G 11G
XS$NULL                        10G 11G
OUTLN                          10G 11G
FLOWS_FILES                    10G 11G
MDSYS                          10G 11G
CTXSYS                         10G 11G
XDB                            10G 11G

USERNAME                       PASSWORD
------------------------------ --------
HR                             10G 11G

12 rows selected.



although i have changed that one

SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE


still its same error ..

do i need to restart anything after set it to flase ??


thanks for your help and patience


0
 
LVL 29

Author Comment

by:fosiul01
ID: 36491881
ok i think i have fixed issue of case sensitive problem

[oracle@ovm ~]$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 6 22:09:20 2011

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

Enter user-name: SYSTEM
Enter password:

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>


So it does work


but now when i am installing ORacle vm manager by using options 2

then Select Remote databses


then its failed by using the same problem


Please select an installation type:
   1: Simple
   2: Standard
   3: Uninstall
   4: Help

   Select Number (1-4): 2

Starting standard installation ...


Verifying installation prerequisites ...

Oracle Database Repository
==========================
Would you like to install Oracle Database 11g Express Edition (XE) or connect to an existing Oracle database?
   1: Install Oracle Database 11g XE
   2: Use an existing Oracle database

   Select Number (1-2): 2

Enter the Oracle Database hostname [localhost]:
Enter the Oracle Database System ID (SID) [XE]:
Enter the Oracle Database SYSTEM password:

Enter the Oracle Database listener port [1521]:
Enter the Oracle VM Manager database schema [ovs]:
Enter the Oracle VM Manager database schema password:

Enter the Oracle VM Manager database schema password (confirm):


Oracle Weblogic Server 11g
==========================
Enter the Oracle WebLogic Server 11g user [weblogic]:
Enter the Oracle WebLogic Server 11g user password:

Enter the Oracle WebLogic Server 11g user password (confirm):


Oracle VM Manager application
=============================
Enter the username for the Oracle VM Manager administration user [admin]:
Enter the admin user password:

Enter the admin user password (confirm):


Verifying configuration ...
The database could not be reached using the provided connection info.
            ORA-01017: invalid username/password; logon denied

Configuration verification failed ...


0
 
LVL 29

Author Comment

by:fosiul01
ID: 36491909
now i can connect from mozilla firefox ....

just have to fixed the upper issue..

please give me some idea if you can
gui-oracle.GIF
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36492060
If double quotes doesn't work for the passwords and since this is for testing, using sqlplus connect as sysdba:

sqlplus / as sysdba

On mobile and cannot remember the exact parameter so issue: show parameter case

The whatever it is ( it should jump out at you):
Alter system set <parameter_name>=false scope=spfile;

Then:
Shutdown
Startup
0
 
LVL 29

Author Comment

by:fosiul01
ID: 36492150
as you can see my previous post.. i have done that

alter system set SEC_CASE_SENSITIVE_LOGON=false scope=spfile;

but i have a felling it does not allow remote connection.. although 1521 is open and accepting


any idea ??
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36492192
Sorry.  On mobile now and missed that on the tiny screen.

I'm out of ideas on 11g XE.  I would probably uninstall 11g XE and install 10g XE to see if the issue exists.

Remember 11g XE is very new.
0
 
LVL 29

Author Comment

by:fosiul01
ID: 36557307
i was able to install 11G xe with a very simple password ....

0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses
Course of the Month12 days, 20 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question