How to solve ORA-39710 problemEncountering exception ORA-01555Atypical problem with ORA-01445RMAN rename...
Fair gambler's ruin problem intuition
Different meanings of こわい
How does a dynamic QR code work?
Does the Cone of Cold spell freeze water?
Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?
Implication of namely
Using "tail" to follow a file without displaying the most recent lines
What is the opposite of "eschatology"?
how do we prove that a sum of two periods is still a period?
How could indestructible materials be used in power generation?
Mathematica command that allows it to read my intentions
Can someone clarify Hamming's notion of important problems in relation to modern academia?
Does the Idaho Potato Commission associate potato skins with healthy eating?
Placement of More Information/Help Icon button for Radio Buttons
What do you call someone who asks many questions?
Is it possible to map the firing of neurons in the human brain so as to stimulate artificial memories in someone else?
Does Dispel Magic work on Tiny Hut?
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
What exactly is ineptocracy?
One verb to replace 'be a member of' a club
files created then deleted at every second in tmp directory
Night of Shab e Meraj
Forgetting the musical notes while performing in concert
My ex-girlfriend uses my Apple ID to log in to her iPad. Do I have to give her my Apple ID password to reset it?
How to solve ORA-39710 problem
Encountering exception ORA-01555Atypical problem with ORA-01445RMAN rename datafile created in an archivelogHow to find out the segment behind a corrupted block when the database cannot be opened?How to solve database is not mountedCount is slow OracleHow to solve ORA-01157 error?Oracle 12 startup issue: disk full?How to solve repetitive ORA-2391 error in DBeaver 4.3.3.1Oracle 12 Startup upgrade throws error 443
I've got an Oracle 10.2 database that I need to get up and running. I've googled but now I've run into a problem I don't know how to solve.
I've been told the database is a bit FUBAR, so expect many strange things...
Here is what I've done so far.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Apr 7
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Then I check the alert.log
Successful open of redo thread 1
Fri Apr 07 01:53:24 EDT 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 07 01:53:24 EDT 2017
Errors in file /ora/product/10.2.0/db_1/admin/ora10/udump/ora10_ora_3031.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 3031
ORA-1092 signalled during: ALTER DATABASE OPEN...
And in the mentioned error file:
*** ACTION NAME:() 2017-04-07 01:53:24.252
*** MODULE NAME:(sqlplus@rh59 (TNS V1-V3)) 2017-04-07 01:53:24.252
*** SERVICE NAME:() 2017-04-07 01:53:24.252
*** SESSION ID:(159.3) 2017-04-07 01:53:24.251
Thread 1 checkpoint: logseq 29, block 2, scn 1119103
start recovery at logseq 29, block 2, scn 1119103
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.14s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.00111380 (1119104)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2017-04-07 01:53:24.398
KCRA: start recovery claims for 0 data blocks
*** 2017-04-07 01:53:24.398
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2017-04-07 01:53:24.398
Recovery of Online Redo Log: Thread 1 Group 1 Seq 29 Reading mem 0
*** 2017-04-07 01:53:24.398
Completed redo application
*** 2017-04-07 01:53:24.398
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
So I try UPGRADE
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
Fine! Lets create a user
SQL> CREATE USER foo IDENTIFIED BY "bar";
User created.
SQL> grant create session to foo;
Grant succeeded.
And then
$ sqlplus foo/bar
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Google tells me to do
$ sqlplus / as sysdba
SQL> alter system disable restricted session;
System altered.
And then
$ sqlplus foo/bar
ERROR:
ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
Now what?
I tried to do
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
I check the alert log and the referenced file tell me (again)
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Now what? shutdown/startup was not the solution. And I guess startup upgrade will just give me another 39710 error? How can I fix this?
oracle oracle-10g
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
add a comment |
I've got an Oracle 10.2 database that I need to get up and running. I've googled but now I've run into a problem I don't know how to solve.
I've been told the database is a bit FUBAR, so expect many strange things...
Here is what I've done so far.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Apr 7
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Then I check the alert.log
Successful open of redo thread 1
Fri Apr 07 01:53:24 EDT 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 07 01:53:24 EDT 2017
Errors in file /ora/product/10.2.0/db_1/admin/ora10/udump/ora10_ora_3031.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 3031
ORA-1092 signalled during: ALTER DATABASE OPEN...
And in the mentioned error file:
*** ACTION NAME:() 2017-04-07 01:53:24.252
*** MODULE NAME:(sqlplus@rh59 (TNS V1-V3)) 2017-04-07 01:53:24.252
*** SERVICE NAME:() 2017-04-07 01:53:24.252
*** SESSION ID:(159.3) 2017-04-07 01:53:24.251
Thread 1 checkpoint: logseq 29, block 2, scn 1119103
start recovery at logseq 29, block 2, scn 1119103
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.14s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.00111380 (1119104)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2017-04-07 01:53:24.398
KCRA: start recovery claims for 0 data blocks
*** 2017-04-07 01:53:24.398
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2017-04-07 01:53:24.398
Recovery of Online Redo Log: Thread 1 Group 1 Seq 29 Reading mem 0
*** 2017-04-07 01:53:24.398
Completed redo application
*** 2017-04-07 01:53:24.398
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
So I try UPGRADE
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
Fine! Lets create a user
SQL> CREATE USER foo IDENTIFIED BY "bar";
User created.
SQL> grant create session to foo;
Grant succeeded.
And then
$ sqlplus foo/bar
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Google tells me to do
$ sqlplus / as sysdba
SQL> alter system disable restricted session;
System altered.
And then
$ sqlplus foo/bar
ERROR:
ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
Now what?
I tried to do
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
I check the alert log and the referenced file tell me (again)
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Now what? shutdown/startup was not the solution. And I guess startup upgrade will just give me another 39710 error? How can I fix this?
oracle oracle-10g
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
How you ran into this situation? Was the last upgrade failed or something else?
– JSapkota
Apr 7 '17 at 6:43
Not realy sure, I think it was restored from some kind of backup.
– FORTRAN
Apr 7 '17 at 6:49
add a comment |
I've got an Oracle 10.2 database that I need to get up and running. I've googled but now I've run into a problem I don't know how to solve.
I've been told the database is a bit FUBAR, so expect many strange things...
Here is what I've done so far.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Apr 7
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Then I check the alert.log
Successful open of redo thread 1
Fri Apr 07 01:53:24 EDT 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 07 01:53:24 EDT 2017
Errors in file /ora/product/10.2.0/db_1/admin/ora10/udump/ora10_ora_3031.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 3031
ORA-1092 signalled during: ALTER DATABASE OPEN...
And in the mentioned error file:
*** ACTION NAME:() 2017-04-07 01:53:24.252
*** MODULE NAME:(sqlplus@rh59 (TNS V1-V3)) 2017-04-07 01:53:24.252
*** SERVICE NAME:() 2017-04-07 01:53:24.252
*** SESSION ID:(159.3) 2017-04-07 01:53:24.251
Thread 1 checkpoint: logseq 29, block 2, scn 1119103
start recovery at logseq 29, block 2, scn 1119103
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.14s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.00111380 (1119104)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2017-04-07 01:53:24.398
KCRA: start recovery claims for 0 data blocks
*** 2017-04-07 01:53:24.398
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2017-04-07 01:53:24.398
Recovery of Online Redo Log: Thread 1 Group 1 Seq 29 Reading mem 0
*** 2017-04-07 01:53:24.398
Completed redo application
*** 2017-04-07 01:53:24.398
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
So I try UPGRADE
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
Fine! Lets create a user
SQL> CREATE USER foo IDENTIFIED BY "bar";
User created.
SQL> grant create session to foo;
Grant succeeded.
And then
$ sqlplus foo/bar
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Google tells me to do
$ sqlplus / as sysdba
SQL> alter system disable restricted session;
System altered.
And then
$ sqlplus foo/bar
ERROR:
ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
Now what?
I tried to do
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
I check the alert log and the referenced file tell me (again)
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Now what? shutdown/startup was not the solution. And I guess startup upgrade will just give me another 39710 error? How can I fix this?
oracle oracle-10g
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
I've got an Oracle 10.2 database that I need to get up and running. I've googled but now I've run into a problem I don't know how to solve.
I've been told the database is a bit FUBAR, so expect many strange things...
Here is what I've done so far.
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Apr 7
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Then I check the alert.log
Successful open of redo thread 1
Fri Apr 07 01:53:24 EDT 2017
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Apr 07 01:53:24 EDT 2017
Errors in file /ora/product/10.2.0/db_1/admin/ora10/udump/ora10_ora_3031.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 3031
ORA-1092 signalled during: ALTER DATABASE OPEN...
And in the mentioned error file:
*** ACTION NAME:() 2017-04-07 01:53:24.252
*** MODULE NAME:(sqlplus@rh59 (TNS V1-V3)) 2017-04-07 01:53:24.252
*** SERVICE NAME:() 2017-04-07 01:53:24.252
*** SESSION ID:(159.3) 2017-04-07 01:53:24.251
Thread 1 checkpoint: logseq 29, block 2, scn 1119103
start recovery at logseq 29, block 2, scn 1119103
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.14s => 0.00 Mb/sec
Total physical reads: 4096Kb
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0000.00111380 (1119104)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2017-04-07 01:53:24.398
KCRA: start recovery claims for 0 data blocks
*** 2017-04-07 01:53:24.398
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2017-04-07 01:53:24.398
Recovery of Online Redo Log: Thread 1 Group 1 Seq 29 Reading mem 0
*** 2017-04-07 01:53:24.398
Completed redo application
*** 2017-04-07 01:53:24.398
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
So I try UPGRADE
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
Fine! Lets create a user
SQL> CREATE USER foo IDENTIFIED BY "bar";
User created.
SQL> grant create session to foo;
Grant succeeded.
And then
$ sqlplus foo/bar
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Google tells me to do
$ sqlplus / as sysdba
SQL> alter system disable restricted session;
System altered.
And then
$ sqlplus foo/bar
ERROR:
ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
Now what?
I tried to do
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 914358272 bytes
Fixed Size 2100520 bytes
Variable Size 230687448 bytes
Database Buffers 675282944 bytes
Redo Buffers 6287360 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
I check the alert log and the referenced file tell me (again)
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Now what? shutdown/startup was not the solution. And I guess startup upgrade will just give me another 39710 error? How can I fix this?
oracle oracle-10g
oracle oracle-10g
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
asked Apr 7 '17 at 6:21
FORTRANFORTRAN
4819
4819
How you ran into this situation? Was the last upgrade failed or something else?
– JSapkota
Apr 7 '17 at 6:43
Not realy sure, I think it was restored from some kind of backup.
– FORTRAN
Apr 7 '17 at 6:49
add a comment |
How you ran into this situation? Was the last upgrade failed or something else?
– JSapkota
Apr 7 '17 at 6:43
Not realy sure, I think it was restored from some kind of backup.
– FORTRAN
Apr 7 '17 at 6:49
How you ran into this situation? Was the last upgrade failed or something else?
– JSapkota
Apr 7 '17 at 6:43
How you ran into this situation? Was the last upgrade failed or something else?
– JSapkota
Apr 7 '17 at 6:43
Not realy sure, I think it was restored from some kind of backup.
– FORTRAN
Apr 7 '17 at 6:49
Not realy sure, I think it was restored from some kind of backup.
– FORTRAN
Apr 7 '17 at 6:49
add a comment |
2 Answers
2
active
oldest
votes
39700, 00000, "database must be opened with UPGRADE option"
*Cause: A normal database open was attempted, but the database has not
been upgraded to the current server version.
*Action: Use the UPGRADE option when opening the database to run
catupgrd.sql (for database upgrade), or to run catalog.sql
and catproc.sql (after initial database creation).
After SQL> startup upgrade, run the catupgrd.sql(if you were upgrading the database). The file can be found under $ORACLE_HOME/rdbms/admin directory.
After the completion it's execution SQL>shut immediate then SQL>startup then run SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sqlto recompile invalid database objects.
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
Current SQL statement for this session:begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;
– FORTRAN
Apr 7 '17 at 6:56
Make sure that your$ORACLE_HOMEand$PATHis set properly to point to the correct home.
– JSapkota
Apr 7 '17 at 6:58
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
|
show 2 more comments
sql> startup upgrade
give this command and your DB will start.
answered 44 secs ago
rifat khandkerrifat khandker
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f169403%2fhow-to-solve-ora-39710-problem%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
39700, 00000, "database must be opened with UPGRADE option"
*Cause: A normal database open was attempted, but the database has not
been upgraded to the current server version.
*Action: Use the UPGRADE option when opening the database to run
catupgrd.sql (for database upgrade), or to run catalog.sql
and catproc.sql (after initial database creation).
After SQL> startup upgrade, run the catupgrd.sql(if you were upgrading the database). The file can be found under $ORACLE_HOME/rdbms/admin directory.
After the completion it's execution SQL>shut immediate then SQL>startup then run SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sqlto recompile invalid database objects.
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
Current SQL statement for this session:begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;
– FORTRAN
Apr 7 '17 at 6:56
Make sure that your$ORACLE_HOMEand$PATHis set properly to point to the correct home.
– JSapkota
Apr 7 '17 at 6:58
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
|
show 2 more comments
39700, 00000, "database must be opened with UPGRADE option"
*Cause: A normal database open was attempted, but the database has not
been upgraded to the current server version.
*Action: Use the UPGRADE option when opening the database to run
catupgrd.sql (for database upgrade), or to run catalog.sql
and catproc.sql (after initial database creation).
After SQL> startup upgrade, run the catupgrd.sql(if you were upgrading the database). The file can be found under $ORACLE_HOME/rdbms/admin directory.
After the completion it's execution SQL>shut immediate then SQL>startup then run SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sqlto recompile invalid database objects.
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
Current SQL statement for this session:begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;
– FORTRAN
Apr 7 '17 at 6:56
Make sure that your$ORACLE_HOMEand$PATHis set properly to point to the correct home.
– JSapkota
Apr 7 '17 at 6:58
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
|
show 2 more comments
39700, 00000, "database must be opened with UPGRADE option"
*Cause: A normal database open was attempted, but the database has not
been upgraded to the current server version.
*Action: Use the UPGRADE option when opening the database to run
catupgrd.sql (for database upgrade), or to run catalog.sql
and catproc.sql (after initial database creation).
After SQL> startup upgrade, run the catupgrd.sql(if you were upgrading the database). The file can be found under $ORACLE_HOME/rdbms/admin directory.
After the completion it's execution SQL>shut immediate then SQL>startup then run SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sqlto recompile invalid database objects.
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
39700, 00000, "database must be opened with UPGRADE option"
*Cause: A normal database open was attempted, but the database has not
been upgraded to the current server version.
*Action: Use the UPGRADE option when opening the database to run
catupgrd.sql (for database upgrade), or to run catalog.sql
and catproc.sql (after initial database creation).
After SQL> startup upgrade, run the catupgrd.sql(if you were upgrading the database). The file can be found under $ORACLE_HOME/rdbms/admin directory.
After the completion it's execution SQL>shut immediate then SQL>startup then run SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sqlto recompile invalid database objects.
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
answered Apr 7 '17 at 6:29
JSapkotaJSapkota
7,5861823
7,5861823
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
Current SQL statement for this session:begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;
– FORTRAN
Apr 7 '17 at 6:56
Make sure that your$ORACLE_HOMEand$PATHis set properly to point to the correct home.
– JSapkota
Apr 7 '17 at 6:58
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
|
show 2 more comments
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
Current SQL statement for this session:begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;
– FORTRAN
Apr 7 '17 at 6:56
Make sure that your$ORACLE_HOMEand$PATHis set properly to point to the correct home.
– JSapkota
Apr 7 '17 at 6:58
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
Thanks! Running catupgrd.sql went fine for most of the time, but then I got JVMRMACTION -------------------------------------------------------------------------------- FULL_REMOVAL ... begin if initjvmaux.startstep('LOAD_JIS_JARS') then * ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE And that is repeated a lot of times, and then: Enter value for locname:
– FORTRAN
Apr 7 '17 at 6:54
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
And in the log it says: ORA-07445: exception encountered: core dump [eokt2s_parse()+83] [SIGSEGV] [Address not mapped to object]
– FORTRAN
Apr 7 '17 at 6:55
Current SQL statement for this session:
begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;– FORTRAN
Apr 7 '17 at 6:56
Current SQL statement for this session:
begin if initjvmaux.startstep('LOAD_JIS_JARS') then dbms_java.loadjava('-noverify -resolve -synonym -grant PUBLIC lib/activation.jar lib/mail.jar'); initjvmaux.endstep; end if; end;– FORTRAN
Apr 7 '17 at 6:56
Make sure that your
$ORACLE_HOME and $PATH is set properly to point to the correct home.– JSapkota
Apr 7 '17 at 6:58
Make sure that your
$ORACLE_HOME and $PATH is set properly to point to the correct home.– JSapkota
Apr 7 '17 at 6:58
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
The variables seems to be correct, echo $ORACLE_HOME /ora/product/10.2.0/db_1 [oracle@rh59 ~]$ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/ora/product/10.2.0/db_1/bin unless they should point out some other oracle directory?
– FORTRAN
Apr 7 '17 at 7:07
|
show 2 more comments
sql> startup upgrade
give this command and your DB will start.
answered 44 secs ago
rifat khandkerrifat khandker
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
sql> startup upgrade
give this command and your DB will start.
answered 44 secs ago
rifat khandkerrifat khandker
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
sql> startup upgrade
give this command and your DB will start.
answered 44 secs ago
rifat khandkerrifat khandker
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
sql> startup upgrade
give this command and your DB will start.
answered 44 secs ago
rifat khandkerrifat khandker
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 44 secs ago
rifat khandkerrifat khandker
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 44 secs ago
rifat khandkerrifat khandker
1
answered 44 secs ago
rifat khandkerrifat khandker
1
1
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
rifat khandker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f169403%2fhow-to-solve-ora-39710-problem%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
How you ran into this situation? Was the last upgrade failed or something else?
– JSapkota
Apr 7 '17 at 6:43
Not realy sure, I think it was restored from some kind of backup.
– FORTRAN
Apr 7 '17 at 6:49