Oracle Database Discussions

Hi,

Its no more publicly available, if you have valid database license you can request one from oracle support.

See Previous Database Release Software section  Oracle Database Software Downloads | Oracle Technology Network | Oracle

Regards

Yoonas

Previous Database Release Software

Oracle Database 10.2 and 11.1 are no longer available for download. The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) from My Oracle Support. NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. Once you install 10.2.0.1 you can then apply any 10.2 patch set. Similarly, for 11.1 request 11.1.0.6 which must be applied before installing 11.1.0.7. Patch sets can be downloaded from the Patches and Updates tab on My Oracle Support.

Why do you need 10g rather than 11g or 12g?

Top.Gun wrote:

Why do you need 10g rather than 11g or 12g?

I guess it's 12c

Aman....

975148 wrote:

I wanted to download Oracle 10g database from Oracle site http://www.oracle.com but I could not find the link for it. Can you please guide where would be the link on the Oracle site to download Oracle 10g DB or some other place for the same?

I hope, my question is clear.


Please revert with the reply to my query.


Regards

Why 10g in the first place?

Aman....

Thanks for your answer. I had done the course on Oracle database 10g administration workshop 1 and was wanting to do some hands-on. I had a copy of Oracle DB 10g and tried to install in C drive of my laptop having Windows 7 professional. It was giving some error message but when we changed it to D drive it installed. But there is a problem that when I do sqlplus at the command prompt, it is giving the error like as below:

C:\>sqlplus

SP2-1503: Unable to initialize Oracle call interface

SP2-0152: ORACLE may not be functioning properly

Requesting a reply to resolve this issue.

Regards

Hi,

Thanks Aman for your answer. I had done the course on Oracle database 10g administration workshop 1 and was wanting to do some hands-on. I had a copy of Oracle DB 10g and tried to install in C drive of my laptop having Windows 7 professional. It was giving some error message but when we changed it to D drive it installed. But there is a problem that when I do sqlplus at the command prompt, it is giving the error like as below:

C:\>sqlplus

SP2-1503: Unable to initialize Oracle call interface

SP2-0152: ORACLE may not be functioning properly

Requesting a reply to resolve this issue.

All what you could do with 10g can be done with 11g as well. So if your sole purpose is learning, you don't need to stuck at 10g. About your issue, a quick forum search gave this,

SP2-1503 when starting sqlplus (privilege problem)

HTH

Aman....

I had a copy of Oracle DB 10g and tried to install in C drive of my laptop having Windows 7 professional. It was giving some error message but when we changed it to D drive it installed. But there is a problem that when I do sqlplus at the command prompt, it is giving the error like as below:

C:\>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

That problem could be because you are installing 32 bit Oracle on a 64 bit OS or because 10g is being installed in Win 7 which wasn't certified.

Saying 'giving some error message' is meaningless. If you want help with the original problem provide the info needed: full 10 digit DB version and  whether it is 32 or 64 bit, the actual exception you receive.

Otherwise just download and use Oracle 12c for learning - install it as a non-multitenant DB unless you want to start learning the new architecture.

975148 wrote:

Thanks for your answer. I had done the course on Oracle database 10g administration workshop 1 and was wanting to do some hands-on. I had a copy of Oracle DB 10g and tried to install in C drive of my laptop having Windows 7 professional. It was giving some error message but when we changed it to D drive it installed. But there is a problem that when I do sqlplus at the command prompt, it is giving the error like as below:

C:\>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Requesting a reply to resolve this issue.

Regards

Searching MOS for those error message turns up a lot of things, indicating it is really rather generic.  I remember all my client installations getting bit with it when the net/os admin guys pushed out the weekly list of new Windows (XP) bugs.  Had to get a patch for the oracle 10.2 client installation.  I'd say it's likely you could be hitting essentially the same bug.  And given that you are trying to install on an OS for which your version of oracle was never certified . . .   I agree with Aman -- you don't need 10g.  That's like saying "I learned to drive in a 2010 Nissan Maxima, so I don't want to have to start driving a 2014 Toyota Camry".

Try to figure out the radio and phone in a 2014 Chevy and you might change your analogy!

jgarry wrote:

Try to figure out the radio and phone in a 2014 Chevy and you might change your analogy! 

Okay, pardon me if I didn't get it but not really a big fan of Chevy anyways . So if Ed agrees, can we switch over to 2014 Range Rover please ?

Regards

Aman....

Search for the word "integration" here  2014 Range Rover Sport review - Page 2 - CNET

As far as the Chevy, they give you a training session how to use the radio.  If you don't take the training, it takes a while to figure out what all these buttons do http://www.blogcdn.com/www.autoblog.com/media/2010/12/lead17-2011-chevrolet-cruze-1lt.jpg

(my tech-averse wife couldn't figure it out at all).

jgarry wrote:

Search for the word "integration" here  2014 Range Rover Sport review - Page 2 - CNET


As far as the Chevy, they give you a training session how to use the radio.  If you don't take the training, it takes a while to figure out what all these buttons do http://www.blogcdn.com/www.autoblog.com/media/2010/12/lead17-2011-chevrolet-cruze-1lt.jpg
(my tech-averse wife couldn't figure it out at all).

Okay searching for "integration" and that's a shame that RR doesn't really do it very nicely . And for Chevy, if one needs training to use Radio, that's like going from 8i to straight 12.2 and 10 patches applied .

Regards

Aman....

I downloaded Oracle 12c for Microsoft Windows, there are 2 zip files with name of winx64_12c_database_1of2 & winx64_12c_database_2of2. When I unzip the first one, there is a folder winx64_12c_database_1of2 within which there is a database folder. On unzipping the 2nd zip file, the folder structure is winx64_12c_database_2of2 within which also there is a database folder. I query is that do we need to place both the zip files in 1 folder which does not seem possible as both the zip files have a common folder, database or do we give the path of the parent directory and within which we have the folders winx64_12c_database_1of2 & winx64_12c_database_2of2. Something like parent folder named 'Oracle' within which we have the folders winx64_12c_database_1of2 & winx64_12c_database_2of2 and we give the path of parent folder 'Oracle' as the location of the source.

I hope my query is clear.

Please revert.

Regards

Hi,

Below directions are also from the same page where you downloaded from Oracle Database 12c Release 1 for Microsoft Windows (x64)

Directions

  1. All files are in the .zip format. There is an unzip utility here if you need one.

  2. Download and unzip both files to the same directory.

  3. Installation guides and general Oracle Database 12c documentation are here.

Regards

Yoonas

There would be just one folder only created-database. In that only, there would be an installer that you are supposed to run.

Aman....

Thanks for your answer but my question was different which I guess you have probably answered. So the directory structure could be as below:

1) The parent directory say as an folder Oracle12c at level 0, I mean as the root.

2) The parent directory would have 2 directories under it named winx64_12c_database_1of2 & winx64_12c_database_2of2 created by way of unzipping each zip file respectively.

Request you to please confirm on this.

Regards

Guess you are using  extract to 'folder_name' option, you have to extract both zip files to same parent folder.

Extract  first zip file

extract second zip using option extract files and select previoulsy extracted foldername

so that you will have one database folder with all files

Message was edited by: yoonas

Thanks for your answer but there are 2 zip files as seen in the link Oracle Database Software Downloads | Oracle Technology Network | Oracle

When each of the files is unzipped, there is a directory named databases in each. I agree that there is only 1 setup.exe. So the directory structure could be as below for extracting from the zip files:

1) The parent directory say as an folder Oracle12c at level 0, I mean as the root.

2) The parent directory would have 2 directories under it named winx64_12c_database_1of2 & winx64_12c_database_2of2 created by way of unzipping each zip file respectively.

I hope my query is clear.

Requesting a reply on this.

Regards

975148 wrote:

Thanks for your answer but there are 2 zip files as seen in the link Oracle Database Software Downloads | Oracle Technology Network | Oracle 

When each of the files is unzipped, there is a directory named databases in each. I agree that there is only 1 setup.exe. So the directory structure could be as below for extracting from the zip files:

1) The parent directory say as an folder Oracle12c at level 0, I mean as the root.
2) The parent directory would have 2 directories under it named winx64_12c_database_1of2 & winx64_12c_database_2of2 created by way of unzipping each zip file respectively.


I hope my query is clear.


Requesting a reply on this.

Regards

Do you mean that there should be two folders created ? Why? Are you not getting the single database folder? Don't get into what would have been done. In the single folder database, the setup is available which you are supposed to use.

Aman....

very well explained . Now op must be very clear about extracting and finally having only one "database" folder

Hi,

I tried in a similar way as you had mentioned, while extracting 2nd zip file it gives a prompt like whether to merge the  folder, database from the 2nd zip with the database folder from the 1st zip. Yes has to said in that. I hope, my understanding is correct in this?

Requesting a reply.

I tried out as EdStevens mentioned and I have put the details in my reply. I hope, it is in the right direction now?

Requesting a reply.

Yes, after extraction you should have a folder called "database", You can check database folder size as well.

975148 wrote:

I tried out as EdStevens mentioned and I have put the details in my reply. 

Which reply?  Do you really expect us to go back through this thread trying to spot what you changed in an earlier post?

I hope, it is in the right direction now?

Well, what happens when you try to use it?

Requesting a reply.

I downloaded Oracle 12c for Microsoft Windows, there are 2 zip files with name of winx64_12c_database_1of2 & winx64_12c_database_2of2. When I unzip the first one, there is a folder winx64_12c_database_1of2 within which there is a database folder. On unzipping the 2nd zip file, the folder structure is winx64_12c_database_2of2 within which also there is a database folder. I query is that do we need to place both the zip files in 1 folder which does not seem possible as both the zip files have a common folder, database or do we give the path of the parent directory and within which we have the folders winx64_12c_database_1of2 & winx64_12c_database_2of2. Something like parent folder named 'Oracle' within which we have the folders winx64_12c_database_1of2 & winx64_12c_database_2of2 and we give the path of parent folder 'Oracle' as the location of the source.

It does NOT matter where you place the two zip files.

Just unzip both of them to the SAME folder: e.g. /folder1/folder2/folder3/database/

The result will be ONE folder named 'database' that will have ALL files from both zip files in it.