Hi everyone. Please help me as I am [still] new to Oracle.
Installing Oracle9iDB version 2 on windows xpPro, enough gigs and ram.
This is a DEVELOPMENT machine and I need to access the database locally on this machine.
I have installed twice. The first time I chose one of the pre-defiend databases and I had no problem accessing it with a variety of tools.
But when I added my own [empty] database, hoping to create tables via SQL+ or other tools, I couldn't get rights or access it.
So, I deleted the entire shelack-bang and re-installed, this time telling it that I don't want ANY pre-defined *anything*, database samples, or schemas. I need to try this like I will by my customer.
Ok. So it let me create a database, via the wizard, assign a SYS password.
I also setup a LISTENER (although I suspect something is wrong there).
BUT, if I try to access it via the EMP(locally) it tells me that there is no LISTENER, although there is!
Also SQL+ does not allow access, but maybe I don't understand what HOST_NAME to supply.
Question. Since for now, I am using the same machine for the database server as well as the client connectiong to it, do I still want the listener to use tcp? (I also tried nmp and it didn't help.)
Oh, the administration tool does show that the database is UP and running.
I am willing to UN-INSTALL and erase every iota of the previous installs. (Please tell me how.)
Can you please tell me what to watch out for when installing again?
Do I need to reintall to get it straight?
Thank you all in advance.
-Nat
Installing Oracle9iDB version 2 on windows xpPro, enough gigs and ram.
This is a DEVELOPMENT machine and I need to access the database locally on this machine.
I have installed twice. The first time I chose one of the pre-defiend databases and I had no problem accessing it with a variety of tools.
But when I added my own [empty] database, hoping to create tables via SQL+ or other tools, I couldn't get rights or access it.
So, I deleted the entire shelack-bang and re-installed, this time telling it that I don't want ANY pre-defined *anything*, database samples, or schemas. I need to try this like I will by my customer.
Ok. So it let me create a database, via the wizard, assign a SYS password.
I also setup a LISTENER (although I suspect something is wrong there).
BUT, if I try to access it via the EMP(locally) it tells me that there is no LISTENER, although there is!
Also SQL+ does not allow access, but maybe I don't understand what HOST_NAME to supply.
Question. Since for now, I am using the same machine for the database server as well as the client connectiong to it, do I still want the listener to use tcp? (I also tried nmp and it didn't help.)
Oh, the administration tool does show that the database is UP and running.
I am willing to UN-INSTALL and erase every iota of the previous installs. (Please tell me how.)
Can you please tell me what to watch out for when installing again?
Do I need to reintall to get it straight?
Thank you all in advance.
-Nat