12545 Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB oracle error 12545 Don Burleson Blog
oracle error 12545 encountered ORA-12545: Connect failed because target host or object does not exist tips Oracle Error Tips ora 12545 toad error by Burleson Consulting Question: I have Oracle 9i installed on my local Windows XP workstation that will be used for local development only. Now I am trying to ora-12545 connect failed because target host create a database and using OEM Database Configuration Assistant. I put in FirstDB for the Global Database Name and put in FirstDB for the SID. I completed the wizard and set up my tnsnames.ora file with the SID and hostname. Then I tried to connect using OEM with the Sys login and it says: ORA-12545:Connect failed because target host or objectOra-12545 Sqlplus
does not exist. Should I put in localhost or 127.0.0.1 for my Global Database Name? I assume I connect as Sys or System and the password I created right after creating the database. Please advise on how I can get this to work? Answer: Use oerr to look up the ORA-12545 error: ORA-12545: Connect failed because target host or object does not exist Cause: The address specified is not valid, or the program being connected to does not exist. Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.
I would start to debug a ORA-12545 error with these steps: making sure that your listener is running (lsnrctl stat) testing connectivity with ping, and then tnsping. verifying connectivity via the DNS (e.g. /etc/hosts) make sure to check your tnsnames.ora parms. Also see MOSC notes (http://support.oracle.com) on theSQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle
Ora-12545 Network Transport
Scripts Ion Excel-DB Don Burleson Blog
ora 12545 connect failed toad ORA-12454: connect failed because target host or object does ora-12545 toad not exist tips Oracle Error Tips by Stephanie F The Oracle docs note this on the ora-12454 error: ORA-12545: Connect failed because target host or object does http://www.dba-oracle.com/t_ora_12545_connect_failed.htm not exist Cause: The address specified is not valid, or the program being connected to does not exist. Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the http://www.dba-oracle.com/t_ora_12454_connect_failed_because_target_host_or_object_does_not_exist.htm TNSNAMES.ORA file to change the host name to a numeric IP address and try again. On Oracle DBA Forums, a user posts about having problems connecting on local workstation options to a new database. Below are the specifics of the question, as well as the original conflicts with ORA-12545: Question I have Oracle 9i installed on my local Windows XP workstation that will be used for local development only. Now I am trying to create a database and using OEM Database Configuration Assistant.I put in FirstDB for the Global Database Name and put in FirstDB for the SID.I completed the wizard and set up my tnsnames.ora file with the SID and hostname. Then I tried to connect using OEM with the Sys login and it says:ORA-12545:Connect failed because target host or object does not exist.Should I put in localhost or 127.0.0.1 for my Global Database Name?I assume I connect as Sys or System and the password I created right after creating the database.Please advise on how I can geSAP on OracleWhere is this place located?All Places SAP on Oracle 10 Replies Latest reply: Sep 18, 2014 10:27 AM by Reagan Benjamin Tweet ORA-12545: Connect failed because target http://scn.sap.com/thread/3622022 host or object does not exist (urgent) santhana barathi Sep 18, 2014 6:16 AM Currently Being Moderated Dear experts,Am new to basisI have a issue with starting SAP after a homogeneous system copy. am getting error on brconnect/brtools to change sapsr3 user password. brconnect -u system/