21739

Oracle database connectivity issue

Question:

I have a oracle database instance on my local machine , which i try to connect to .

Using SQL Developer , i can connect to it . But when i use sqlplus i cannot connect to the instance.

The error message i get is

ORA-28547:connection to server failed,probable oracle net admin error.

I tried restarting my TNS service but still the issue persists.

And i need to connect to sqlplus because i need to import the dumps using

impdp system/***** schemas=abcd dumpfile=DUMP_500.dmp

Please let me know what other information is needed , so that i can post

Thanks

Answer1:

Are you using the same tnsnames.ora file for your SQL*Plus that your SQL Developer is using?

Also try adding SQL_AUTHENTICATION_SERVICES = (NONE) to your sqlnet.ora file.

Recommend

  • Where can I find documentation on not supporting SOAP method overloading?
  • Mapping a function over two input lists
  • how to export a function in GAS assembler?
  • How do I catch data from the XML content of a SOAP request in a php SOAPServer?
  • How to find multiple Pattern(s) (using Matcher) in Java
  • JAXB / XJC: Generate classes from elements with same complexType
  • Writing PHP in
  • Avoiding ORA-00955: name is already used by an existing object
  • Hibernate Criteria causes ORA-00918: column ambiguously defined
  • How do I revert sys.stdout.close()?
  • Restart app on force kill
  • Controlling Prolog variable value selection
  • ASP Error 0223 - TypeLib Not Found, intermittent, resolved after IIS restart
  • CDI: Injecting single instance works, but injecting Instance does not. Why?
  • ORA-12154: TNS:could not resolve the connect identifier specified
  • Why is django manage.py syncdb failing to create new columns on my development server?
  • Changing Jupyter Notebook start up folder by modifying “start in” not working any more
  • Problem with Django using Apache2 (mod_wsgi), Occassionally is “unable to import from module” for no
  • Configure nginx to return different files to different authenticated users with the same URI
  • How to override value that appears in a dropdown in the rails_admin gem
  • Check for zero lines output from command over SSH
  • nonblocking BIO_do_connect blocked when there is no internet connected
  • Problems installing Yesod for Haskell
  • Unable to install Git-core+svn by MacPorts
  • VSO Build — Response status code does not indicate success: 404 (Not Found)
  • MailKit: The IMAP server replied to the 'EXAMINE' command with a 'BAD' response
  • NHibernate Validation Localization with S#arp Architecture
  • ilmerge with a PFX file
  • How can I send an e-mail from a vbs script
  • Accessing IRQ description array within a module and displaying action names
  • Get object from AWS S3 as a stream
  • Resize panoramic image to fixed size
  • Volusion's generic SQL folder, functionality
  • Cross-Platform Protobuf Serialization
  • Validaiting emails with Net.Mail MailAddress
  • Display Images one by one with next and previous functionality
  • Do I've to free mysql result after storing it?
  • How do you join a server to an Active Directory (domain)?
  • coudnt use logback because of log4j
  • Getting Messege Twice Using IMvxMessenger