Compiere ERP + CRM Business Solution / Support Requests / #51 RUN_Env.bat invalid user name for sys
Error: CSS did not load.
This may happen on the first request due to CSS mimetype issues.
Try clearing your browser cache and refreshing.
#51 RUN_Env.bat invalid user name for sys
Milestone:
Fresh install:
-Windows 2000 Server Service Pack 2
-Compiere 2.4.0 with update
-Oracle 9i using &Database Configuration Assistant&
and Compiere-240.dfj limited edition
-Computer Name / Host Name: compiere
-Database Name: compiere
-DNS: compiere.org
When I run RUM_Env.bat, pressing enter at each error
(no values entered at the request for login, just to
skip to the next statement), I reveice the following
General ...
= D:\Compiere2\D:\Compiere2
\jre\D:\oracle\ora90\C:\Program
Files\Oracle\jre\1.1.8
\C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem
= D:\Compiere2\lib\CClient.D:\Compiere2
\lib\CTools.jar
COMPIERE_HOME
= D:\Compiere2
CATALINA_HOME
= D:\Compiere2\tomcat
= D:\Compiere2\jre
COMPIERE_DB_HOME
= D:\oracle\ora90
Database ...
COMPIERE_DB_TNS
= piere.org
COMPIERE_DB_SYS
= change_on_install
COMPIERE_DB_SYSTEM
COMPIERE_DB_USER
= compiere
COMPIERE_DB_PASSWORD = compiere
Compiere Settings ...
COMPIERE_SERVER
COMPIERE_PRODUCT
COMPIERE_LICENSE
Database Connection Test ... Sys
D:\Compiere2
\utils&sqlplus &sys/change_on_pier
e.org AS SYSDB
A& @Test.sql
SQL*Plus: Release 9.0.1.0.1 - Production on Sat Jan
26 23:46:13 2002
(c) Copyright 2001 Oracle Corporation.
All rights
ORA-01017: invalid username/ logon denied
Enter user-name:
ORA-01017: invalid username/ logon denied
Enter user-name:
ORA-01017: invalid username/ logon denied
SP2-0157: unable to CONNECT to ORACLE after 3
attempts, exiting SQL*Plus
Database Connection Test ... System
D:\Compiere2\utils&sqlplus
system/piere.org @Test.sql
SQL*Plus: Release 9.0.1.0.1 - Production on Sat Jan
26 23:51:17 2002
(c) Copyright 2001 Oracle Corporation.
All rights
ORA-12154: TNS:could not resolve service name
Enter user-name:
ORA-01017: invalid username/ logon denied
Enter user-name:
ORA-01017: invalid username/ logon denied
SP2-0157: unable to CONNECT to ORACLE after 3
attempts, exiting SQL*Plus
Database Connection Test ... Compiere
D:\Compiere2\utils&sqlplus
compiere/piere.org @Test.sql
SQL*Plus: Release 9.0.1.0.1 - Production on Sat Jan
26 23:51:22 2002
(c) Copyright 2001 Oracle Corporation.
All rights
ORA-12154: TNS:could not resolve service name
Enter user-name:
ORA-03113: end-of-file on communication channel
Enter user-name:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3
attempts, exiting SQL*Plus
Java Test ...
D:\Compiere2\utils&D:\Compiere2\jre\bin\java -version
java version &1.4.0-beta3&
Java(TM) 2 Runtime Environment, Standard Edition
(build 1.4.0-beta3-b84)
Java HotSpot(TM) Client VM (build 1.4.0-beta3-b84,
mixed mode)
Press any key to continue . . .
Discussion
Logged In: YES
user_id=87038
You probably have the tns name wrong (COMPIERE_DB_TNS =
piere.org).
Please check your file
tndnames.ora for the correct TNS name.
You can check the name via
& tnsping mytnsname
& tnsping %COMPIERE_DB_TNS%
& tnsping &
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=87038
*** Status set to PENDING ** If issue solved, please CLOSE this
request - otherwise set the status back to OPEN.
If there is no
reaction within a week, we assume it works and we will CLOSE it.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
status: open --& pending
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=61368
ok, so I piere.org to my localhost file
and the ping and tnsping work.
But now I get a database not found error on the Compiere
Login (Screen Shot attached).
-Test Application server works also
-Test Database connection works also (See output below)
-RUN_Env works also, except for compiere/compiere user
locked, it seems that oracle locks this user by default at
the installation since it is part of the admin group.
only gets ulocked when you change it's password.
Three questions:
-What do I need to do to get past the database login
-What domain name a and hostname do you recommend to use
(when installing without a domain name just for a test
system) so that the standard installation procedure works?
-What should be done so that the compiere/compiere user
does not get locked during the install?
Add a password at
the end of the database creation step (not insicated on
the installation instructions)?
Database Test Output:
Using Java=Java HotSpot(TM) Client VM 1.4.0-beta3-b84
*** Testing connection to Server: compiere ***
Trying Echo - Port 7
IO Exception: java.net.ConnectException: Connection
refused: connect
Trying FTP - Port 21
IO Exception: java.net.ConnectException: Connection
refused: connect
Trying HTTP - Port 80
*** success ***
Trying Kerberos - Port 88
IO Exception: java.net.ConnectException: Connection
refused: connect
Trying NetBios Session - Port 139
*** success ***
Trying RMI - Port 1099
*** success ***
Trying Oracle Connection Manager - Port 1630
IO Exception: java.net.ConnectException: Connection
refused: connect
Trying Oracle JDBC - TCP Port 1521
*** success ***
*** Server found: compiere ***
Connect to SID: compiere
Connect with entered parameters
Registering Driver: oracle.jdbc.driver.OracleDriver
- driver registered
- driver initialized
Trying Client connection
URL=jdbc:oracle:thin:@compiere:1521:compiere, User=compiere
ERROR: ORA-28000: the account is locked
Trying Server connection URL=jdbc:oracle:oci8:@,
User=compiere
ERROR: ORA-28000: the account is locked
Connect with user system/manager
Registering Driver: oracle.jdbc.driver.OracleDriver
- driver registered
- driver initialized
Trying Client connection
URL=jdbc:oracle:thin:@compiere:1521:compiere, User=system
- connected
- Driver Name: Oracle JDBC driver
- Driver Version:
- DB Name: Oracle
- DB Version:
Oracle9i Enterprise Edition Release
9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
*** success ***
Trying Server connection URL=jdbc:oracle:oci8:@,
User=system
- connected
- Driver Name: Oracle JDBC driver
- Driver Version:
- DB Name: Oracle
- DB Version:
Oracle9i Enterprise Edition Release
9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
*** success ***
Please check COMPIERE user id and password
.... and please change SYSTEM password
RUN_Env.bat Output:
General ...
= D:\Compiere2\D:\Compiere2
\jre\D:\oracle\ora90\C:\Program
Files\Oracle\jre\1.1.8
\C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem
= D:\Compiere2\lib\CClient.D:\Compiere2
\lib\CTools.jar
COMPIERE_HOME
= D:\Compiere2
CATALINA_HOME
= D:\Compiere2\tomcat
= D:\Compiere2\jre
COMPIERE_DB_HOME
= D:\oracle\ora90
Database ...
COMPIERE_DB_TNS
= piere.org
COMPIERE_DB_SYS
= change_on_install
COMPIERE_DB_SYSTEM
COMPIERE_DB_USER
= compiere
COMPIERE_DB_PASSWORD = compiere
Compiere Settings ...
COMPIERE_SERVER
COMPIERE_PRODUCT
COMPIERE_LICENSE
Database Connection Test ... Sys
D:\Compiere2
\utils&sqlplus &sys/change_on_piere.org
A& @Test.sql
SQL*Plus: Release 9.0.1.0.1 - Production on Sun Jan 27
18:46:31 2002
(c) Copyright 2001 Oracle Corporation.
All rights
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
CONNECTION
-----------
Disconnected from Oracle9i Enterprise Edition Release
9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
Database Connection Test ... System
D:\Compiere2\utils&sqlplus
system/piere.org @Test.sql
SQL*Plus: Release 9.0.1.0.1 - Production on Sun Jan 27
18:46:35 2002
(c) Copyright 2001 Oracle Corporation.
All rights
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
CONNECTION
-----------
Disconnected from Oracle9i Enterprise Edition Release
9.0.1.1.1 - Production
JServer Release 9.0.1.1.1 - Production
Database Connection Test ... Compiere
D:\Compiere2\utils&sqlplus
compiere/piere.org @Test.sql
SQL*Plus: Release 9.0.1.0.1 - Production on Sun Jan 27
18:46:38 2002
(c) Copyright 2001 Oracle Corporation.
All rights
ORA-28000: the account is locked
Enter user-name:
ORA-01017: invalid username/ logon denied
Enter user-name:
ORA-01017: invalid username/ logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts,
exiting SQL*Plus
Java Test ...
D:\Compiere2\utils&D:\Compiere2\jre\bin\java -version
java version &1.4.0-beta3&
Java(TM) 2 Runtime Environment, Standard Edition (build
1.4.0-beta3-b84)
Java HotSpot(TM) Client VM (build 1.4.0-beta3-b84, mixed
Press any key to continue . . .&
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
status: pending --& open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=61368
For those who might have the same problem, unlocking the
compiere user can be done with SQL Plus (Start -&
Programs -& Oracle - OraHome90 -& Application Development
& SQL Plus) and login in with system/manager and using the
command &alter user compiere account unlock&.
password still needs to be reset, it can be done at the
same time as running RUN_env.bat, it will ask you for a
new password after compiere has been unlocked.
Is this a normal part of the installation procedure, or
did I miss a step?&
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
status: open --& closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:58cv网址导航