Ora 12560 Tns Protocol Adapter Error 9i
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings ora 12560 tns protocol adapter error windows and policies of this site About Us Learn more about Stack
Ora 12560 Tns Protocol Adapter Error 11g Client
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs ora-12560 tns protocol adapter error sqlplus 11g Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them;
Ora-12560 Sqlplus
it only takes a minute: Sign up ora 12560 tns protocol adapter error- while connecting to oracle up vote 0 down vote favorite I have oracle 9i already installed in my machine. I am trying to connect to the oracle but while connection i am getting "ora 12560 tns protocol adapter error" type of error. i have tried it with ora-12560 windows the default pass scott/tiger , system/manager.. When i tried to connect to the oracle using default credentials i am getting the above error. is it the problem with the username and password ? if so how can i get the username and password which is already set ? oracle oracle9i share|improve this question asked Nov 6 '12 at 10:23 user1728578 2717 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote IME, ORA-12560 means the Oracle Universal Installer messed up your listener configuration. Assuming you have an Oracle 9i Server installed on your computer, here's a list of things to check. does "lsnrctl status" show your database instance? does "tnsping my_service_name" work? do tnsnames.ora and listener.ora contain entries for your database? Are the hostname / port etc. correct? If the configuration is wrong, your best bet is to start netca, remove your existing listener configuration and re-configure it. One question, though: Why do you want to run Oracle 9i? Do you have to support some kind of legacy application / database? (Oracle 1
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το
Tns-00530: Protocol Adapter Error
YouTube εμφανίζεται στα Ελληνικά. Μπορείτε να
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
αλλάξετε αυτή την προτίμηση παρακάτω. Learn more You're ora 12560 tns protocol adapter error client machine viewing YouTube in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω να http://stackoverflow.com/questions/13248981/ora-12560-tns-protocol-adapter-error-while-connecting-to-oracle τη κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ how to solve ORA-12560: TNS:protocol adapter error https://www.youtube.com/watch?v=agx5uVIq3gw Deepak Soni ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής4444 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Μεταγραφή Στατιστικά στοιχεία 111.811 προβολές 217 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 218 22 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 23 Φόρτωση... Φόρτωση... Μεταγραφή
by Anil Kumar on November 17, 2013 All Posts, Database, Oracle http://itbloggertips.com/2013/11/fixed-ora-12560-tns-protocol-adapter-error/ DBA 14 Comments Rate this post When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol adapter error Then follow the below mentioned steps to solve this issue. First of all, make sure that you have set the correct ORACLE_SID: C:\>sqlplus system/manager@xe protocol adapter SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:\>set ORACLE_SID=xe C:\>sqlplus system/manager@xe Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1388352 bytes Variable Size 620757184 bytes Database Buffers 444596224 bytes protocol adapter error Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If the above method doesn’t work, may be the OracleService for the database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service. C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:34:24 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error Now restart the service using below method. Start > Run > Type Services.msc Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:41:30 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1388352 bytes Va