OraFAQ Forum: Server Administration » incorrect version of oracle

Home » RDBMS Server » Server Administration » incorrect version of oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

incorrect version of oracle [message #505016]

Thu, 28 April 2011 16:47

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

Hi,

I installed 11.1.0.6. on Linux RedHat 5.5. Then upgraded to 11.1.0.7. However when I issue sqlplus /nolog and do select banner from v$version it shows 11.1.0.6. Although the install and upgrade were successful. I wonder why it does not show 11.1.0.7. I upgraded using the installer and not dbua could this be the reason why?

No database has been created as yet

Many thanks

Report message to a moderator

Re: incorrect version of oracle [message #505017 is a reply to message #505016]

Thu, 28 April 2011 16:53

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Has the behaviour changed since version 10? There you can't do that unless you are connected.

oracle ~ $ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Do Apr 28 23:51:31 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

@> select banner from v$version;
SP2-0640: Not connected
@>

Can you also post the exact copy and paste of what you did?

And how was the installation problem solved by the way?

Report message to a moderator

Re: incorrect version of oracle [message #505024 is a reply to message #505016]

Thu, 28 April 2011 18:45

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

hi thank for the reply.

I am not sure if it has changed since version 10 all I am trying to do is verify the verion of sqlplus

I get the same message as you get only diff is ver 11.1.0.6
I would expect the sqlplus to say not connected as no db installed as yet

I also cannot post my copy as not in the office right now

thanks again

ps: the previous install problem was solved after I deinstalled and reinstalled again choosing admin option not only the client option

Report message to a moderator

Re: incorrect version of oracle [message #505026 is a reply to message #505024]

Thu, 28 April 2011 19:09

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Sure, just post when you are in the office again.

I'm curious whether you really installed the *server*, which would allow you to create a database, or just the "client with admin option", which is a client with administrative tools, but still not the server part of the software.

With the server software the "Main Options" should have been:

* Create and Configure a Database
* Install Database Software Only
* Upgrade an Existing Database

Not anything labelled with "Admin" anywhere in sight. Because of these subtle (to the casual eye) differences, and the many different ways thing can be installed it's almost impossible to figure a problem out only from a "description" of what happened, without the actual hard fact of a copy/paste of what actually really *does* happen.

Report message to a moderator

Re: incorrect version of oracle [message #505028 is a reply to message #505026]

Thu, 28 April 2011 20:18

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

hi

this is a client install not server. option 3 is admin option.

client for 11.1.0.6 and a patch for 11.1.0.7

used runinstaller to install binaries for 11.1.0.6 and again runinstaller for patch upgrade which
both were sucessful. variables all set, just curious why sql does not say 11.1.0.7

the app team will create the db as part of the app install

Report message to a moderator

Re: incorrect version of oracle [message #505083 is a reply to message #505028]

Fri, 29 April 2011 04:26

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, when you don't post WHERE and HOW it "says" it's 11.1.0.6 it's impossible to figure out, since my Crystal Ball is broken.

Report message to a moderator

Re: incorrect version of oracle [message #505112 is a reply to message #505024]

Fri, 29 April 2011 08:07

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

juniorpeardba wrote on Fri, 29 April 2011 00:45

I am not sure if it has changed since version 10 all I am trying to do is verify the verion of sqlplus

Surely the version of sqlplus is a)machine specific and therefore b) database independent? and finally c) shown when you load it

Or am I misunderstanding something?

Report message to a moderator

Re: incorrect version of oracle [message #505124 is a reply to message #505016]

Fri, 29 April 2011 10:19

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

Hi,

Unable to post confirmation as it is a bank Holiday in the UK today, but when you login to sqlplus
sqlplus /nolog -it will display the following:-

SQL*Plus: Release 11.1.0.6.0

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

@> select banner from v$version;
SP2-0640: Not connected

And not SQL*Plus 11.1.0.7 as I would expect having upgraded to 11.1.0.7. I think this may have occurred because I ran runInstaller to do the upgrade to 11.1.0.7. and not the dbua utility. I am just trying to confirm

Thanks

Report message to a moderator

Re: incorrect version of oracle [message #505155 is a reply to message #505124]

Fri, 29 April 2011 11:59

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Then the update of the client was not successful. (DBUA is nothing you should have to do, since that is for DATABASE updates, and you say you only have a client installed.)

So running runInstaller would be the right way to start, but something went wrong somewhere. What and where will be mentioned in the log file of the installation.

Report message to a moderator

Re: incorrect version of oracle [message #505169 is a reply to message #505016]

Fri, 29 April 2011 14:28

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

Hi,

I understand what you are saying, but the install only took minutes and again I saw no error/warning messages and the completion for both phases were successful. The directory structure has been created and the variables for oracle are all in place. Again, when I am in the office on Monday I will review the install log.

Could the issue be that there is no tnsnames.ora in \network\admin
Or do I not need a tnsnames if the database is not created?

thanks again

Report message to a moderator

Re: incorrect version of oracle [message #505301 is a reply to message #505169]

Mon, 02 May 2011 03:36

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Are you validating the sqlplus version? If so are you executing the sqlplus on the database server itself?

Report message to a moderator

Re: incorrect version of oracle [message #505309 is a reply to message #505016]

Mon, 02 May 2011 05:47

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

confirmation

SQL*Plus: Release 11.1.0.6.0 - Production on Mon May 2 11:43:48 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

As mentioned this is on the client server with only the client binaries installed, no database has yet been created. I am just curious why the version is not 11.1.0.7 as I have upgraded the Oracle client to 11.1.0.7

Report message to a moderator

Re: incorrect version of oracle [message #505311 is a reply to message #505309]

Mon, 02 May 2011 05:58

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

So you think you have successfully upgraded the client. Oracle thinks otherwise. In such cases I tend to believe Oracle, until I see the log of the successful upgrade.

Report message to a moderator

Re: incorrect version of oracle [message #505318 is a reply to message #505016]

Mon, 02 May 2011 06:47

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

Hello,

here are the results of the log file

more installActions2011-04-28_02-48-23PM.log
Using paramFile: /opt/oracle/Disk1/install/oraparam.ini

Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

************** Tail end of the same log file ********************
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:

INFO: SaveInvWCCE JRE files in Scratch :0
INFO: oracle.installer.mandatorySetup property is set to false, so skipping the execution of additional tools
INFO: oracle.installer.installUpdates property is set to false, so skipping the checking of updates
INFO: Config Initialize JRE files in Scratch :0
INFO: no env vars set, no envVars.properties file is generated
INFO: stage loc: /tmp/OraInstall2011-04-28_02-48-23PM/
INFO: Copying Aggr XML for: Oracle Configuration Manager
INFO: The given component oracle.sysman.ccr is installed as part of Additional Components
INFO: stage loc: /tmp/OraInstall2011-04-28_02-48-23PM/
INFO: Copying Aggr XML for: Oracle Database 11g Patch Set 1
INFO: The Top level Aggreage File = /home/oracle/product/11.1.0/db_1/inventory/ContentsXML/ConfigXML/oracle.patchset.db.11
_1_0_7_0.xml
INFO: Processing the merge for Top Level Component/Patchset : oracle.patchset.db
INFO: Aggregate file for top level comp = /home/oracle/product/11.1.0/db_1/inventory/ContentsXML/ConfigXML/oracle.patchset
.db.11_1_0_7_0.xml
INFO: Merging the Aggregates for action type : patch_set_configure for the patchset = oracle.sysman.ccr
INFO: To Top Comp ggregate Name : oracle.patchset.db adding reference of oracle.sysman.ccr
INFO: Namespace prefix 'agg' used but not declared.
INFO: cf session will be created for OH: /home/oracle/product/11.1.0/db_1/ TLAggr: oracle.patchset.db instancePath: invent
ory/ContentsXML/ConfigXML/
INFO: cf session for OH: /home/oracle/product/11.1.0/db_1/ TL Aggr: [oracle.patchset.db] instancePath: inventory/ContentsX
ML/ConfigXML/
INFO: aggr ref length : 3
INFO: cf session hashcode: 1792381350
INFO: cf session saved with key: OraDb11g_home1 oracle.patchset.db
INFO: cf session is ok
INFO: created and saved cf session for oh: OraDb11g_home1
INFO: passing params to cf
INFO: Handling the storing of variables for aggr name oracle.sysman.ccr
INFO: This variable s_OPSNodeInfoString is not added to the global context map
INFO: This variable b_isUNIX is not added to the global context map
INFO: This variable b_createResponseFile is not added to the global context map
INFO: This variable s_ps is not added to the global context map
INFO: This variable s_oraName is not added to the global context map
INFO: This variable s_ccrJarDestination is not added to the global context map
INFO: This variable b_rdbmsInstall is not added to the global context map
INFO: This variable b_localInstall is not added to the global context map
INFO: This variable b_doConfigCCR is not added to the global context map
INFO: This variable b_ccrUpgrade is not added to the global context map
INFO: This variable s_rspFilePath is not added to the global context map
INFO: This variable PROD_HOME is not added to the global context map
INFO: ORACLE_HOME is not settable, hence not setting the value
INFO: {Parameter:TOPLEVEL_COMPONENT in {Aggregate:OuiConfigVariables:1.0.0.0.0:common}}: Parameter data type is not compat
ible with the provided String Array.
INFO: passing params to cf done
INFO: done saving info by cf
INFO: This is a shared oracle home or remote nodes are null. No copy required.
INFO: cf session retrieved for key: OraDb11g_home1 oracle.patchset.db
INFO: Created a new file /home/oracle/product/11.1.0/db_1/cfgtoollogs/configToolAllCommands
INFO: Since the option is to overwrite the existing /home/oracle/product/11.1.0/db_1/cfgtoollogs/configToolAllCommands fil
e, backing it up
INFO: The backed up file name is /home/oracle/product/11.1.0/db_1/cfgtoollogs/configToolAllCommands.bak
INFO: RUN_RECOMMENDED_TOOLS FIRST is set to false
INFO: No of Recommended Tools0
INFO: No of ExitOnly Tools in this session: 0
INFO: cf session for perform has hashcode: 1792381350
INFO: detached tool list getting prepared fo comp: Oracle Database 11g Patch Set 1
INFO: cfsession hashcode for exit only tools: 1792381350
INFO: hashcode for action: 185058837
INFO: No of ExitOnly Tools: 0
INFO: saving exit only tools ...
INFO: no detached only tools in this session
INFO: exit-only tools are created in single installation
INFO: no. of sets of tools to be run: 0
INFO: ca page to be shown: false
INFO: exitonly tools to be excuted passed: 0
INFO:
*** End of Installation Page***
The installation of Oracle Database 11g Patch Set 1 was successful.
WARNING: Do you really want to exit?
INFO: User Selected: Yes/OK

If you want I can upload the entire file - but seems quite large to do so

Thanks again

Report message to a moderator

Re: incorrect version of oracle [message #505331 is a reply to message #505318]

Mon, 02 May 2011 09:08

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

OK, it seems the patch was installed successfully for ORACLE_HOME /home/oracle/product/11.1.0/db_1/.

What is the result of "which sqlplus"?

Report message to a moderator

Re: incorrect version of oracle [message #505482 is a reply to message #505016]

Tue, 03 May 2011 05:47

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

user dmadmin

dmadmin@UKEDXDTMDCS01 ~]$ which sqlplus
/usr/bin/which: no sqlplus in (/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/dmadmin/bin:/home/oracle/app/oracle/product/11.1.0/client_1/bin)
[dmadmin@UKEDXDTMDCS01 ~]$
[dmadmin@UKEDXDTMDCS01 ~]$ env|sort
_=/bin/env
CVS_RSH=ssh
DISPLAY=localhost:10.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/dmadmin
HOSTNAME=UKEDXDTMDCS01.peroot.com
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.1.0/client_1/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=dmadmin
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/dmadmin
ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/client_1
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/dmadmin/bin:/home/oracle/app/oracle/product/11.1.0/client_1/bin
PWD=/home/dmadmin
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
USER=dmadmin
XAUTHORITY=/home/dmadmin/.xautheVzXHX

user oracle

[dmadmin@UKEDXDTMDCS01 ~]$ su - oracle
Password:
[oracle@UKEDXDTMDCS01 ~]$ which sqlplus
~/app/oracle/product/11.1.0/client_1/bin/sqlplus
[oracle@UKEDXDTMDCS01 ~]$
[oracle@UKEDXDTMDCS01 ~]$ env|sort
_=/bin/env
CVS_RSH=ssh
DISPLAY=localhost:10.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=UKEDXDTMDCS01.peroot.com
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.1.0/client_1/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/client_1
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/app/oracle/product/11.1.0/client_1/bin
PWD=/home/oracle
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
USER=oracle
XAUTHORITY=/home/oracle/.xauthY5NGgS

so it is something to do with the variables belonging to dmadmin - but which one??

Many thanks

Report message to a moderator

Re: incorrect version of oracle [message #505484 is a reply to message #505482]

Tue, 03 May 2011 05:51

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

So the sqlplus that is used (because it is the one in the PATH ) is installed to ~/app/oracle/product/11.1.0/client_1/bin/sqlplus, but you applied the patchset to the one that is /home/oracle/product/11.1.0/db_1/bin/sqlplus

You should delete ALL oracle homes except one, and then change all environment variables to use THAT one.

Report message to a moderator

Re: incorrect version of oracle [message #505487 is a reply to message #505482]

Tue, 03 May 2011 06:17

juniorpeardba
Messages: 31
Registered: April 2011
Location: London

Member

Problem solved - cancel topic - many thanks for all your assistance
Also running Database at 11.1.0.7 and SQLPLUS at 11.1.0.7

Many thanks

Report message to a moderator

Previous Topic:	Few simple questions to the Masters.
Next Topic:	I need to import data to production database. The database details are not in tnsnames.ora.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 05:13:30 CDT 2024