| viewing manually created Database through Web EM in 10G [message #189373] |
Thu, 24 August 2006 05:41  |
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
|
Junior Member |
|
|
Hi All
I have manually created one database in oracle 10g using following script:-->
#################################################################
create database bally
user sys identified by oracle
user system identified by oracle
logfile group 1 ('D:\oracle\product\10.1.0\oradata\bally\redo01.log') size 10M,
group 2 ('D:\oracle\product\10.1.0\oradata\bally\redo02.log') size 10M,
group 3 ('D:\oracle\product\10.1.0\oradata\bally\redo03.log') size 10M
character set WE8ISO8859P1
datafile 'D:\oracle\product\10.1.0\oradata\bally\system01.dbf'
size 100M
autoextend off
extent management local
sysaux datafile 'D:\oracle\product\10.1.0\oradata\bally\sysaux01.dbf'
size 200M
autoextend off
undo tablespace undotbs1
datafile 'D:\oracle\product\10.1.0\oradata\bally\undotbs01.dbf'
size 50M
default temporary tablespace temp
tempfile 'D:\oracle\product\10.1.0\oradata\bally\temp01.dbf'
size 50M
archivelog;
#################################################################
After that i run post scripts to create data dictionary views.
Then I created the Listener for the created Database.
Everythig is running fine including the listener and database but
How can i view the database from Web Enterprise Manager.
Kindly Guide
Regards
Bally
|
|
|
|
|
|
|
|
|
|
| Re: viewing manually created Database through Web EM in 10G [message #189835 is a reply to message #189767] |
Mon, 28 August 2006 01:06  |
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
|
Junior Member |
|
|
Hi
I already tried that. It says that EM configuration failed due to following error:->
could not compleate the configuration refer to log file for details.
You can retry the configuration this database with Enterprise manager later by manually running d:\oracle\product\10.1.0\db_1\bin\emca.bat script.
When i am running the this script, i get same error.
Kindly help
Bally
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: viewing manually created Database through Web EM in 10G [message #189990 is a reply to message #189901] |
Mon, 28 August 2006 23:27 |
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
|
Junior Member |
|
|
Hi
When i give the command afer set oracle_sid=bally
emca -config dbcontrol db -repos recreate
It returns me the message which is given below:-->
Incorrect usage:
oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters]
Options:
-a :configure for an ASM database
-b :configure for automatic backup
-c :configure a cluster database
-d :run EMCA from within the development view
-e <node> :remove a node from the cluster
-f <file> :specify the file name that contains parameter values
-h :help
-m :configure for central mode
-n <node> :add a new node to the cluster
-r :skip creation of repository schema
-s :silent mode (no user prompts
-x <db> :deletion of a SID or DB
The script will prompt for any required data that is not specified in a configuration file. The script always prompts for all required passwords. If you use a configuration file, the file may contain any of the following specifications, as shown, with the specified values correctly filled in:
Parameters for single instance databases:
HOST=<Database hostname>
SID=<Database SID>
PORT=<Listener port number>
ORACLE_HOME=<Database ORACLE_HOME>
LISTENER=<Listener name>
HOST_USER=<Host user name for automatic backup>
HOST_USER_PWD=<Host user password for automatic backup>
BACKUP_HOUR=<Automatic backup hour in number>
BACKUP_MINUTE=<Automatic backup minute in number>
ARCHIVE_LOG=<Archive log>
EMAIL_ADDRESS=<Email address for automatic notification>
MAIL_SERVER_NAME=<Email gateway for automatic notification>
ASM_OH=<ASM ORACLE_HOME>
ASM_SID=<ASM SID>
ASM_PORT=<ASM port>
ASM_USER_ROLE=<ASM user role>
ASM_USER_NAME=<ASM user name>
ASM_USER_PWD=<ASM user password>
EM_HOME=<Enterprise Manager ORACLE_HOME>
DBSNMP_PWD=<Password for dbsnmp>
SYSMAN_PWD=<Password for sysman>
SYS_PWD=<Password for sys>
Parameters for cluster databses:
HOST=<Database Instance hostname>
PORT=<Listener port number>
LISTENER=<Listener name>
ORACLE_HOME=<Database ORACLE_HOME>
CLUSTER_NAME=<Cluster name>
DB_NAME=<Database name>
SERVICE_NAME=<Service name>
HOST_USER=<Host user name for automatic backup>
HOST_USER_PWD=<Host user password for automatic backup>
BACKUP_HOUR=<Automatic backup hour in number>
BACKUP_MINUTE=<Automatic backup minute in number>
ARCHIVE_LOG=<Archive log>
EMAIL_ADDRESS=<Email address for automatic notification>
MAIL_SERVER_NAME=<Email gateway for automatic notification>
ASM_OH=<ASM ORACLE_HOME>
ASM_PORT=<ASM port>
ASM_USER_ROLE=<ASM user role>
ASM_USER_NAME=<ASM user name>
ASM_USER_PWD=<ASM user password>
EM_HOME=<Enterprise Manager ORACLE_HOME>
DBSNMP_PWD=<Password for dbsnmp>
SYSMAN_PWD=<Password for sysman>
SYS_PWD=<Password for sys>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: viewing manually created Database through Web EM in 10G [message #190464 is a reply to message #190386] |
Wed, 30 August 2006 22:39 |
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
|
Junior Member |
|
|
Hi
Earlier, I did that way only ie. D:\oracle\product\10.1.0\db_1\sysman\admin\emdrep\bin\RepManager bms <repository_port> bally -sys_password <password_for_sys_account> -action drop
It gives me this error :->
'RepManager' is not recognized as an internal or external command
Regards
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
