| Instalation [message #307738] |
Wed, 19 March 2008 14:28  |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
Hi, I have installed oracle developer suite 10g in my computer, I cannot log in and I had never been asked for a password during the installation. I have tryed system/manager, scott/tiger and as host string I used orcl which is the one in tnsname. I am a programmer and I have never installed oracle before, can anybody help me please?
Thank you in advance
|
|
|
| Re: Instalation [message #307747 is a reply to message #307738 ] |
Wed, 19 March 2008 15:38  |
anacedent
Messages: 4942
Registered: July 2005
Location: surf meets turf in SoCal |
Senior Member |
|
|
>I cannot log in
log into what?
Oracle Developer is like an editor on steroids.
One does NOT "login" to an editor.
Do you have an actual Oracle DataBase installed on the same system or on a system on the local network?
|
|
|
| Re: Instalation [message #307946 is a reply to message #307747 ] |
Thu, 20 March 2008 08:32 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
|
yes, the oracle database which comes with oracle suite 10g but I cannot connect to it neither
|
|
|
| Re: Instalation [message #307986 is a reply to message #307946 ] |
Thu, 20 March 2008 12:15 |
Littlefoot
Messages: 5557
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
But, there's no database within Developer Suite installation ... it should be installed as an independent product (and into another Oracle Home).
So, what you need is (for example):
- Oracle 10g Express Edition database
- Oracle Developer Suite 10g
Can you verify that both products are installed? Check what OUI (Oracle Universal Installer) says (click "Installed Products" button). If both are installed, it will look like this:
We'll see what next after you return with the news.
Attachment: oui.PNG
(Size: 7.30KB, Downloaded 137 time(s))
|
|
|
| Re: Instalation [message #308023 is a reply to message #307738 ] |
Thu, 20 March 2008 15:54 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
Thank you for your help, I really appreciate that.
You are right there wasn't a database (I thought there was one because I could call sql plus from application development). I have installed now database 10g, it works correctly I use the password for the username 'system' I was asked while it was installed and I don't need a host string. I can connect to oracle forms builder as well with the same username and password and create and compile a form, but when I run a form, it tries to open the oracle application server and an error message appears which says ' ora-12560 tns protocol adapter error' and ask for another password, but I don't know which one.
|
|
|
| Re: Instalation [message #308074 is a reply to message #308023 ] |
Fri, 21 March 2008 01:16 |
Littlefoot
Messages: 5557
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
| Quote: | I could call sql plus from application development
|
SQL*Plus is just a tool (a tool as Forms Builder or JDeveloper or TOAD or ... are); its existence doesn't mean that there's also a database (as you've already seen).
During development process, you should start OC4J instance (its icon can be found under Developer Suite - Forms Developer menu (if on MS Windows)). Try to start it; also, if you use MS Internet Explorer as web browser, check whether you have enabled Tools - Internet Options - Advanced tab - Security section - Allow active content to run in files on My Computer.
|
|
|
| Re: Instalation [message #308137 is a reply to message #307738 ] |
Fri, 21 March 2008 08:19 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
I did both things (start OC4J instance and enable active content to run in files on My Computer) but it still doesn't work, I have the same message than before: Ora-12560 TNS Protocol adapter error
|
|
|
| Re: Instalation [message #308156 is a reply to message #307738 ] |
Fri, 21 March 2008 11:53 |
varu123
Messages: 626
Registered: October 2007 |
Senior Member |
|
|
start your database.
and don't ask now how to start the database
|
|
|
| Re: Instalation [message #308193 is a reply to message #307738 ] |
Fri, 21 March 2008 17:44 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
|
The db is up!,as soon as I installed it, I created some tables and inserted and updated data.
|
|
|
| Re: Instalation [message #308202 is a reply to message #307738 ] |
Sat, 22 March 2008 00:11 |
varu123
Messages: 626
Registered: October 2007 |
Senior Member |
|
|
When working with 10g developer suite and 10g database or any,you need to start the database that starts your listener also.
Make sure these two things are started.
then you start all the processes in /j2ee/DevSuite/startinst.sh
After that you run the application on web.The first time it ask for
username ,password,service name.
The username and password is of user that you have used to write the code for your application.
the service name is the service name for your database.
|
|
|
| Re: Instalation [message #308216 is a reply to message #308202 ] |
Sat, 22 March 2008 06:57 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
Thank your for your answer,
I only want to use forms and report and I don't want to connect to another computer, Must I start all the processes in startinst.sh as well?, where is it?
|
|
|
| Re: Instalation [message #308237 is a reply to message #307738 ] |
Sat, 22 March 2008 10:56 |
varu123
Messages: 626
Registered: October 2007 |
Senior Member |
|
|
| Quote: | I did both things (start OC4J instance and enable active content to run in files on My Computer)
|
How did you start oc4j instance?
whats your os?
With 10g developer suite,you run forms through web ie a url.
Open your form builder.
Run the sample test.fmx provided by oracle.
What do you see?
|
|
|
| Re: Instalation [message #308242 is a reply to message #308237 ] |
Sat, 22 March 2008 12:59 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
1- I start oc4j which I found under: Developer Suite - Forms Developer menu
2- My OS is windows xp
3- I have connect to the database and to oracle forms builder with the same username (system) and the password I was asked when I installed the database, I don't use any host string. It works correctly I can create tables and insert, update and delete in the database and I can create a form and compile it, the problem is when I tried to run the form, it tries to open oracle application server and an error message appears which says ' ora-12560 tns protocol adapter error' and ask for another username/password, apparently the one I used to connect to the database and to create and compile a form doesn't work to run one, but I don't have another one. I have checked and the listener is started and I have started the oc4j as well
|
|
|
| Re: Instalation [message #308243 is a reply to message #308242 ] |
Sat, 22 March 2008 13:05 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
|
Sorry, I didn't finish the previous message. I would like to add that I have run the web form tester and it is says that internet explore cannot display the webpage
|
|
|
| Re: Instalation [message #308246 is a reply to message #308243 ] |
Sat, 22 March 2008 14:30 |
Littlefoot
Messages: 5557
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
While in Forms Builder, go to Edit menu - Preferences - Runtime tab and see how it looks like. What's in the Application Server URL? What happens if you "Reset (it) to Default"?
A working sample might look like this:
|
|
|
| Re: Instalation [message #308277 is a reply to message #308246 ] |
Sun, 23 March 2008 08:32 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
The Application Server URL and the web browser location were blank, I reset to default and added the web browser but I still have the same problem.
Thank you for your pattient
|
|
|
| Re: Instalation [message #308284 is a reply to message #307738 ] |
Sun, 23 March 2008 12:59 |
varu123
Messages: 626
Registered: October 2007 |
Senior Member |
|
|
Then your oc4j is not started.
check from command prompt the following commands
netstat -na | find "8889"
netstat -na | find "8890"
if the output is no result then oc4j is not started.
|
|
|
| Re: Instalation [message #308291 is a reply to message #308284 ] |
Sun, 23 March 2008 16:04 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
This is what netstat and oc4j says:
Attachment: Doc1.doc
(Size: 176.50KB, Downloaded 20 time(s))
|
|
|
| Re: Instalation [message #308300 is a reply to message #307738 ] |
Mon, 24 March 2008 00:01 |
varu123
Messages: 626
Registered: October 2007 |
Senior Member |
|
|
Then you check your web browser location as shown by Littlefoot.
|
|
|
| Re: Instalation [message #308541 is a reply to message #308300 ] |
Mon, 24 March 2008 14:26 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
|
I checked it and The Application Server URL and the web browser location were blank, I reset to default and added the web browser but I still have the same problem.
|
|
|
| Re: Instalation [message #308543 is a reply to message #308541 ] |
Mon, 24 March 2008 14:35 |
Littlefoot
Messages: 5557
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
It definitely is annoying; the fact is that previous Oracle versions used to be difficult to install, but recent ones, with new Oracle Universal Installer are Windows-like installations - point and click.
I really wouldn't know what went wrong, but - perhaps you should reinstall Oracle software (remove it completely by deleting directories AND all software keys from registry; then reboot).
But, before you do that final step, let me try one more thing: this is the current situation: first you have installed Developer Suite, then Oracle Database. Right?
Can you connect to the database using SQL*Plus that belongs to Database installation? (I suppose you can)
Can you connect to the database using Developer Suite's SQL*Plus? (I suppose you can not; if I suspect correctly, it means that you can't connect using Forms as well).
Now: go to Database\network\admin directory and take TNSNAMES.ORA and SQLNET.ORA files. Copy and paste them into the DeveloperSuite\network\admin directory.
Try to connect once again.
|
|
|
| Re: Instalation [message #309088 is a reply to message #308543 ] |
Wed, 26 March 2008 06:57 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
Yes, it works!!!!!!!!! I have copied tnsname and sqlnet and I can run a form in the web. Thank you very much for your help!!!!!
There is only one thing more, I cannot run a report in the web, do you think I have to reinstall oracle suite?
Thank you again for your patient.
|
|
|
| Re: Instalation [message #309090 is a reply to message #309088 ] |
Wed, 26 March 2008 07:10 |
Littlefoot
Messages: 5557
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
I don't know what to think, until you explain what "I cannot run a report in the web" means.
What happens when you try? How do you do that? We need more information.
|
|
|
| Re: Instalation [message #309114 is a reply to message #309090 ] |
Wed, 26 March 2008 08:10 |
ester
Messages: 13
Registered: March 2008 |
Junior Member |
|
|
It works now, the problem was that the browser path in the regedit was wrong, I corrected it and now it works!!!!!!!!!!!!
|
|
|
]
Members
Search
Help
Register
Login
Home
