OraFAQ Forum: Server Administration » Unsure what / who to ask.

Home » RDBMS Server » Server Administration » Unsure what / who to ask.

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

Unsure what / who to ask. [message #146884]

Mon, 14 November 2005 08:33

hohltjrre
Messages: 6
Registered: November 2005
Location: Fort Worth

Junior Member

Greetings to all.
I downloaded the latest Oracle 9i version from www.oracle. I also downloaded Oracle Forms 6i. Oracle Forms was my area of work years ago. I am trying to return to Oracle.

My issue is this. I have only 1 computer(PC Windows XP-SP2) which I have installed the Oracle server on. This computer is networked but other computers will not be oracle clients.

I installed the 9i RDBMs on the computer and have also installed the 6i forms too. I installed the RDBMS on C: drive and Forms on a spare drive F:.

I am having a very difficult time trying to get Forms to use the 9i database. I have asked these questions over at www.oracle and have tried all the suggestions but I still have a disconnect. I have looked at both the 9i and 6i tnsnames.ora files to see if I can edit one so that Forms 6i will "SEE" 9i and use the tables in 9i. Frankly the tnsnames.ora files baffle me.

I have also tried to find the Environment variable TNS_ADMIN but could not find it. I was attempting to have this Environment variable point to my 9i tables. I don't know what else to try. Embarassed

Suggestions???

Report message to a moderator

Re: Unsure what / who to ask. [message #146887 is a reply to message #146884]

Mon, 14 November 2005 08:37

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

I can't help with your forms related questions, but if you are trying to "get back" into oracle and move forward, you may want to turn your attention to JDeveloper and related OTN pages / forums / technologies. Also HTMLDB. And database version 10gR2.

Report message to a moderator

Re: Unsure what / who to ask. [message #146907 is a reply to message #146887]

Mon, 14 November 2005 10:02

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi ,

Can u give us the error what you are getting when you are trying to connect to the database by Oracle Forms 6i...

-->first of all find is your sqlplus client is able to connect with database.

-->secondly see which database is running and what is the instance name

-->Thirdly check Is your oracle service for database is started .

-->Forthly see is your listener is started .

--> Fifth if there is more than one database on your PC/server then check oracle_sid is properly set or not.

your tnsname.ora must be in the F: drive where the oracle Form 6i is installed.
(note:- Find tnsnames.ora in F drive, it may be in some folder under F: drive)
you dont have to change in tnsnames.ora which is present at D drive oracle_home/network/admin.

Remember one thing Oracle 6i Form will check tns entry from his home not from the oracle database home ... coz Oracle Form 6i is a client which connect to the oracle DB so ... tnsnames.ora of client must have entry to connect to the database.. Smile

I hope now you should be able to connect...

Regards
Always Friend Sunilkumar

Report message to a moderator

Re: Unsure what / who to ask. [message #146913 is a reply to message #146887]

Mon, 14 November 2005 10:35

hohltjrre
Messages: 6
Registered: November 2005
Location: Fort Worth

Junior Member

smartin wrote on Mon, 14 November 2005 08:37

Step 1 is getting back with Oracle. Java is on my list Cool

Report message to a moderator

Re: Unsure what / who to ask. [message #146915 is a reply to message #146907]

Mon, 14 November 2005 10:37

hohltjrre
Messages: 6
Registered: November 2005
Location: Fort Worth

Junior Member

sunil_v_mishra wrote on Mon, 14 November 2005 10:02

I hope now you should be able to connect...

Regards
Always Friend Sunilkumar

At work now so don't have the info, but I will check into it. Thanks !!!! Cool

Report message to a moderator

Re: Unsure what / who to ask. [message #146931 is a reply to message #146884]

Mon, 14 November 2005 15:18

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Well my point was that if you are trying to get back with oracle by studying database version 9i and oracle forms, then you are already dating yourself to old technologies that are going away. Why 9i instead of 10gR2?

Report message to a moderator

Re: Unsure what / who to ask. [message #147035 is a reply to message #146907]

Tue, 15 November 2005 07:49

hohltjrre
Messages: 6
Registered: November 2005
Location: Fort Worth

Junior Member

Hello Sunil, I have the info from yesterday, however, I don't know what good it will be. Thanks for your help.

Quote:

Can u give us the error what you are getting when you are trying to connect to the database by Oracle Forms 6i...

ORA-12154 TNS Name service could not resolve...

Quote:

-->first of all find is your sqlplus client is able to connect with database.

Yes could do that with ease. With the 9i SYSDBA account and a 9i plain user account. The 6i sqlplus failed

Quote:

-->secondly see which database is running and what is the instance name

DB -> RHOHLTJ
instance -> rhohltj
This is my own personal database set up on one of my desktops

Quote:

-->Thirdly check Is your oracle service for database is started .

OracleServiceRHOHLTJ - STARTED

Quote:

-->Forthly see is your listener is started .

OracleOraHome92TNSListner - STARTED

Quote:

--> Fifth if there is more than one database on your PC/server then check oracle_sid is properly set or not.

I have been told that the Oracle Forms 6i carries no database with it, although it does have its own sqlplus, I am not sure. I know it doesn't carry a fancy front end like the Enterprise Manager I get with 9i. I set my 9i SID to be RHOHLTJ.HOME.

Quote:

your tnsname.ora must be in the F: drive where the oracle Form 6i is installed.
(note:- Find tnsnames.ora in F drive, it may be in some folder under F: drive)
you dont have to change in tnsnames.ora which is present at D drive oracle_home/network/admin.

Remember one thing Oracle 6i Form will check tns entry from his home not from the oracle database home ... coz Oracle Form 6i is a client which connect to the oracle DB so ... tnsnames.ora of client must have entry to connect to the database.. Smile

I hope now you should be able to connect...

Regards
Always Friend Sunilkumar

Thanks Sunil, I am still not able to connect. Frown

[Updated on: Tue, 15 November 2005 08:11]

Report message to a moderator

Re: Unsure what / who to ask. [message #147036 is a reply to message #146931]

Tue, 15 November 2005 08:03

hohltjrre
Messages: 6
Registered: November 2005
Location: Fort Worth

Junior Member

smartin wrote on Mon, 14 November 2005 15:18

Having limited resources like I do at home, I was unsure what to expect performance wise putting an Oracle server plus Forms on my home PC. I upgraded my PC to what I hoped was a faster setup and installed 9i. It was hopelessly slow. So I redid everything. Even faster system with even more RAM and reinstalled 9i again. This time all seems to be working. During this whole process, I went backward and installed 8i but was very underwhelmed with that. I have no excuse for choosing 9i instead of 10gR2 except maybe I could expect even more of a slowdown with newer more memory greedy product.

Why is 10gR2 that much better than 9i? I am (at the moment) not interested in putting ANYTHING on the net on any website. That concept is on my mind for the future, but not right now.

I know Java is the newest and greatest, but I need to take it slower. IMO, Forms is not going to completely die away just yet... Rolling Eyes

It might be sick but it's not entirely dead yet.

Report message to a moderator

Re: Unsure what / who to ask. [message #147182 is a reply to message #147036]

Wed, 16 November 2005 03:12

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Have you read the below written things & what do you want to say about this....
===============================================================
your tnsname.ora must be in the F: drive where the oracle Form 6i is installed.
(note:- Find tnsnames.ora in F drive, it may be in some folder under F: drive)
you dont have to change in tnsnames.ora which is present at D drive oracle_home/network/admin.

Remember one thing Oracle 6i Form will check tns entry from his home not from the oracle database home ... coz Oracle Form 6i is a client which connect to the oracle DB so ... tnsnames.ora of client must have entry to connect to the database..

I hope now you should be able to connect...
================================================================

Note :- Your Oracle forms 6i is install in different home than oracle DB so you required tnsnames.ora in home of Oracle Form 6i.

Regards
Always Friend Sunilkumar

[Updated on: Wed, 16 November 2005 03:15]

Report message to a moderator

Re: Unsure what / who to ask. [message #147390 is a reply to message #147182]

Thu, 17 November 2005 08:32

hohltjrre
Messages: 6
Registered: November 2005
Location: Fort Worth

Junior Member

Yes I have looked at the tnsnames.ora file located within my Forms 6i directory. I edited it first to ORCL/ ORCL.WORLD and that change enabled "tnsping" to find my Oracle 9i directory.

Forms 6i still did not connect though.

I then changed the Forms 6i tnsnames.ora to my Oracle 9i database RHOHLTJ/RHOHLTJ.HOME and again had success with "tnsping" and this time Forms was able to see the tables in Oracle 9i, however I was unable to select the tables in the forms builder. I got different messages stating the tables did not exist. I am still trying to find a solution. Thanks for your help. Cool

What is the purpose of the .domain like I have it(.HOME). When installing my database I was under the impression that this extension helps. Now I am not sure.

Report message to a moderator

Previous Topic:	partition table
Next Topic:	Port blocker

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 09:43:27 CST 2025