Posted on June 13, 2008 by June Lee
$nohup ./rmanbkp.sh
nohup: cannot run command ‘./rmanbkp.sh’: Permission denied
$chmod +x rmanbkp.sh
$nohup ./rmanbkp.sh
nohup: appending output to ‘nohup.out’
nohup: cannot run command ‘./rmanbkp.sh’: No such file or directory
The first line in rmanbkp.sh was
#!/usr/bin/sh
It might be a shell problem. Check ksh path
$which ksh
/bin/ksh
Change it to
#!/bin/ksh
Or, it might be a path problem. Check sh path
$which sh
/bin/sh
Change it to
#!/bin/sh
Reference:
1. http://docs.jach.hawaii.edu/JAC/JACUN/008.0/node42.html
2. http://www.gammon.com.au/forum/?id=8009&page=1
Filed under: Q & A | Tagged: nohup, Path, Shell | Leave a Comment »
Posted on June 13, 2008 by June Lee
$rman target / catalog
rman: can’t open target % ERROR INFO
Because there is another rman file in the system (use which to see the file location as follows). The ORACLE rman is in $ORACLE_HOME/bin.
$which rman
/usr/X11R6/bin/rman
Two ways to solve this problem:
1) Put $ORACLE_HOME/bin at the very beginning of $PATH in your environment
2) run [...]
Filed under: Q & A | Tagged: Path, RMAN | Leave a Comment »
Posted on June 11, 2008 by June Lee
Storage_Clause:
INITIAL
Specify in bytes the size of the object’s first extent. Oracle allocates space for this extent when you create the schema object. Use K or M to specify this size in kilobytes or megabytes.
The default value is the size of 5 data blocks. In tablespaces with manual segment-space management, the minimum value is the size [...]
Filed under: Concepts | Tagged: Local Managed Tablespace | Leave a Comment »
Posted on June 11, 2008 by June Lee
Some silly problems may incur everyday:
Wrong spelling. ex. “contraint” -> “constraint”
Missing parenthesis
Make sure all the commands in the scripts have the right path, for example, the RMAN case
Correct shell choice
Filed under: Q & A | Tagged: Common, Mistake, Problem | Leave a Comment »
Posted on June 11, 2008 by June Lee
Please see this file.
Reference:
1. http://forums.oracle.com/forums/thread.jspa?messageID=923473
Filed under: Study Materials | Tagged: Practice, Student Guide | Leave a Comment »
Posted on June 9, 2008 by June Lee
When we tried to change tablespace storage paramters in a DBCA created database, we may get the following error information because the storage settings for locally managed tablespaces cannot be altered.
ORA-25143: default storage clause is not compatible with allocation policy.
Or, if you want to create a tablespace dictionary managed, you might get this error information:
ORA-12913: [...]
Filed under: Q & A | Tagged: Database Creation, Space Management, Tablespace | Leave a Comment »
Posted on June 7, 2008 by June Lee
Oracle 9i Installation in Red Hat Enterprise Linux 4
Filed under: Uncategorized | Leave a Comment »
