ERR:ORA-01017:invalid usrnam/pwd;logon denied

2009-03-05
2013-05-02
  • I'm installing compiere in my fedora 9 machine. I'm very new to compiere. I'm using oracle XE as database and jboss as server. While installing first time it gives the followinf error,

    13:21:18.001   KeyStoreMgt.getCertificate: Alias=compiere [11]
    13:21:18.022 ConfigurationData.testCompiere: OK: KeyStore = /Compiere2/keystore/myKeystore [11]
    13:21:18.022 ConfigJBoss.test: OK: AppsServer = tcs.3d6/127.0.0.1 [11]
    13:21:18.024 ConfigJBoss.test: OK: Deploy Directory = /Compiere2/jboss/server/compiere/deploy [11]
    13:21:18.045 ConfigJBoss.test: OK: JNPPort = 1099 [11]
    13:21:18.085 ConfigJBoss.test: OK: Web Port = 80 [11]
    13:21:18.274 ConfigJBoss.test: OK: SSL Port = 443 [11]
    13:21:18.275 ConfigOracle.test: OK: Database Server = tcs.3d6/127.0.0.1 [11]
    13:21:18.277 ConfigOracle.test: OK: Database Port = 1521 [11]
    13:21:19.276 ConfigOracle.test: OK: Connection = jdbc:oracle:thin:@//tcs.3d6:1521/xe [11]
    13:21:19.277 ConfigOracle.test: OK: Database System User xe [11]
    -----------> ConfigOracle.testJDBC: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
    [11]
    -----------> ConfigOracle.test: Cannot connect to User: compiere/compiere - Database may not be imported yet (OK on initial run). [11]
    13:21:19.358 ConfigOracle.test: OCI Test Skipped [11]
    13:21:19.409   ConfigurationData.testMailServer: OK: SMTP Server contacted [11]
    -----------> ConfigurationData.testPort: Open Socket tcs.3d6/127.0.0.1:110 - Connection refused [11]
    13:21:19.416 ConfigurationData.testMailServer: POP3 Server NOT available [11]
    -----------> ConfigurationData.testPort: Open Socket tcs.3d6/127.0.0.1:143 - Connection refused [11]
    13:21:19.418 ConfigurationData.testMailServer: IMAP4 Server NOT available [11]
    ===========> EMailAuthenticator.<init>: Password is NULL [11]
    13:21:19.493 EMail.send: (tcs.3d6) info@tcs.3d6 -> [info@tcs.3d6] [11]
    -----------> EMail.send: (ME) - Invalid Username/Password - EMailAuthenticator[info/************] [11]
    -----------> ConfigurationData.testMailServer: Could NOT send Email to info@tcs.3d6 [11]
    -----------> ConfigurationData.testMail: Not verified EMail = info@tcs.3d6 [11]

    I continued installation with out considering this error and at the second fresh installation try, i got this error

    17:21:29.687 ConfigurationData.load: Defaults
    17:21:51.528 ConfigVMSun.test: OK: JavaHome=/opt/jdk1.6.0_12 [11]
    17:21:51.529 ConfigVMSun.test: OK: Version=1.6.0_12 [11]
    17:21:51.529 ConfigurationData.testCompiere: OK: CompiereHome = /Compiere2 [11]
    17:21:51.541 KeyStoreMgt.<init>: /Compiere2/keystore/myKeystore [11]
    17:21:51.546   KeyStoreMgt.getCertificate: Alias=compiere [11]
    17:21:51.556 ConfigurationData.testCompiere: OK: KeyStore = /Compiere2/keystore/myKeystore [11]
    17:21:51.557 ConfigJBoss.test: OK: AppsServer = tcs.3d6/127.0.0.1 [11]
    17:21:51.559 ConfigJBoss.test: OK: Deploy Directory = /Compiere2/jboss/server/compiere/deploy [11]
    17:21:51.575 ConfigJBoss.test: OK: JNPPort = 1099 [11]
    17:21:51.596 ConfigJBoss.test: OK: Web Port = 80 [11]
    17:21:51.750 ConfigJBoss.test: OK: SSL Port = 443 [11]
    17:21:51.751 ConfigOracle.test: OK: Database Server = tcs.3d6/127.0.0.1 [11]
    17:21:51.753 ConfigOracle.test: OK: Database Port = 1521 [11]
    17:21:52.243 ConfigOracle.test: OK: Connection = jdbc:oracle:thin:@//tcs.3d6:1521/xe [11]
    17:21:52.243 ConfigOracle.test: OK: Database System User xe [11]
    17:21:52.290 ConfigOracle.test: OK: Database User = compiere [11]
    -----------> ConfigOracle.getWebStores: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

    and the following error comes at the end of creating database (build was successful)

    ......
    .....
    ......
    14:27:16.682 ProgressPanel.cmd: Create new Database [13]
    14:27:16.683 ProgressPanel.publish: ** Start(tcs.3d6 compiere) [23]
    14:27:16.962 ProgressPanel.cmd_import: jdbc:oracle:thin:@//tcs.3d6:1521/xe [23]
    14:27:16.975 ProgressPanel.publish: Creating Database [23]
    14:27:17.391 ProgressPanel.cmd_import:  [23]
    ===========> ProgressPanel.cmd_import: Internet connectivity error. Ensure that your server is hooked up to the internet [23]
    14:28:37.545 ProgressPanel.finished: Worker success=false [13]

    i expect the solution for the following three errors,

    1. -----------> ConfigOracle.testJDBC: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

    2. -----------> ConfigOracle.getWebStores: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

    3. ===========> ProgressPanel.cmd_import: Internet connectivity error. Ensure that your server is hooked up to the internet [23]

    Its really very urgent to me, if someone helps me, i'll very thankful....