Home » Infrastructure » Linux » SQL Plus no access (11.1.0.6. Linux Redhat 5.5)
SQL Plus no access [message #505315] Mon, 02 May 2011 06:35 Go to next message
juniorpeardba
Messages: 31
Registered: April 2011
Location: London
Member
I have 2 servers experiencing 2 different connection issues.

DCS01 - user dmadmin not working with SQLPLUS

[dmadmin@UKEDXDTMDCS01 ~]$ cd $ORACLE_HOME
-bash: cd: /home/oracle/app/oracle/product/11.1.0/client_1/: Permission denied

[dmadmin@UKEDXDTMDCS01 ~]$ id
uid=500(dmadmin) gid=500(dmadmin) groups=500(dmadmin),501(oinstall),502(dba)

[dmadmin@UKEDXDTMDCS01 ~]$ sqlplus /nolog
-bash: sqlplus: command not found
[dmadmin@UKEDXDTMDCS01 ~]$

On the same server with the user Oracle - All works fine

[dmadmin@UKEDXDTMDCS01 ~]$ su oracle
Password:
[oracle@UKEDXDTMDCS01 dmadmin]$ sqlplus /nolog

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.

SQL> exit

$ more /etc/group

dmadmin:x:500:
oinstall:x:501:dmadmin
dba:x:502:oracle,dmadmin

oracle environment variables:

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

DDBS01 - user dmadmin working with SQLPLUS

sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Mon May 2 11:29:21 2011

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

SQL> exit

[dmadmin@UKEDXDTMDDBS01 db_1]$ cd $ORACLE_HOME

[dmadmin@UKEDXDTMDDBS01 db_1]$ id
uid=501(dmadmin) gid=502(dmadmin) groups=500(oinstall),501(dba),502(dmadmin)

$ more /etc/group

oinstall:x:500:dmadmin
dba:x:501:oracle,dmadmin
dmadmin:x:502:


oracle environment variables:

ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/oracle/product/11.2.0/db_1/bin

What could be the issue here why O/S account dmadmin does not work on server DCS01?

Many thanks


Re: SQL Plus no access [message #505320 is a reply to message #505315] Mon, 02 May 2011 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
-bash: cd: /home/oracle/app/oracle/product/11.1.0/client_1/: Permission denied

Isn't that clear?

Regards
Michel
Re: SQL Plus no access [message #505321 is a reply to message #505320] Mon, 02 May 2011 07:20 Go to previous messageGo to next message
juniorpeardba
Messages: 31
Registered: April 2011
Location: London
Member
Hello,

No not really clear so does that mean I have to change all the permissions to the oracle files or change something in the /etc/group?

That was my question
Re: SQL Plus no access [message #505327 is a reply to message #505321] Mon, 02 May 2011 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute $ORACLE_HOME/install/changePerm.sh

Regards
Michel
Re: SQL Plus no access [message #505334 is a reply to message #505315] Mon, 02 May 2011 09:29 Go to previous messageGo to next message
juniorpeardba
Messages: 31
Registered: April 2011
Location: London
Member
thanks,

out of the office now, but will do so tomorrow and give you feedback.

Thanks again h
Re: SQL Plus no access [message #505367 is a reply to message #505315] Mon, 02 May 2011 12:29 Go to previous messageGo to next message
juniorpeardba
Messages: 31
Registered: April 2011
Location: London
Member
Hi,

I noticed this statement about changePerm.sh - can you confirm if this is true, as my Client install is 11.1.0.7.

The changePerm.sh file is no more available nor necessary for Oracle database server 11.1.0.x because in 11g, permissions under the Oracle Home (including "others") are set correctly/relaxed. (oracle note 834626.1)

thanks
Re: SQL Plus no access [message #505374 is a reply to message #505367] Mon, 02 May 2011 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If so, then you had a problem during install.

Regards
Michel
Re: SQL Plus no access [message #505380 is a reply to message #505315] Mon, 02 May 2011 13:10 Go to previous messageGo to next message
juniorpeardba
Messages: 31
Registered: April 2011
Location: London
Member
Hi,

log file from installation

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
Re: SQL Plus no access [message #505382 is a reply to message #505380] Mon, 02 May 2011 13:34 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe the original install, not the patchset one.

As it works on one server and not on the other then enumerate the differences between the two.

Regards
Michel
Re: SQL Plus no access [message #505384 is a reply to message #505380] Mon, 02 May 2011 13:36 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The Problem is in ORACLE_HOME /home/oracle/app/oracle/product/11.1.0/client_1.
This installation log is for ORACLE_HOME /home/oracle/product/11.1.0/db_1 (despite it being an patchset log, not the original installation log).
You also seem to have an additional ORACLE_HOME /u01/app/oracle/product/11.2.0

Also versions 11.1.0.6.0 and 11.2.0.2.0 floating around, with the mixed up upgrade from 11.1.0.6.0 to 11.1.0.7.0 in your other thread.

Why do you install Oracle sometimes in /home/oracle/app/, sometimes in /u01/app/ and sometimes in /home/? You should stick to ONE way to install it, not change it all the time.

A few questions:

1) Is this *still* only about a client install, no server installation?

If so you should pick ONE client version you want, and ONE path to install it to, and then follow the installation instructions to the letter, not run off in dozens of directions at once.
Re: SQL Plus no access [message #506243 is a reply to message #505315] Sat, 07 May 2011 05:31 Go to previous message
ashishs
Messages: 40
Registered: May 2011
Member

hey,
when u install oracle through root path then after login
through user then that time u change mode to give access to the user if not then use
[DCS01@localhost~]chmode -R 777 \ database path
[DCS01@localhost~]cd database
[DCS01@localhost~database~]. /runInstaller
now setup will run...


Previous Topic: ProC compilation
Next Topic: Script for rman backup status
Goto Forum:
  


Current Time: Mon Aug 03 05:18:07 CDT 2020