43 replies to this topic

[ethergeek]

So I'm trying to install 10g on my XP Pro development box, and the install goes fine (I do the basic install of enterprise edition, I'm by no means an oracle expert) and when it gets to the part where it wants to create a database, the database creation assistant fails saying first that it cannot retrieve credentials, and then that it can't connect to ORACLE (I'm assuming this is the instance name).

Anyone have *any* idea what's going on here?

[yordan]

You probably missed the part of the installation where you give the "system" and "sys" user passwords.
this means that you should restart (more carefully) the database creation part.
You can choose the database creation assistant in order to do that, you reach it by clicking somehow like "start", "programs", "oracle orahomeXXX", "database creation assistant".
You may also consider de-installing oracle, (click on the "runinstaller", choose "installed products" and click "deinstall"), and restart the whole install from scratch.

[ethergeek]

I did all that before...my first instinct was that I fatfingered something, so I went through and reinstalled everything. I gave it default passwords to test it, but it wouldn't log in. I couldn't ev.en get PL/SQL to connect using the URL it gave me in the post-install screen, something about a TNS error. I researched the error and it ran through the fixes described (by removing NTS as an authentication service) but then I just got a different TNS error from PS/SQL+.

Oracle installs *flawlessly* on my Linux boxes and on my Windows Server 2003 box...not sure what it's problem is here...

[yordan]

The tns error means that the listener does not work.
there are no default passwords on Oracle 10, you must give a password like "nobody" or "mypassword", but you have to give one.
The winXP install for Oracle10 works exactly the same way as on Linux ! Simply the way the services are managed are different, in XP they are started from the Control Panel.

[ethergeek]

Control panel? Where in the control panel? Did I miss some oracle configuration control panel applet? I looked in the services snap-in and it didn't list any oracle services (unless it calls it something really arcane). I figure since the oracle installer offers to set up a database for you at install-time it should be pretty automatic and straightforward.

[yordan]

Yes, the install is fully automatic and straightforward, and you don't need to go outside the Oracle installer. However, if you go to the Windows Operating system control pannel in order to understand things, you should see the Oracle services started in automatic mode. If not, something was wrong in your installation, for instance if you do the install without being the Windows administrator.

[ethergeek]

OK, oracle didn't install any services at all...which is weird because I was running it as a Domain User in the local administrators group...do you think I need to be logged into a local administrator account?

[yordan]

OK, oracle didn't install any services at all...which is weird because I was running it as a Domain User in the local administrators group...do you think I need to be logged into a local administrator account?

Yes, sure ! You must be the local admin of this computer, and not a domain user.
Moreover, I'm afraid you cannot install it in a domain, maybe you should (just for testing purposes) try to install a standalone Windows system and try installing Oracle 10g on it.
You know, a RDBMS database server must be installed on a server system. You can cheat, installing it on a standalone Windows system, the standalone system emulating a server. But I'm even not sure you can install it on a client machine. Oracle server is traditionally installed on server systems, and Oracle client is installed on client system.
Please, keep us informed, if you were successful loggin on your own system as localsystem administrator, and if you were then able to correctly install Oracle.
If not, I strongly suggest you to restart everything from scratch (even on an old machine) just for learning purposes. After installing on a brand new Windows standalone system, you will feel more confident for installing it on your client system.
Regards
Yordan

[ethergeek]

I ran the setup using the SYSTEM account via PsExec and everything went off without a hitch. It looks like when run as a domain user (even if said domain user is a member of the local administrators group) it fails to set up the listener and the DBCA can't connect to the oracle instance.

It shouldn't have any trouble running on a workstation-class machine with 4GB of ram...the fact I'm using XP Pro and not Server 2k3 shouldn't make any difference with the exception of some optimizations having to do with timeslice quantas and resource allocation,

[yordan]

OK, glad to see that there are no more 10g install issues, and everything is working fine now.
So, we learned something from your adventure : we have to be system admin when starting and Oracle install on a Windows system.
Which is not fully the case when installint on a Linux or on a Unix or AIX box. On a Unix box, you prepare the install as system admin (rootpre.sh has to be fired by the "root" user), then you perform the whole installation as a standard user, and only at the end you have to become the system admin "root" user in order to fire the last install scripts name "root.sh".
Now, we are happy for you, enjoy your Oracle on Windows install.
Yordan

[ethergeek]

The weirder question is why it doesn't let me use a domain account that has local administrative rights on the system. It strikes me as kind of weird, since all of the group policy on the machine functions on a group-level basis, and my domain account should have the same privileges as my local administrator account.

Edited by ethergeek, 13 March 2007 - 07:27 PM.

[yordan]

Try asking your local network security people. I would not be surprized if your domain account user has some limited administration permissions, but is not able to fire scripts modifying the Windows registry, and is unable or starting scripts creating network services.
In a perfect world, your domain network security people should be able to enhance the rights of the local user, allowing him to perform these extra administration tasks.
I am currently experiencing these kind of problems, I am supposed to be administrator of my local machine but I cannot read some files owned by the domain administrators (who don't want to tell me their passwords, I can't guess why )

[vhortex]

I ran the setup using the SYSTEM account via PsExec and everything went off without a hitch. It looks like when run as a domain user (even if said domain user is a member of the local administrators group) it fails to set up the listener and the DBCA can't connect to the oracle instance.

It shouldn't have any trouble running on a workstation-class machine with 4GB of ram...the fact I'm using XP Pro and not Server 2k3 shouldn't make any difference with the exception of some optimizations having to do with timeslice quantas and resource allocation,

When running in a domain.. a domain controller can override all settings that a local domain accounts have including the local admin. this phenomenon occur most of the time in active server pages, being a part of the local admins does not solve any problems since as an active server controller.. i can block you to get those access, being part of the local domain admin users only gives you the title to install program files which is beyond that.. nothing else is differrent.

even the main local admin account is not immune to some restriction that Active server pages can give. anyway, you can gain them back by messing with your system registry, a hacking way to get all access you must have to begin with.

------------


Oracle needs to be run/install as admin on the local computer. Starting with 10g, installation of Both the server and client on the same machines needs some tweaking that made the Oracle team develop and express edition.

I am using a machine with 10g server and 10g client. trick part is stop using TNS names instead connect using direct IP which is your local loopback IP or your network IP if things get a little messy.


-------------

I am currently experiencing these kind of problems, I am supposed to be administrator of my local machine but I cannot read some files owned by the domain administrators (who don't want to tell me their passwords, I can't guess why )

I bet you are on NTFS file system, on NTFS file system.. each files have a special NTFS hash keys which prevents programs to read of write to those files that you dont own. But it is still windows, if allowed here.. i can send you a NTFS reader program. It bypass the NTFS restriction but requires you to operate temporarily on DOS shell until you have successfully copy the files you want to access..

Edited by vhortex, 15 March 2007 - 09:23 PM.

[yordan]

Oracle 10g Install Issues
How many systems was connect in oracle 10g on windows 2003 server
I have 20 systems of 10 systems was log into oracle, if you log 11th system the server was shut downing
-reply by Vijay Pal

This is not an Oracle issue.
In this case, Oracle gives an error message like "connexion refused".
In your case, it's a Windows 2003 systemwide problem, probably not enough memory, or out of disk space for windows virtual memory.
So, you should have a look at the Windows system logs, especially concerning the services.

[yordan]

I heard only 5 people can access the database at a time is that information is correct ?
-swapna

this is false. the number of allowed users is defined by your licence. If you paid for a 200 users licence, 200 users can connect.
Of course, you should not change the "processes" value in the init.ora file if you did not paid the corresponding licence, this would not be honest.

[yordan]

[My lister worked fine before I install other software. Now getting this error message
Ora-12541:TNS:no listner
-barbarar

this message is self-explanatory : the listener is not running.
If it was working previously, go to your server system and have a look at the services (Start, control pannel, system, services), and check that the service is defined to auto-start.
You can also check that in a command line window. On the server, open a "cmd" window, and type :
"lsnrctl status"
(without the quotes). i'm pretty sure the answer will be an error message, saying that the listener is not running.
Then, simply type
"lsnrctl start"
you will see the listener starting.
then, type again
"lsnrctl status"
And you will see things like "service blablah has two handlers", which means that your database remote access services are handled by this listener.
Hope this helped.
Yordan