Oracle 10g Install Issues

ethergeek

Mar 9 2007, 08:42 PM

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

Mar 10 2007, 06:16 PM

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

Mar 10 2007, 07:18 PM

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

Mar 10 2007, 10:14 PM

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

Mar 10 2007, 11:57 PM

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

Mar 11 2007, 12:04 AM

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

Mar 11 2007, 12:10 AM

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

Mar 11 2007, 05:53 PM

QUOTE(ethergeek @ Mar 11 2007, 01:10 AM)

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

Mar 12 2007, 05:33 PM

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

Mar 13 2007, 01:06 PM

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

Latest Entries

iGuest

Jul 4 2008, 03:16 AM

Answer to development suite problem
Oracle 10g Install Issues

Replying to Feedbacker Replying to Feedbacker

Marserson, in regards to your question (as below)
Creating Admin Account
Oracle 10g Install Issues

I have installed the software using the 2 disk set that came with the book. I however am at no time prompted to set up an admin account so that I can enter SQL plus to start scripting to create databases and tables etc. All applications in the development suite require a login to begin so what do I use initially before setting up any accounts?

-question by Masterson

I had the same problem (having installed the deveopment suite from the 2 disk set - and spent hours trying to work out what was going on)
Then I realised that the development suite doesn't actually contain the oracle database software (it only contains other tools to work with it), thats why you didn't at any stage get asked to configure the default DB.

WHat you need to do is install oracle database software also (if you go to the oracle site you can download oracle express for free), once this is installed you can then access the database through that software and if you configure the development suite (using the net configuration assistant) you will be able to access all those tools correctly)

I hope this helps

Regards

- The General

-reply by The General

Doc.h0llyw00d

Mar 24 2008, 06:30 PM

QUOTE

I see thet your really are not familiar with Oracle passwords:
-Yordan

That is what i stated, Yes. That was also something I offered as a last option if nothing else worked. The User's question was in regards to the fact that he could not even access administrative options, so he can't change passwords, so, he can't assign new ones, so he does need to know them.

Now, while it seems like he just needs to familiarize himself with the program so that he can change these settings, as I've never heard of software that requires passwords to even use it locally (that weren't set by the user in a prompted screen). But based on his statement:

QUOTE

All applications in the development suite require a login to begin so what do I use initially before setting up any accounts?

I assumed that he had read through the user manual for their possible default passwords (finding none) and was then turning to us for suggestions.
That's what I gave him, a suggestion, a tentative one at that.

On another note:

I'd think that you would find that a lot of software in general uses Admin/Pass (or variations) as default (not standard or popular) password settings, at least I have in my experiences.

Regards,
The Doc.

Edit:

As another option, you might try (directed at FeedBacker) to setup an account even without knowing the passwords, without seeing your screen its hard to tell, but the initial login might create the account you are trying to set up, anyway.

yordan

Mar 24 2008, 06:15 PM

QUOTE(Doc.h0llyw00d @ Mar 24 2008, 06:40 PM)

I'm not terribly familiar with Oracle, however:
If all of this sounds greek to you, You can always try Admin/Pass, Administrator/Password, etc typical default entries..

I see thet your really are not familiar with Oracle passwords: none of these are standard nor popular Oracle passwords.
And, of course, remember that the oracle admin can at any moment change any Oracle password. No need to know the passwords, simply assign the new ones.

Doc.h0llyw00d

Mar 24 2008, 05:40 PM

I'm not terribly familiar with Oracle, however:

Typically, Database systems have two methods for authentication. Usually when you set up a database you can connect via SQL Authentication (at least in the case of MS SSMS) which means that you have created a database with unique authentication rights. Usually this would be done when setting up a New Database....

As a side note, make sure you have created a database that you are trying to connect to.

The second method of authentication, and I believe Oracle supports this, no idea why it wouldn't, is Windows Authentication, which is usually automated, however you might need to provide this information, which would be the same as the account which you accessed the computer with.

If all of this sounds greek to you, You can always try Admin/Pass, Administrator/Password, etc typical default entries..

and then as a last resort you could call Oracle support and get your question answered there.

Best Regards,
The Doc.

iGuest

Mar 22 2008, 10:16 PM

Creating Admin Account
Oracle 10g Install Issues

I have installed the software using the 2 disk set that came with the book. I however am at no time prompted to set up an admin account so that I can enter SQL plus to start scripting to create databases and tables etc. All applications in the development suite require a login to begin so what do I use initially before setting up any accounts?

-question by Masterson

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE