how to install Oracle 10.2.0.2 client on SPARC 1

[JazzGeek]

Hi All

I'm trying to find instructions on how to install Oracle 10.2.0.2 client on Solaris 10 SPARC.

It appears nothing exists on oracle website or on Google.

Does anyone know how, and where I can download, the oracle 10.2.0.2 client for Solaris 10 SPARC?

Thank you!!

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

Jazz, Although I have installed Oracle 10g many times on Solaris SPARC machines, I am not presently near such to insert the DVD and confirm the install options for you.

Whenever I have installed Oracle 10g on Solaris SPARC, my need was for the entire Enterprise Edition server, not for just the client, therefore I cannot confirm a "client-only" install option. There should be a "client-only" radio button to select, but if there is not, I recommend doing a minimal server install (i.e., standard edition), and select the "software-only" installation (i.e., no database creation). Any server install contains, by definition, a client install. You can then use that install as your Solaris SPARC client.

Also, to my knowledge, Oracle does not distribute any Oracle 10g software installation that is already patched to 10.2.0.2. You must install 10.2.0.1 (preferrably from the Oracle distribution DVD), then apply the patch set that brings it up to 10.2.0.2. (I believe that the most recent patch set is 10.2.0.3...is there a reason you do not want that version?)

Let us know your outcome,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Hi Mufasa

Do you have any idea where I would find the Oracle 10.2.0.1 client download? I've searched all through Oracle with no luck. They must be hiding it!!

Thank you

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[JazzGeek]

Okay, I found the oracle client install and I have installed it successfully.

Now, I need to bring it up to 10.2.0.2 (software requires only the 10.2.0.2 versoin).

Any idea how to apply the patchset to an oracle client??

Thanks

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

Yes, Seb, just apply the patch as you would to an Oracle Server...Since you will be applying the patch to the same $ORACLE_HOME in which your Oracle 10.2.0.1 client software resides, the patch will update those files to 10.2.0.2.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Thanks. That's a big help.

The Patch is asking me for the "oracle SID" but since it's a client install only, what do I put for the Oracle SID?

Thanks

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

That piece of information ("oracle SID") is extraneous in your case. When I patch to 10.2.0.x, I never have an Oracle SID since I create the database after the patch, so I have been in the same boat that you are now.

If it won't allow you to leave "oracle SID" empty, just use "ORCL". (I don't believe that it will actually apply that value anywhere.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Okay, thanks! I'll try it.

One last question:

How woudl I test the connection from the Oracle client server to the Oracle Database server to make sure it's configured correctly? (Yes, I'm a newbie!)

Thank you!


Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[JazzGeek]

Okay, I lied!

I have two last questions before I can install it:

1.) Do I have to run the postinstall script "catupgrd.sql" even though this is only a client install?

2.) How do I test the connection from the client install to the oracle database?

Thank you again!!

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

Let's call your newly patched computer "Machine 1". Here are the steps to ensure connectivity between Machine 1's Oracle 10g client and some database within your domain:

1) Locate another machine (let's call it Machine 2) that has:

a) the same operating system as Machine 1, and
b) an existing, working connection to an Oracle database on some other machine (which we'll call "Machine 3"). It doesn't matter whether Machine 2 has a client or a server install of Oracle.

2) Just to be sure of the connection, using Machine 2, successfully log into the target Oracle 10g database on Machine 3.

3) On Machine 2, change directory to its $ORACLE_HOME/network/admin (or %ORACLE_HOME%\network\admin if Windows) directory. In that directory, there should be a file named "tnsnames.ora". That file contains connectivity definitions to Oracle databases, including the one to which you just connected in Step 2, above. Copy that file over to Machine 1's $ORACLE_HOME/network/admin directory. (If, along with the tnsnames.ora file, that directory on Machine 2 also has files named "sqlnet.ora" and "protocol.ora", copy those files over with the "tnsnames.ora" file.)

4) On Machine 1, open up a SQL*Plus session and connect to the Oracle database on Machine 3, using the same, successful login information that you used in Step 2.

This confirms a successful connection from the new client to the remote Oracle database.

Let us know the outcome.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Thanks for taking the time with this.

Do you know if I still have to run the postinstall script:
"catupgrd.sql" on the oracle client as well?

Thanks

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

Since the "catupgrd.sql" script updates the database, you do not need/want to run that script on a client patch.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Okay, great thanks. I figured, but wasn't sure.

When I run:

sqlplus /nolog
connect internal

It prompts for password. I put it in.

I get this error:

ERROR:
ORA-12545: Connect failed because target host or object does not exist

is my sqlplus syntax correct? Or?

Thanks!!




Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

Sebastian,

First, the connection should be:

sqlplus /nolog
connect [b]/ as sysdba[/b]

...and using that connection:

1) you should be connecting for the purpose of starting up, shutting down, or conducting some other highly privileged "sysdba" activity,
2) it should occur on the machine upon which your database resides.
3) your machine log-in should be a member of the authorised DBA group.

If you are simply trying to connect to the Oracle 10g database as a non-SYSDBA user, then you should be able to do so on the client (or any other machine with the proper tnsnames.ora file) using this connection syntax:

sqlplus <username>/<password>@<tns-alias>

For example, I have (on my Oracle 10g database whose tnsnames.ora entry alias is "wacko") an Oracle user named "TEST" with a password of "YADA". To connect using these specifications, I would say:

sqlplus test/yada@wacko

Notice that user names and passwords are not case sensitive under normal conditions.

Let us know if this helps to resolve your issues.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Thanks. Worked like a charm!!

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer