Prev: what does dbms_stat.gather_database_stats_job_proc do?
Next: dbora not start automatically database
From: Keith on 7 May 2007 15:51
On May 7, 2:51 pm, JMecc <j...(a)telus.net> wrote:
> I find no such script (changePerm.sh) in the $ORACLE_HOME/install
> directory, nor with find:
>
> bash-3.00$ find -name changePerm*
> bash-3.00$ find -name *Perm*
> ./sysman/admin/scripts/db/ohFilesPerm.pl
> ./sysman/admin/scripts/db/ohExeBinPerm.pl
> ./sysman/admin/scripts/db/iFileRefPerm.pl
> ./sysman/admin/scripts/db/dbAuditPerm.pl
> ./sysman/admin/scripts/db/dbDataFilePerm.pl
> ./sysman/admin/scripts/db/dbInitParamFilesPerm.pl
> ./sysman/admin/scripts/db/dbControlFilesPerm.pl
> ./oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
> jaznPrincipalPerms.uix
> ./oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
> jaznGranteePerm.uix
> ./oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
> jaznPermissionMgt.uix
> ./oc4j/j2ee/oc4j_applications/applications/em/em/euser/jazn/
> jaznNewGrantPermission.uix
> ./jdk/demo/plugin/jfc/SwingSet2/src/Permuter.java
> ./jdk/demo/jfc/SwingSet2/src/Permuter.java
> bash-3.00$ find -name *change*
> ./sysman/admin/scripts/db/changeStateJob.pl
> ./sysman/admin/emdrep/sql/db/latest/changemgr
> ./assistants/dbca/doc/help/dbcaasm_change_disk_discovery_path.html
> ./oc4j/j2ee/oc4j_applications/applications/em/em/images/database/sql/
> changeditemicon_status.gif
> ./nls/data/old/data_changes.htm
>
> Could you open it and check which files are affected?
> Jonathan

Was your install successful? I think you can get it as part of a bug
patch from metalink... depending on your version.

Bug 4516865 - Wrong Permissions After Installation In Oh And
Subsequent Directories
Bug 5087548 - Post 10.2.0.2 Permissions Are Still Wrong For Network/
Admin And Ldap Directories

From: JMecc on 7 May 2007 18:34
OK it finally works. Apparently $ORACLE_HOME used to be visible to
everyone but was changed to private in version 9.2.0.7 due to some
wanting to keep all non-dba users from accessing the server side of
the database (they can apparently still access it from the client
side). The workaround is to set the permissions before running the
root.sh script at the end of installation (I just re-ran it after
chmod) and changing the permission on the oracle executable
separately:

chmod -R 755 $ORACLE_HOME
$ORACLE_HOME/root.sh

The above is the solution from Bug 4516865, which allows sqlplus to
start but refuses your login due to :
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 13: Permission denied

so the permission on the oracle executable has to be changed (per
http://www.lazydba.com/oracle/0__75539.html)

cd $ORACLE_HOME/bin
chmod 6751 oracle

Thanks very much for the replies!
Jonathan

First  |  Prev  | 
Pages: 1 2 3
Prev: what does dbms_stat.gather_database_stats_job_proc do?
Next: dbora not start automatically database