Solved

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

Posted on 2011-09-06
14
2,218 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
  • 8
  • 6
14 Comments
 
LVL 76

Expert Comment

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

Can you post the results?
0
 
LVL 29

Author Comment

by:fosiul01
Comment Utility
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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
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
 
LVL 29

Author Comment

by:fosiul01
Comment Utility
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
Comment Utility
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 29

Author Comment

by:fosiul01
Comment Utility
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
Comment Utility
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
Comment Utility
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
Comment Utility
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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
Comment Utility
i was able to install 11G xe with a very simple password ....

0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

762 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now