1 2 Previous Next 18 Replies Latest reply: Jul 14, 2011 3:18 AM by krzyhu Go to original post RSS
      • 15. Re: Unable to connect to db - ORA-12514 Error
        fa77
        orafad wrote:
        Please post commands and output of the following:

        path
        PATH=D:\Oracle\db11gr2xeb\app\oracle\product\11.2.0\server\bin;D:\Oracle\Db11gR2\product\11.2.0\dbhome\bin;D:\Program Files\PHP\;C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\WINDOWS\system32\WindowsPowerShell\v1.0
        hostname
        Oracle
        set computername
        Oracle.ORA.COM
        set logonserver
        Microsoft Windows Server 2003 R2 Enterprice Edition SP2
        set programfiles(x86)
        C:\Program Files (x86)
        nslookup oracle.ora.com
        C:\>nslookup oracle.ora.com
        Server: administration.ora.com
        Address: 192.19.220.250

        Name: oracle.ora.com
        Address: 192.19.220.148
        netstat -na | findstr :1521
        C:\>netstat -na | findstr :1521
        TCP 0.0.0.0:1521 0.0.0.0:0 LISTENING
        TCP 192.19.220.148:2800 192.19.220.149:1521 ESTABLISHED
        net start oracleservicexe
        C:\>net start oracleservicexe
        The requested service has already been started.

        More help is available by typing NET HELPMSG 2182.
        reg query hklm\software\oracle\key_xe /v ora_xe_autostart
        C:\>reg query hklm\software\oracle\key_xe /v ora_xe_autostart

        HKEY_LOCAL_MACHINE\software\oracle\key_xe
        ora_xe_autostart REG_SZ TRUE
        • 16. Re: Unable to connect to db - ORA-12514 Error
          orafad
          So far, I'd suspect hostname/network is messing with instance dynamic registration.
          SQL> show parameter local_list
          
          SQL> select instance_name, host_name, status, blocked from v$instance;
          According to "path" you have another Oracle Home, installed before XE beta. Are those shutdown, not to interfere?
          • 17. Re: Unable to connect to db - ORA-12514 Error
            fa77
            orafad wrote:
            So far, I'd suspect hostname/network is messing with instance dynamic registration.
            SQL> show parameter local_list
            SQL> select instance_name, host_name, status, blocked from v$instance;
            I'm not able to login to the database,I got the following error.
            >SQL> conn sys/oracle as sysdba
            >ERROR:
            >ORA-12638: Credential retrieval failed
            So, I changed sqlnet.ora as
            ># This file is actually generated by netca. But if customers choose to
            ># install "Software Only", this file wont exist and without the native
            ># authentication, they will not be able to connect to the database on NT.

            >#SQLNET.AUTHENTICATION_SERVICES = (NTS)
            >SQLNET.AUTHENTICATION_SERVICES= (NONE)

            >SQL> conn sys as sysdba
            >Enter password:
            >Connected to an idle instance.
            I cannot start up the database
            >SQL> startup
            >ORA-01078: failure in processing system parameters
            >ORA-01565: error in identifying file 'D:\Oracle\db11gr2xeb\app\oracle\product\11.2.0\server\dbs/spfileXE.ora'
            >ORA-27041: unable to open file
            >OSD-04002: unable to open file
            >O/S-Error: (OS 2) The system cannot find the file specified.
            According to "path" you have another Oracle Home, installed before XE beta. Are those shutdown, not to interfere?
            I already have a Oracle db 11g EE instance also,but its shutdown.But Oracle Database 11g Express Edition Beta Home is the default home.
            • 18. Re: Unable to connect to db - ORA-12514 Error
              krzyhu
              Hi,

              In case of missing spfileXE.ora:

              DEFINE sysPassword = "&your_password"
              connect "SYS"/"&&sysPassword" as SYSDBA
              create spfile='D:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora' FROM pfile='D:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora';
              shutdown immediate;
              connect "SYS"/"&&sysPassword" as SYSDBA
              startup ;
              1 2 Previous Next