1 2 Previous Next 15 Replies Latest reply: Feb 11, 2011 2:20 PM by EdStevens RSS

    oracle 10g ora 12560 and ora 12514 errors

    448896
      i am a new oracle user. and i have some problems

      i installed 10g then,
      when i was creating a database,
      i received an error messagge "ora-12560",
      therefore i cancelled creating database.

      i run sqlplus, i received error messagge again
      but this messagge differ from first one. it is "ora-12514"

      and i tested net manager my oranokta in tnsnames,
      same problem is continuesly

      and last thing i have a toshiba notebook with intel centrino 1.6
      and windows xp with sp2.

      i attached below my tnsnames, listener and sqlnet.ora files.



      --------------------------------
      listener.ora

      # listener.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.1.0\db_1)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = muttim)(PORT = 1521))
      )
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      )
      )


      -----------------------------------
      sqlnet.ora

      # sqlnet.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
      # Generated by Oracle configuration tools.

      SQLNET.AUTHENTICATION_SERVICES= (NTS)

      NAMES.DIRECTORY_PATH= (TNSNAMES)


      ------------------------------------
      tnsnames.ora

      # tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      ORA10 =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = muttim)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = Ora10)
      )
      )

      ORANOKTA =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = muttim)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OraNokta)
      )
      )

      thank you for help
        • 1. Re: oracle 10g ora 12560 and ora 12514 errors
          252355
          First thing you have to create database successfully.
          second by typing following you can check tnsnames.

          tnsping ora10

          tnsping oranokta


          it should reply from the db server not then you have given wrong host name and port no.

          You have to create database from database configuration assistant ..
          • 2. Re: oracle 10g ora 12560 and ora 12514 errors
            448896
            i tried tnsping ora10 and oranokta.
            i received a success messagge.
            but during creation the database,
            i received "ora-12560" error message many times.
            i pressed "ignore" button.
            and then created a database.



            can i ask a question?
            when i create a database,
            how will i connect it?
            (are there a program like enterprise manager in sql server 2000)
            • 3. Re: oracle 10g ora 12560 and ora 12514 errors
              448896
              i tried tnsping ora10 and oranokta.
              i received a success messagge.
              but during creation the database,
              i received "ora-12560" error message many times.
              i pressed "ignore" button.
              and then created a database.



              can i ask a question?
              when i create a database,
              how will i connect it?
              (are there a program like enterprise manager in sql server 2000)
              • 4. Re: oracle 10g ora 12560 and ora 12514 errors
                252355
                Please do one thing...
                I assumed you are working on windows environment..
                From Start Manu
                click Program Manu
                click Oracle - OraHome92
                click Configuration and Migration tools
                click Database Configuration Assistant..
                it will prompts you for database name, etc... so it will create automatically..

                If you are doing above way then you should not worry about to connection Oracle does this thing without connection.

                If you have database creation script then it's different steps of action.

                JP
                ..
                • 5. Re: oracle 10g ora 12560 and ora 12514 errors
                  448896
                  hi jp
                  i tried that you said.
                  but i use oracle 10g, not 9i
                  it didn't work.
                  it is still same problem "ora-12560"


                  i attached my database configuration.


                  Common Options
                  Option Selected
                  Oracle JVM true
                  Oracle Intermedia true
                  Oracle Text true
                  Oracle XML DB true
                  Oracle OLAP true
                  Oracle Spatial true
                  Oracle Data Mining true
                  Oracle Ultra Search true
                  Oracle Label Security false
                  Sample Schemas false
                  Enterprise Manager Repository true

                  Initialization Parameters
                  Name Value
                  background_dump_dest {ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\bdump
                  compatible 10.1.0.2.0
                  control_files ("{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl", "{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control02.ctl", "{ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control03.ctl")
                  core_dump_dest {ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\cdump
                  db_block_size 8KB
                  db_cache_size 24MB
                  db_domain
                  db_file_multiblock_read_count 16
                  db_name OraNokta
                  db_recovery_file_dest {ORACLE_BASE}\flash_recovery_area
                  db_recovery_file_dest_size 2048MB
                  dispatchers (PROTOCOL=TCP) (SERVICE={SID}XDB)
                  java_pool_size 48MB
                  job_queue_processes 10
                  large_pool_size 8MB
                  log_archive_format ARC%S_%R.%T
                  nls_language TURKISH
                  nls_territory TURKEY
                  open_cursors 300
                  pga_aggregate_target 24MB
                  processes 150
                  remote_login_passwordfile EXCLUSIVE
                  shared_pool_size 80MB
                  sort_area_size 65536
                  undo_management AUTO
                  undo_tablespace UNDOTBS1
                  user_dump_dest {ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\udump

                  Character Sets
                  Name Value
                  Database Character Set TR8MSWIN1254
                  National Character Set AL16UTF16

                  Data Files
                  Name Tablespace Size(M)
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\SYSTEM01.DBF SYSTEM 440
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\UNDOTBS01.DBF UNDOTBS1 25
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\SYSAUX01.DBF SYSAUX 210
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\USERS01.DBF USERS 5
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\TEMP01.DBF TEMP 20

                  Control Files
                  Name
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control01.ctl
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control02.ctl
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\control03.ctl
                  {ORACLE_BASE}\oradata\{DB_UNIQUE_NAME}\

                  Redo Log Groups
                  Group Size(K)
                  1 10240
                  2 10240
                  3 10240
                  • 6. Re: oracle 10g ora 12560 and ora 12514 errors
                    252355
                    Whether 10g or 9i..
                    ORA-12560 or ORA-12514 are network adaptor error. Your PC or laptop doesnot able to get connection to the database server.

                    from the start manu click on run and type cmd so you will get dos prompt and on dos prompt do following.

                    ping muttim

                    if above command does not work then try to ping with IP address if this does not work then you can not able to create db. you should let this work..

                    This is network error .. your pc or laptop does not able to simply ping the db server.

                    Please try to ping and see what you are getting.
                    • 7. Re: oracle 10g ora 12560 and ora 12514 errors
                      448896
                      hi

                      i tried to ping and, everyting is okay.

                      it didn't still work.

                      this is error messagge

                      "Attempting to connect using userid: sys
                      The test did not succeed.

                      ORA-12514 TNS listener could not resolve
                      service_name in connect descriptor.

                      There may be an error in the fields entered,
                      or the server may not be ready for a connection. "
                      • 8. Re: oracle 10g ora 12560 and ora 12514 errors
                        19426
                        Your listener.ora does not conatain a static entry for your database. In fact, this is not necessary, because running databases register themselves with the listener. BUT you don't have a running database, so error ORA-12514 occurs.
                        The most likely reason for ORA-12560 during database creation on a Windows platform is, the corresponding Windows service couldn't be created and/or started. Services panel must show something like OracleService<SID> . DBCA creates logfiles, check these files for errors, location for these files is shown on DBCA screen.
                        • 9. Re: oracle 10g ora 12560 and ora 12514 errors
                          448896
                          hi oradba

                          i opened
                          start=>run=>services.msc

                          i didn't find "oracleservice<sid>"

                          and
                          i found dbca logfiles,

                          i attached them
                          ---------------------------
                          cloneDBCreation.log

                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0641: "EXECUTE" sunucu ba&#287;lant&#305;s&#305; gerektirir
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;

                          --------------------
                          CloneRmanRestore.log

                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;

                          --------------------
                          lockAccount.log

                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il


                          --------------------
                          postDBCreation.log

                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0641: "EXECUTE" sunucu ba&#287;lant&#305;s&#305; gerektirir
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il


                          ------------------
                          postScripts.log

                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          dropping default lexer preference...
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          dropping default wordlist preference...
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          dropping default stoplist preference...
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          dropping default policy...
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          lang_abbr de&#287;erini girin: SP2-0310: "D:\oracle\product\10.1.0\db_1\ctx\admin\defaults\drdefset.sql" dosyas&#305; aç&#305;lam&#305;yor
                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0641: "EXECUTE" sunucu ba&#287;lant&#305;s&#305; gerektirir
                          SP2-0640: Ba&#287;l&#305; de&#287;il


                          --------------------------------
                          rmanRestoreDatafiles.sql

                          set echo off;
                          set serveroutput on;
                          select systimestamp from dual;
                          variable devicename varchar2(255);
                          declare
                          omfname varchar2(512) := NULL;
                          done boolean;
                          begin
                          dbms_output.put_line(' ');
                          dbms_output.put_line(' Allocating device.... ');
                          dbms_output.put_line(' Specifying datafiles... ');
                          :devicename := dbms_backup_restore.deviceAllocate;
                          dbms_output.put_line(' Specifing datafiles... ');
                          dbms_backup_restore.restoreSetDataFile;
                          dbms_backup_restore.restoreDataFileTo(4, 'D:\oracle\product\10.1.0\oradata\OraNoktaDB\USERS01.DBF', 0, 'USERS');
                          dbms_backup_restore.restoreDataFileTo(3, 'D:\oracle\product\10.1.0\oradata\OraNoktaDB\SYSAUX01.DBF', 0, 'SYSAUX');
                          dbms_backup_restore.restoreDataFileTo(2, 'D:\oracle\product\10.1.0\oradata\OraNoktaDB\UNDOTBS01.DBF', 0, 'UNDOTBS1');
                          dbms_backup_restore.restoreDataFileTo(1, 'D:\oracle\product\10.1.0\oradata\OraNoktaDB\SYSTEM01.DBF', 0, 'SYSTEM');
                          dbms_output.put_line(' Restoring ... ');
                          dbms_backup_restore.restoreBackupPiece('D:\oracle\product\10.1.0\db_1\assistants\dbca\templates\Seed_Database.dfb', done);
                          if done then
                          dbms_output.put_line(' Restore done.');
                          else
                          dbms_output.put_line(' ORA-XXXX: Restore failed ');
                          end if;
                          dbms_backup_restore.deviceDeallocate;
                          end;
                          /
                          select systimestamp from dual;

                          -------------------------------------
                          ultraSearchCfg.log

                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ==============     Ultra Search Configuration ==============


                          ============== argument list
                          WKSYSPW=XXXXXXXX
                          JDBC_CONNSTR=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=muttim)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OraNokta)))
                          LAUNCH_ANYWHERE=false
                          CONN_STRING=
                          OH=D:\oracle\product\10.1.0\db_1
                          JDBCDRIVER_PATH=D:\oracle\product\10.1.0\db_1\jdbc\lib\classes12.zip
                          JDBCNLS_PATH=D:\oracle\product\10.1.0\db_1\jdbc\lib\nls_charset12.zip
                          JRE_HOME=D:\oracle\product\10.1.0\db_1\jdk\jre\
                          JAVA_EXE_PATH=D:\oracle\product\10.1.0\db_1\jdk\bin\java.exe
                          PSEP=;
                          CTXHX=D:\oracle\product\10.1.0\db_1\bin\ctxhx.exe
                          ==================

                          ERROR:
                          ORA-12560: TNS: Protokol ba&#287;da&#351;t&#305;r&#305;c&#305;s&#305; hatas&#305;


                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ============== populating the WK$CRAWLER_CONFIG_DEFAULT table
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ============== load crawler classpath
                          ...... setting the crawler classpath
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ============== updating crawler configuration
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0641: "EXECUTE" sunucu ba&#287;lant&#305;s&#305; gerektirir
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating lexer preference
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating wordlist preference
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating storage preference
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating stoplist
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating section group
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating zone sections
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating field sections
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating filter preference
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ...... creating datastore preference
                          SP2-0640: Ba&#287;l&#305; de&#287;il

                          ... checking for invalid objects... see list below
                          ================== list start
                          SP2-0640: Ba&#287;l&#305; de&#287;il
                          ================== list end

                          ==============     End of Configuration ==============

                          --------------------------------------
                          note : my operating system's language is turkish.
                          • 10. Re: oracle 10g ora 12560 and ora 12514 errors
                            19426
                            It seems, you used the wrong tool, you didn't try to create a new database, but tried to clone a database using Recovery Manager (RMAN), because I see a logfiles named cloneDBCreation.log and cloneRMANRestore.log .
                            All these messages SP2-0640 und ORA-12560 are due to the fact, there's no Windows service, dbca had never run successfully.
                            You must run Database Configuration Assistant from the start menu or program dbca in a DOS box.
                            • 11. Re: oracle 10g ora 12560 and ora 12514 errors
                              449763
                              Hello masum,

                              The reason of this problem is our regional settings which is defined as Turkish. In another forum, I have found that this is a Java based bug. I have changed my locale from Turkish to English and installation has been done without problem. I recommend you to make same change and try it again.

                              You can find more information regarding this problem below:

                              http://bugs.sun.com/bugdatabase/view_bug.do;:YfiG?bug_id=4688797

                              Regards
                              Serdar Soydemir
                              • 12. Re: oracle 10g ora 12560 and ora 12514 errors
                                540353
                                Hi,
                                I am facing the same problem. Kindly tell me the steps to modify as English.

                                Rgds..
                                • 13. Re: oracle 10g ora 12560 and ora 12514 errors
                                  451321
                                  Go to control panel>regional settings and chenge the language in "regional options" tab to united states english and it works.
                                  • 14. Re: oracle 10g ora 12560 and ora 12514 errors
                                    838958
                                    Was this database(s) created using the assistant?
                                    1 2 Previous Next