You are installing on an unsupported operating system and something could go wrong. It is a standard practice to have at least two control file (normally three), so you need to identify the surviving control files and replace the missing one with one of the others. If you have lost only one of many control files, the procedure is different. But if you also have changed datafile locations you have to rename datafiles in mount mode. Then issue the command below:Īfter that, database will see controlfiles. (Its name is init.ora) Edit newly created pfile to correct controlfile locations. Then look under the directory of $ORACLE_HOME\database. (And probably it is not working right now.)įirst of all, create pfile from spfile by issuing this command: ORA-00205: error in identifying control file, check alert log for more infoĬause: The system could not find a control file of the specified name and size.Īction: Check that ALL control files are online and that they are the same files that the system created at cold start time. The oerr utility show this for the ORA-00205 error: What is the best way to re-create control file in the correct format and store it in the right place? "ORA-00205: error in identifying controlfile" SQL> SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name) FROM USER_INDEXES u ĬREATE UNIQUE INDEX "JOHNY"."SYS_C0013353" ON "JOHNY"."JOHNY_TABLE" ("ID")ĭifference between a user and a schema in Oracle? PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DE
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 SQL> SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) FROM USER_TABLES u To get DDL data you can use DBMS_METADATA package that "provides a way for you to retrieve metadata from the database dictionary as XML or creation DDL and to submit the XML to re-create the object.". SQL> insert into dev_table (id, text) values (1,'esto es un dato de prueba') Login as develop and check what privileges he has Temporary tablespace develop_tabspace_temp scripts resumidos y adaptados para usuario developĬreate temporaty tablespace develop_tabspace_tempĬreate user develop identified by betopass SQL> grant unlimited tablespace to develop SQL> create user develop identified by betopassģ temporary tablespace develop_tabspace_temp SQL> create temporary tablespace johny_tabspace_temp This transient data cannot be recovered after process or instance failure.): SQL> select tablespace_name from dba_tablespaces Ĭreate temporary tablespace (Temporaty tablespace is an allocation of space in the database that can contain transient data that persists only for the duration of a session. ORA-01045: user JOHNY lacks CREATE SESSION privilege logon denied If you try to login as develop now you would get an error: SQL> create user develop identified by betopass Se creará un usuario "develop" y schema "DEVELOP" para hacer desarrollo *** obtenidos del registry ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server Port for 'Oracle Services for Microsoft Transaction Server': 2030 Port for 'Oracle Database Listener': 1521 Oracle Home: C:\oraclexe\app\oracle\product\11.2.0\server\
0 kommentar(er)
