OraFAQ Forum: Unix » Migrating to OS X

Home » Infrastructure » Unix » Migrating to OS X (Navicat Lite, 9.1.4, OS X Snow Leopard 10.6.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migrating to OS X [message #495484]

Sat, 19 February 2011 22:16

therevisnotdead
Messages: 5
Registered: February 2011
Location: Canada

Junior Member

I apologize if this question is out of context/in the wrong forum, etc...

I am a student using Navicat Lite in Windows to manage databases. However, I use a Mac for pretty much every other task. So, I installed Navicat Lite for Mac but am having trouble getting it up and running. I imported my connections from Windows, but when I try to connect I get a "Connection Failed" error message.

I think this has something to do with the TNS listener... but I really don't know what I'm doing as I'm very new to this.

Should I have something in the TNS_ADMIN field under preferences?

Any help/explanation would be greatly appreciated!

Report message to a moderator

Re: Migrating to OS X [message #495486 is a reply to message #495484]

Sat, 19 February 2011 22:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I am a student using Navicat Lite in Windows to
What is Navicat?

Post complete results of
SELECT * from v$version;

Report message to a moderator

Re: Migrating to OS X [message #495488 is a reply to message #495484]

Sat, 19 February 2011 22:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Yes, if you want to use one.
Hope you do have a valid client install.
For simplicity, I just use Oracle instant client and use same values for
ORACLE_HOME,DYLD_LIBRARY_PATH and TNS_ADMIN.
There should be a tnsnames.ora file in the TNS_ADMIN path that has valid entries to databases.
Else
just use the "basic" connection and fill all entries manually.
/forum/fa/8721/0/

PS:
I use highly customized environment with symlinks to all other tools from my custom ORACLE_HOME.
You can just use the "bundled instant client" and point it to TNS_ADMIN which has tnsnames.ora

Attachment: Screen shot 2011-02-19 at 11.49.11 PM.png
(Size: 65.40KB, Downloaded 3824 times)

[Updated on: Sat, 19 February 2011 23:13]

Report message to a moderator

Re: Migrating to OS X [message #495492 is a reply to message #495488]

Sat, 19 February 2011 23:19

therevisnotdead
Messages: 5
Registered: February 2011
Location: Canada

Junior Member

Thanks for the replies!

To answer BlackSwan, Navicat is a GUI for managing databases.

I can run any queries yet because I have no databases to run them on (or, I don't know how to without connecting first XD ). I can't connect using the connections I imported from the Windows version of Navicat.

Mahesh, I'm not sure if I could just use your values and replace your username with mine? I don't see any instantclient_x_x files in that directory when I check it. Here's my preference pane:
/forum/fa/8723/0/

I appreciate the help thus far.

Attachment: Screen shot 2011-02-20 at 12.16.37 AM.png
(Size: 57.38KB, Downloaded 3716 times)

Report message to a moderator

Re: Migrating to OS X [message #495493 is a reply to message #495492]

Sat, 19 February 2011 23:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I updated my last post instead of replying again.
Quote:

I use highly customized environment with symlinks to all other tools from my custom ORACLE_HOME.
You can just use the "bundled instant client" and point it to TNS_ADMIN which has tnsnames.ora

In other words, use your own values.

>>I can run any queries yet because I have no databases to run them on
Oracle is not like mysql.
First you need a database. Locally or remote.
Then configure your tnsnames.ora file identified by TNS_ADMIN
or
just use basic values (supply host,oracle sid, port,username/password).

[Updated on: Sat, 19 February 2011 23:27]

Report message to a moderator

Re: Migrating to OS X [message #495494 is a reply to message #495493]

Sun, 20 February 2011 00:02

therevisnotdead
Messages: 5
Registered: February 2011
Location: Canada

Junior Member

Forgive me, I am still confused... I will explain in more detail.

I've run Navicat Lite in a Windows environment on my Mac, where I created and manipulated databases on a regular basis. All connections were working fine. I exported the connections and imported them into my OS X environment, and I'm getting this error:

ORA-12154: TNS:could not resolve the connect identifier specified

I know I have to connect with TNS. I know I am missing something. You stated I need to create a database first. How do I do this? Sorry, I know that I'm really new to this still.

Report message to a moderator

Re: Migrating to OS X [message #495497 is a reply to message #495494]

Sun, 20 February 2011 00:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Check your tnsnames.ora.
Your environment is not properly configured.

http://ora-12154.ora-code.com/

Report message to a moderator

Re: Migrating to OS X [message #495541 is a reply to message #495497]

Sun, 20 February 2011 18:19

therevisnotdead
Messages: 5
Registered: February 2011
Location: Canada

Junior Member

I can't find a TNSNAMES.ora file anywhere on my Mac. Also, I don't know which directory to look for it in.

Report message to a moderator

Re: Migrating to OS X [message #495542 is a reply to message #495541]

Sun, 20 February 2011 19:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

find / -name tnsnames.ora -print 2>/dev/null

Report message to a moderator

Re: Migrating to OS X [message #495543 is a reply to message #495542]

Sun, 20 February 2011 19:34

therevisnotdead
Messages: 5
Registered: February 2011
Location: Canada

Junior Member

So I just run that in Terminal?

Report message to a moderator

Previous Topic:	Login to Correct SID
Next Topic:	Oracle User monitoring

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 17:25:26 CST 2025