Link to home
Start Free TrialLog in
Avatar of fosiul01
fosiul01Flag for United Kingdom of Great Britain and Northern Ireland

asked on

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

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

Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Which install option did you select from ./runInstaller.sh?

Can you post the results?
Avatar of fosiul01

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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.
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 ??
>>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
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


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 ...


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
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
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 ??
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.
i was able to install 11G xe with a very simple password ....