Home » RDBMS Server » Enterprise Manager » viewing manually created Database through Web EM in 10G
viewing manually created Database through Web EM in 10G [message #189373] Thu, 24 August 2006 05:41 Go to next message
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 #189426 is a reply to message #189373] Thu, 24 August 2006 09:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you started the dbconsole?
Re: viewing manually created Database through Web EM in 10G [message #189502 is a reply to message #189373] Thu, 24 August 2006 22:39 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
When i give the command "emctl start dbconsole", it give me errorOC4j Configuration issue. D:\oracle\product\10.1.0\db_1oc4j\j2ee\oc4j_DbConsole_bms_bally not found.
Re: viewing manually created Database through Web EM in 10G [message #189767 is a reply to message #189502] Sat, 26 August 2006 20:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What you should do is launch dbca and go to the "Configure Database Options". Then go to the database page and select the database you created manually. Advance to the Management Options page and select "Configure the Database with Enterprise Manager" and "Use Database Control for Database Management".

Re: viewing manually created Database through Web EM in 10G [message #189835 is a reply to message #189767] Mon, 28 August 2006 01:06 Go to previous messageGo to next message
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 #189879 is a reply to message #189835] Mon, 28 August 2006 05:26 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did the logs (%ORACLE_HOME%\<hostname.domain>_<sid>\sysman\log) contain any additional information?
Re: viewing manually created Database through Web EM in 10G [message #189888 is a reply to message #189879] Mon, 28 August 2006 06:08 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
Well i could not infer much form that log. Log File attached here with.

Regards
Bally
Re: viewing manually created Database through Web EM in 10G [message #189893 is a reply to message #189888] Mon, 28 August 2006 06:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you able to resolve the hostname successfully with nslookup?
Re: viewing manually created Database through Web EM in 10G [message #189899 is a reply to message #189893] Mon, 28 August 2006 07:13 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
No I am not able to resolve through nslookup but when i do nbtstat-A hostname it returns me the ip and vice-versa.

Moreover if i ping my hostname it returns IP.

Regards
Bally
Re: viewing manually created Database through Web EM in 10G [message #189901 is a reply to message #189899] Mon, 28 August 2006 07:24 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to try and add an entry for the hostname in the local hosts file (C:\windows\system32\drivers\etc\hosts), then recreate the database control with:

c:\> set oracle_sid=bally
c:\> emca -config dbcontrol db -repos recreate
Re: viewing manually created Database through Web EM in 10G [message #189990 is a reply to message #189901] Mon, 28 August 2006 23:27 Go to previous messageGo to next message
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 #190126 is a reply to message #189990] Tue, 29 August 2006 05:48 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Apparently there is a difference between 10.1 & 10.2 emca parameters, it works for me on 10.2.

How many Oracle homes do you have on this node?
Re: viewing manually created Database through Web EM in 10G [message #190133 is a reply to message #190126] Tue, 29 August 2006 06:12 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
I have only one oracle home and that is "D:\oracle\product\10.1.0\db_1".
Re: viewing manually created Database through Web EM in 10G [message #190136 is a reply to message #190133] Tue, 29 August 2006 06:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you setting the ORACLE_HOME before you try to run emca?
Re: viewing manually created Database through Web EM in 10G [message #190262 is a reply to message #190136] Tue, 29 August 2006 22:58 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
No. I never set anything except Oracle_sid.

Regards
Re: viewing manually created Database through Web EM in 10G [message #190352 is a reply to message #190262] Wed, 30 August 2006 05:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
First, you may want to set the oracle_sid & oracle_home and try to run emca again. If it errors out, you may want to try and recreate the repository.

set oracle_sid=bally
set oracle_home=D:\oracle\product\10.1.0\db_1

%oracle_home%\sysman\admin\emdrep\bin\RepManager bms <repository_port> bally -sys_password <password_for_sys_account> -action drop

Remove any configuration files by running

emca -x

Then try to run emca again.
Re: viewing manually created Database through Web EM in 10G [message #190380 is a reply to message #190352] Wed, 30 August 2006 07:30 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
Hi

When i am giving the command "oracle_home%\sysman\admin\emdrep\bin\RepManager bms................
It gives me this error :->
'RepManager' is not recognized as an internal or external command

Thought RepManager is there in the said path.

Regards
B. Sharma
Re: viewing manually created Database through Web EM in 10G [message #190386 is a reply to message #190380] Wed, 30 August 2006 07:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You need to replace %oracle_home% with D:\oracle\product\10.1.0\db_1

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
Re: viewing manually created Database through Web EM in 10G [message #190464 is a reply to message #190386] Wed, 30 August 2006 22:39 Go to previous messageGo to next message
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
Re: viewing manually created Database through Web EM in 10G [message #190604 is a reply to message #190464] Thu, 31 August 2006 06:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you try to do a search to find RepManager ?
Re: viewing manually created Database through Web EM in 10G [message #190605 is a reply to message #190604] Thu, 31 August 2006 06:46 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
Hi

It is there on the location " D:\oracle\product\10.1.0\db_1\sysman\admin\emdrep\bin\RepManager"

I am out of the town today. I shall be back on monday to my data center and tell you about the status exactly.

Thanks for the Support which u are prividing.

Regards
Bally
Re: viewing manually created Database through Web EM in 10G [message #191363 is a reply to message #190605] Tue, 05 September 2006 23:17 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
Hi
I am back.

RepManager location is at D:\oracle\product\10.1.0\db_1\sysman\admin\emdrep\bin\RepManager.

What I have to write on <repository_port> ?

Regards
Re: viewing manually created Database through Web EM in 10G [message #191413 is a reply to message #191363] Wed, 06 September 2006 04:50 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
bmsharma wrote on Tue, 05 September 2006 23:17

What I have to write on <repository_port> ?

You can use any available port # (ie. 5051)
Re: viewing manually created Database through Web EM in 10G [message #191424 is a reply to message #191413] Wed, 06 September 2006 05:44 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
I mean whether i have to type this command as: ->

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
?
Re: viewing manually created Database through Web EM in 10G [message #191443 is a reply to message #191424] Wed, 06 September 2006 06:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
For example:

D:\oracle\product\10.1.0\db_1\sysman\admin\emdrep\bin\RepManager bms 5051 bally -sys_password oraclepass -action drop


Replace 5051 and oraclepass with whatever you need.
Re: viewing manually created Database through Web EM in 10G [message #191638 is a reply to message #191443] Thu, 07 September 2006 07:22 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
After Giving this command it gives me the error:-->

RepManager is not recognized as an internal or external command, operable program or batch file.
Re: viewing manually created Database through Web EM in 10G [message #191641 is a reply to message #191638] Thu, 07 September 2006 07:29 Go to previous messageGo to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
After Giving this command it gives me the error:-->

RepManager is not recognized as an internal or external command, operable program or batch file.

Though RepManager is in its location.
Re: viewing manually created Database through Web EM in 10G [message #213586 is a reply to message #191641] Thu, 11 January 2007 06:10 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
RepManager is not working properly in Oracle 10.1, it is fix in 10.1.0.3.0

Note :
http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_3.shtml


PS: Update this thread because of any future problem will not happen due to RepManager.


Regards
Taj
Previous Topic: How to install Enterprise Manager
Next Topic: Connect to 9i enterprise manager
Goto Forum:
  


Current Time: Sat Dec 10 07:18:59 CST 2016

Total time taken to generate the page: 0.09002 seconds