Home » RDBMS Server » Enterprise Manager » emca -x What happen? How to recover datbase.
emca -x What happen? How to recover datbase. [message #68935] Mon, 14 February 2005 19:33 Go to next message
Anil Khadka
Messages: 1
Registered: February 2005
Junior Member
I mistakely issue command emca -x <db-name>, i am loosing folder in /u01/app/oracle/product/10.1.0/Db_2/ .. When i start the database in sqlplus using startup then the database will mount but not open....But i have files
control01.ctl redo01.log sysaux01.dbf undotbs01.dbf
control02.ctl redo02.log system01.dbf users01.dbf
control03.ctl redo03.log temp01.dbf

in some folder... i know this is the main file... but how do i do the rest???
While issuing commnad emca... and after giving some parameter it issue error like:
[[oracle@fedora Db_2]]$ emca -a

STARTED EMCA at Tue Feb 15 10:16:14 NPT 2005
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: orcl
Service name: orcl
Email address for notification: asdf
Email gateway for notification: asdf
ASM ORACLE_HOME [[ /u01/app/oracle/product/10.1.0/Db_2 ]]:
ASM SID [[ +ASM ]]:
ASM port [[ 1521 ]]:
ASM user role [[ SYSDBA ]]:
ASM user name [[ SYS ]]:
ASM user password:
Password for dbsnmp:
Password for sysman:
Password for sys:

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/Db_2
Enterprise Manager ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/Db_2

Database host name ................ localhost.localdomain
Listener port number ................ 1521
Database SID ................ orcl
Service name ................ orcl
Email address for notification ............... asdf
Email gateway for notification ............... asdf
ASM ORACLE_HOME ................ /u01/app/oracle/product/10.1.0/Db_2
ASM SID ................ +ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM user name ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [[yes/no]]: yes
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig checkConfiguration
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig updateReposVars
INFO: Updating file /u01/app/oracle/product/10.1.0/Db_2/sysman/emdrep/config/repository.variables ...
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository. Repository creation could not be completed successfully
Feb 15, 2005 10:16:41 AM oracle.sysman.emcp.EMConfig perform
INFO: Please refer to the log file at /u01/app/oracle/product/10.1.0/Db_2/cfgtoollogs/emca_repos_create<DATE>.log for more details.
Could not complete the configuration. Refer to the log file for details

Any one Please help me, give me some hints...
Re: emca -x What happen? How to recover datbase. [message #108967 is a reply to message #68935] Sun, 20 February 2005 21:02 Go to previous message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
connect as sysdba/pwd as sysdba

sql> shutdown
sql> startup

check for the errors....
Previous Topic: database link (very urgent)
Next Topic: ORA-12638 occurs on database creation
Goto Forum:
  


Current Time: Wed May 18 17:30:15 CDT 2022