| 10GR2 creation is blocked on last version serveur 2003 R2 [message #251268] |
Thu, 12 July 2007 14:57  |
Haler
Messages: 71
Registered: October 2004
|
Member |
|
|
configuration:
-serveur HP proliant and windows 2003 R2 service pack 2
-first oracle 10.2.0.1 patch in 10.2.0.3
-then oracle 10.2.0.1
-then oracle 9.2.0.1
Hello,
I'm creating a new base 10.2.0.3 manually with scripts
I manage to create the files of the base but blocking of the server at the time of the closing of the base.
I must stop the server with the button go/stop
Impossible to start again the server.
I am obliged to reinstall OS !!!
the file sysman of the console is not created either.
What's occurs ?
problem similar with a base 10.2.0.1
I suspect of a bug with dB CONSOLE or JAVA
I try to create a base 9.2.0.1.
no problem until the moment to open the base.
then blocking again.
a help would be appreciated
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: 10GR2 creation is blocked on last version serveur 2003 R2 [message #251359 is a reply to message #251358] |
Fri, 13 July 2007 03:54  |
Haler
Messages: 71
Registered: October 2004
|
Member |
|
|
log installation JVM
SQL> -- Setup a database for running Java
SQL>
SQL> -- This script can not function properly in SVRMGR. The following
SQL> -- lines are intended to abort the script if it is being run with
SQL> -- SVRMGR, but will be interpreted simply as remarks by SQLPLUS.
SQL> rem -
> set stoponerror on
SQL> rem -
> initjvm.sql must be run with SQLPLUS, not SVRMGRL
SQL>
SQL>
SQL> whenever sqlerror exit;
SQL>
SQL> variable test_for_1335603 varchar2(30)
SQL>
SQL> /*
SQL> #######################################################################
SQL> #######################################################################
SQL> If the following :test_for_1335603 := 'x' statement causes
SQL> a PLS-00553 error, and thereby terminates the sqlplus connection,
SQL> simply restart the script in a new sqlplus session.
SQL> This error can occur if the script is run in the same session where
SQL> the database was started. To avoid this problem, always start a new
SQL> session to run scripts after starting the database.
SQL> #######################################################################
SQL> #######################################################################
SQL> */
SQL>
SQL> execute :test_for_1335603 := 'x';
BEGIN :test_for_1335603 := 'x'; END;
*
ERREUR à la ligne 1 :
ORA-06553: PLS-213: progiciel STANDARD inaccessible
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
