1 2 Previous Next 22 Replies Latest reply on Sep 2, 2013 7:07 PM by sybrand_b Go to original post
      • 15. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist
        UserAL1178M

        Can you try log in to OS with oracle user and execute sqlplus / as sysdba?

         

        What is the output?

        • 16. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist
          UserAL1178M

          Can you try log in to OS with oracle user and execute sqlplus / as sysdba?

           

          What is the output?

          • 17. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist
            saurabh

            you have not done as i said.

             

            1. conn apps/apps@prdot

             

            after connecting to the database as app user then use below cmd

             

            2. conn / as sysdba

             

            and then change the password of sys/system user from it.

             

            The above will work only if you have not restricted os authentication.

             

            But i think you  have disabled os authentication for your database, you can do is create a new password file for the database.

            • 18. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist

              That's not the correct syntax, isn't it?

              To use OS authentication the syntax is

               

              connect / as sysdba

               

              Please notice there is no @ sign.

               

              Also, whenever you state 'it doesn't work' *proof* you are connected as the os user oracle (using 'who am i') and are in the correct group, using the

              id command. Please do not just state 'it doesn't work', as this is not a chatroom, and we are not at your desk.

               

              -------------

              Sybrand Bakker

              Senior Oracle DBA

              • 19. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist
                902923

                Dear sybrand,

                 

                Apologies if i made confusion on this issue , let me try to make more clear on this issue,

                 

                I have os level root  user access and oracle user access, i can connect user as root and oracle also,

                 

                i tried the below steps,

                 

                login as root

                then sqlplus /@prdot as sysdba

                 

                getting insufficient privilege, 

                 

                now i tried without @  this time i'm getting ,

                 

                Sqlplus /nolog

                 

                sql> conn / as sysdba

                 

                ORA-12545: Connect failed because target host or object does not exist

                 

                and i tried the same with os level oracle user ,

                 

                login as oracle

                 

                sqlplus /@prdot as sysdba

                getting insufficient privilege,

                 

                tried without @

                 

                sql> conn / as sysdba

                 

                ORA-12545: Connect failed because target host or object does not exist

                 

                and also i tried with normal apps user first then conn as sysdba

                 

                like,

                 

                sqlplus apps/apps@prdot

                connected

                 

                SQL> conn / as sysdba

                ORA-12545: Connect failed because target host or object does not exist

                 

                SQL> conn /@prdot as sysdba

                insufficient privilege,

                 

                also remote login password also set exclusive in init.ora

                 

                Please clarify ,

                 

                1.can we login to the database with full os authendication user (oracle) or root if we lost sys and system password?

                2. Or is the only solution is recreating the pwd file? 

                 

                 

                Thanks.

                • 20. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist
                  EdStevens

                  saurabh wrote:

                   

                  simply what you can do is

                   

                  conn apps/apps@prdot

                   

                  and then

                   

                  conn / as sysdba

                   

                  and then change the password of sys/system user from it.

                   

                  The above will work only if you have not restricted os authentication.

                   

                  If you have disabled os authentication then, you can do is create a new password file for the database.

                  The second connection will only work if the os connection is on the same server as the database.

                  • 21. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist
                    EdStevens

                    902923 wrote:

                     

                    Dear sybrand,

                     

                    Apologies if i made confusion on this issue , let me try to make more clear on this issue,

                     

                    I have os level root  user access and oracle user access, i can connect user as root and oracle also,

                     

                    i tried the below steps,

                     

                    login as root

                    then sqlplus /@prdot as sysdba

                     

                    getting insufficient privilege,

                     

                    now i tried without @  this time i'm getting ,

                     

                    Sqlplus /nolog

                     

                    sql> conn / as sysdba

                     

                    ORA-12545: Connect failed because target host or object does not exist

                     

                    and i tried the same with os level oracle user ,

                     

                    login as oracle

                     

                    sqlplus /@prdot as sysdba

                    getting insufficient privilege,

                     

                    tried without @

                     

                    sql> conn / as sysdba

                     

                    ORA-12545: Connect failed because target host or object does not exist

                     

                    and also i tried with normal apps user first then conn as sysdba

                     

                    like,

                     

                    sqlplus apps/apps@prdot

                    connected

                     

                    SQL> conn / as sysdba

                    ORA-12545: Connect failed because target host or object does not exist

                     

                    SQL> conn /@prdot as sysdba

                    insufficient privilege,

                     

                    also remote login password also set exclusive in init.ora

                     

                    Please clarify ,

                     

                    1.can we login to the database with full os authendication user (oracle) or root if we lost sys and system password?

                    2. Or is the only solution is recreating the pwd file?

                     

                     

                    Thanks.

                    YOu should NEVER do anything with oracle as the root user (exception, some installation scripts have steps that explicit y state to be run by root).  So quit even trying to do that.  It has no bearing at all on your problem.

                     

                     

                    sql> conn / as sysdba

                     

                    ORA-12545: Connect failed because target host or object does not exist

                     

                    That's a very strange error for a local connection, as there should be no network routing in the first place.

                    Do you happen to have TWO_TASK set?

                    oracle:orcl$ cd $ORACLE_HOME/netwrokwork/admin
                    
                    
                    oracle:orcl$ cat tnsnames.ora
                    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
                    # Generated by Oracle configuration tools.
                    
                    FUBAR =
                      (DESCRIPTION =
                        (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = fubar)(PORT = 1521))
                        )
                        (CONNECT_DATA =
                          (SERVICE_NAME = fubar)
                        )
                      )
                    
                    
                    
                    oracle:orcl$ echo $TWO_TASK
                    
                    
                    
                    oracle:orcl$ sqlplus / as sysdba
                    
                    SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 2 11:58:46 2013
                    
                    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
                    
                    
                    Connected to:
                    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options
                    
                    SQL> exit
                    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options
                    
                    
                    
                    oracle:orcl$ export TWO_TASK=FUBAR
                    sqlplus / as sysdba
                    
                    
                    SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 2 11:59:52 2013
                    
                    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
                    
                    ERROR:
                    ORA-12545: Connect failed because target host or object does not exist
                    
                    
                    • 22. Re: connect as sys:  ORA-12545: Connect failed because target host or object does not exist

                      Great.

                       

                      I asked you 2 *specific* questions.

                      You didn't answer them.

                      So, as both of your new questions are *doc* questions, I will leave it to you to look up the documentation.

                      Problem is between keyboard and chair:

                      You don't read documentation, you don't answer questions and you are here only to play games with professionals.

                       

                      ------------

                      Sybrand Bakker

                      Senior Oracle DBA

                      1 2 Previous Next