0

I have followed the below step guide(URL) to setup Oracle on Mac OS. Everything is fine on the guest side. But, I am facing some issues in host level.

I can connect database in Guest (Virtual box) but, when I tried to open the connection from host then I got a below error message.

"ORA-01017: invalid username/password; logon denied.

Note: I am unable to do the step to stop the firewall on Guest.

https://dimitrisli.wordpress.com/2012/08/08/how-to-install-oracle-database-on-mac-os-any-version/

http://blog.codiez.co.za/2013/09/setup-oracle-instant-client-ruby-oci8-gem-mac/

sqlplus hr/oracle@cdb1

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 18 13:32:48 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Update: file - /usr/local/oracle/admin/network/tnsnames.ora

cdb1=
 (description=
   (address_list=
     (address = (protocol = TCP)(host = 127.0.0.1)(port = 1521))
   )
 (connect_data =
   (service_name=cdb1)
 )
)
3
  • type usernames in capital - sqlplus HR/oracle@cdb1
    – a_vlad
    Nov 18, 2015 at 5:56
  • No. It's not working. Actually the same is working on Guest (Virtualbox) os.
    – Mr. Black
    Nov 18, 2015 at 6:08
  • How You configure guest network? (NAT, bridge or etc) if NAT (default) - did You setup port forwarding? if Bridge - change tnsname and tnslistener from listen 127.0.0.1 to real guest address
    – a_vlad
    Oct 30, 2016 at 23:11

1 Answer 1

1

You can manual check password for HR (if You want - force SET it oracle) Firewall is not important moment, because Oracle return You exactly error text

if all correct, it must be:

macbookva:instantclient_11_2 vladimir$ sqlplus HR/oracle@XE

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 18 19:24:20 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> 
8
  • As I said above the username and password is working on Guest and not working in host only.
    – Mr. Black
    Nov 18, 2015 at 7:24
  • what information is in Your tnsnames.ora file?
    – a_vlad
    Nov 18, 2015 at 7:31
  • Updated the information on my question.
    – Mr. Black
    Nov 18, 2015 at 7:48
  • ok, what about - sqlplus sys/oracle@cdb1 as sysdba ?
    – a_vlad
    Nov 18, 2015 at 8:48
  • no.. it's not working sqlplus sys/oracle@XE as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 18 16:51:04 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-12154: TNS:could not resolve the connect identifier specified Enter user-name: ¸ ^[
    – Mr. Black
    Nov 18, 2015 at 8:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.