fosiul01
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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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.
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.
ASKER
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 ??
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
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
ASKER
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
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
ASKER
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 ...
[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 ...
ASKER
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
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
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
ASKER
as you can see my previous post.. i have done that
alter system set SEC_CASE_SENSITIVE_LOGON=f alse scope=spfile;
but i have a felling it does not allow remote connection.. although 1521 is open and accepting
any idea ??
alter system set SEC_CASE_SENSITIVE_LOGON=f
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'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.
ASKER
i was able to install 11G xe with a very simple password ....
Can you post the results?