Ygthkb

我可不觉得 - agree or disagree?

How to play songs that contain one guitar when we have two or more guitarists?

How to achieve physical gender equality?

How bad is a Computer Science course that doesn't teach Design Patterns?

What does @ mean in a hostname in DNS configuration?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Badly designed reimbursement form. What does that say about the company?

Isn't a semicolon (';') needed after a function declaration in C++?

Will linear voltage regulator step up current?

80-bit collision resistence because of 80-bit x87 registers?

Is it ethical to apply for a job on someone's behalf?

How can changes in personality/values of a person who turned into a vampire be explained?

Are all power cords made equal?

Taking an academic pseudonym?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

What does an unprocessed RAW file look like?

Almost normal subgroups: Is there any notion which is weaker than normal subgroup?

Short story where Earth is given a racist governor who likes species of a certain color

Using font-relative distances in tikzpictures

Build ASCII Podiums

Is Screenshot Time-tracking Common?

Can "ee" appear in Latin?

How does the income of your target audience matter for logo design?

Is it common to refer to someone as "Prof. Dr. [LastName]"?

ORA-03114: not connected to ORACLE

“ORA-03113: end-of-file on communication channel” on startupORA-03113 when starting up an Oracle 11g databaseFailure to start instance resource on1 node of a 3 node of an Oracle 12c RACUnable to open database (Datafile corrupted)I got this error when am trying view dba_tables Ora 03113 end of file on communication channelIs Oracle 11g database supported in windows 10?Login into Oracle Database ErrorQuestion about “RMAN-06169:” and OracleOracle 9i import error IMP-00017: following statement failed with ORACLE error 3113Error ORA-03113: end-of-file on communication channel

0

I know what I did wrong! While migrating my database from one directory to another based on this amazing article
This, at the very last step (alter database rename file 'C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF'to 'D:EASYDBTEMP.DBF';) I had a semicolon after the file extensions wrongfully (alter database rename file 'C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF;'to 'D:EASYDBTEMP.DBF;';) and it didn't like it at all.

ERROR at line 1: ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
"C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF;" in the current container

and from there, it's

SQL> alter database open;

alter database open

`* ERROR at line 1:

ORA-03113: end-of-file on communication channel Process ID: 3896

Session ID: * Serial number: *

SQL> SELECT name FROM v$datafile;

ERROR: ORA-03114: not connected to

ORACLE

Shutdown is not possible, same goes to mount, alter, etc. Any idea what I should do the next? It's Oracle 12c, on Windows Server 2012 R2 (64).

---

Update

startup mount;

now I have another problem! when

alter database open;

it still gives me

ORA-03113: end-of-file on communication channel Process ID: 2712

Session ID: * Serial number: *

Thanks,

oracle oracle-12c migration

share|improve this question

edited 1 hour ago

Mohsen

asked 1 hour ago

MohsenMohsen

12

New contributor

Mohsen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what does the alert log say?
  
  – kevinsky
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for your comment. Where should I find it? BTW a simple startup mount solved the problem...
  
  – Mohsen
  1 hour ago
  

  
  
  
  

add a comment | 

0

I know what I did wrong! While migrating my database from one directory to another based on this amazing article
This, at the very last step (alter database rename file 'C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF'to 'D:EASYDBTEMP.DBF';) I had a semicolon after the file extensions wrongfully (alter database rename file 'C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF;'to 'D:EASYDBTEMP.DBF;';) and it didn't like it at all.

ERROR at line 1: ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
"C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF;" in the current container

and from there, it's

SQL> alter database open;

alter database open

`* ERROR at line 1:

ORA-03113: end-of-file on communication channel Process ID: 3896

Session ID: * Serial number: *

SQL> SELECT name FROM v$datafile;

ERROR: ORA-03114: not connected to

ORACLE

Shutdown is not possible, same goes to mount, alter, etc. Any idea what I should do the next? It's Oracle 12c, on Windows Server 2012 R2 (64).

---

Update

startup mount;

now I have another problem! when

alter database open;

it still gives me

ORA-03113: end-of-file on communication channel Process ID: 2712

Session ID: * Serial number: *

Thanks,

oracle oracle-12c migration

share|improve this question

edited 1 hour ago

Mohsen

asked 1 hour ago

MohsenMohsen

12

New contributor

Mohsen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what does the alert log say?
  
  – kevinsky
  1 hour ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for your comment. Where should I find it? BTW a simple startup mount solved the problem...
  
  – Mohsen
  1 hour ago
  

  
  
  
  

add a comment | 

I know what I did wrong! While migrating my database from one directory to another based on this amazing article
This, at the very last step (alter database rename file 'C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF'to 'D:EASYDBTEMP.DBF';) I had a semicolon after the file extensions wrongfully (alter database rename file 'C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF;'to 'D:EASYDBTEMP.DBF;';) and it didn't like it at all.

ERROR at line 1: ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file
"C:ORACLEXEAPPORACLEORADATAEASYTEMP.DBF;" in the current container

and from there, it's

SQL> alter database open;

alter database open

`* ERROR at line 1:

ORA-03113: end-of-file on communication channel Process ID: 3896

Session ID: * Serial number: *

SQL> SELECT name FROM v$datafile;

ERROR: ORA-03114: not connected to

ORACLE

Shutdown is not possible, same goes to mount, alter, etc. Any idea what I should do the next? It's Oracle 12c, on Windows Server 2012 R2 (64).

---

Update

startup mount;

now I have another problem! when

alter database open;

it still gives me

ORA-03113: end-of-file on communication channel Process ID: 2712

Session ID: * Serial number: *

Thanks,

oracle oracle-12c migration

share|improve this question

edited 1 hour ago

Mohsen

asked 1 hour ago

MohsenMohsen

12

New contributor

Mohsen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

startup mount;

alter database open;

share|improve this question

edited 1 hour ago

Mohsen

asked 1 hour ago

MohsenMohsen

12

New contributor

Mohsen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 1 hour ago

Mohsen

asked 1 hour ago

MohsenMohsen

12

New contributor

Mohsen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 hour ago

MohsenMohsen

12

New contributor

Mohsen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 hour ago

MohsenMohsen

12