Home » RDBMS Server » Server Administration » Web Console for Manually Created Database
Web Console for Manually Created Database [message #291221] Thu, 03 January 2008 07:37 Go to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
Hello,

I have created a oracle database manually on a 10gR2 windows 2003 and XP Platforms. How can I get the web console for the database created. Like when I use the DBCA I get a web console to manage the database. How can I get the same thing when I create the database manually.

Thanks
Re: Web Console for Manually Created Database [message #291277 is a reply to message #291221] Thu, 03 January 2008 10:46 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Again use DBCA to configure it with OEM.
Check Here

[Updated on: Thu, 03 January 2008 10:55]

Report message to a moderator

Re: Web Console for Manually Created Database [message #291284 is a reply to message #291221] Thu, 03 January 2008 11:28 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
Hi

I have got the enterprise manager console. I have done the installation with CD. I have got the web console for our database. But when I open it and enter the username and password it does not login. And in the DBCA I did not see anything with particular to creating the webconsole for databse.

Thanks
Re: Web Console for Manually Created Database [message #291285 is a reply to message #291284] Thu, 03 January 2008 11:35 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Do you get any error??
When you open DBCA..
1:Click on Configure Database Option.
2:Select the Database.
3:Check the box "Configure database with EM.
4:Next
5:Next......
Re: Web Console for Manually Created Database [message #291286 is a reply to message #291285] Thu, 03 January 2008 11:44 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
I do not get any error.

And when I got toDBCA - configure database options I do not see any box configure database with EM.

Thanks
Re: Web Console for Manually Created Database [message #291287 is a reply to message #291286] Thu, 03 January 2008 11:56 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you select the database after configure option?
Re: Web Console for Manually Created Database [message #291288 is a reply to message #291221] Thu, 03 January 2008 12:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Never mind

[Updated on: Thu, 03 January 2008 12:12] by Moderator

Report message to a moderator

Re: Web Console for Manually Created Database [message #291290 is a reply to message #291287] Thu, 03 January 2008 12:25 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
I have selected the database. I see many componenets are disabled. the Oracle JVM console is also disabled. Do I have to install any additonal components . During the inital installation the vendor did not install the EM console. Ihave done that now.

Thanks
Re: Web Console for Manually Created Database [message #291291 is a reply to message #291288] Thu, 03 January 2008 12:26 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
Hi

I am using the Oracle 10.2.0.3.0 on Windows 2003.
And trying to get a web console to an already created database.

Thanks
Re: Web Console for Manually Created Database [message #291406 is a reply to message #291291] Fri, 04 January 2008 02:01 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
One upon a time, you might create a database manually, like an example

Quote:


CREATE DATABASE rbdb1
CONTROLFILE REUSE
LOGFILE '/u01/oracle/rbdb1/redo01.log' SIZE 1M REUSE,
'/u01/oracle/rbdb1/redo02.log' SIZE 1M REUSE,
'/u01/oracle/rbdb1/redo03.log' SIZE 1M REUSE,
'/u01/oracle/rbdb1/redo04.log' SIZE 1M REUSE
DATAFILE '/u01/oracle/rbdb1/system01.dbf' SIZE 10M REUSE
AUTOEXTEND ON
NEXT 10M MAXSIZE 200M
CHARACTER SET WE8ISO8859P1;

-- Create another (temporary) system tablespace
CREATE ROLLBACK SEGMENT rb_temp STORAGE (INITIAL 100 k NEXT 250 k);

-- Alter temporary system tablespace online before proceding
ALTER ROLLBACK SEGMENT rb_temp ONLINE;

-- Create additional tablespaces ...
-- RBS: For rollback segments
-- USERs: Create user sets this as the default tablespace
-- TEMP: Create user sets this as the temporary tablespace
CREATE TABLESPACE rbs
DATAFILE '/u01/oracle/rbdb1/rbs01.dbf' SIZE 5M REUSE AUTOEXTEND ON
NEXT 5M MAXSIZE 150M;
CREATE TABLESPACE users
DATAFILE '/u01/oracle/rbdb1/users01.dbf' SIZE 3M REUSE AUTOEXTEND ON
NEXT 5M MAXSIZE 150M;
CREATE TABLESPACE temp
DATAFILE '/u01/oracle/rbdb1/temp01.dbf' SIZE 2M REUSE AUTOEXTEND ON
NEXT 5M MAXSIZE 150M;

-- Create rollback segments.
CREATE ROLLBACK SEGMENT rb1 STORAGE(INITIAL 50K NEXT 250K)
tablespace rbs;
CREATE ROLLBACK SEGMENT rb2 STORAGE(INITIAL 50K NEXT 250K)
tablespace rbs;
CREATE ROLLBACK SEGMENT rb3 STORAGE(INITIAL 50K NEXT 250K)
tablespace rbs;
CREATE ROLLBACK SEGMENT rb4 STORAGE(INITIAL 50K NEXT 250K)
tablespace rbs;

-- Bring new rollback segments online and drop the temporary system one
ALTER ROLLBACK SEGMENT rb1 ONLINE;
ALTER ROLLBACK SEGMENT rb2 ONLINE;
ALTER ROLLBACK SEGMENT rb3 ONLINE;
ALTER ROLLBACK SEGMENT rb4 ONLINE;

ALTER ROLLBACK SEGMENT rb_temp OFFLINE;
DROP ROLLBACK SEGMENT rb_temp ;



http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/create.htm#1000691

Day by day, wish the best to Mr H.Larson and his teams, the more features, the more comfortable. Since DBCA born, I've missed the method of creating DB manually. Smile

Try to use DBCA, next by next mouse click. It's easy to understand.

Good luck!
Error with webconsole [message #291514 is a reply to message #291221] Fri, 04 January 2008 09:55 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
Hello,

I have created a EM console using emca and a webconsole using DBCA for a manually created database on a Oracle 10.2.0.3.0 , Windows 2003. I get the webconsole , but when I enter the username and password and hit enter . The fields just reset and does not login. Any suggestions on how to correct this.

Thanks
Re: Error with webconsole [message #291568 is a reply to message #291514] Fri, 04 January 2008 23:49 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Do you get any error??
Check the services ?
Re: Error with webconsole [message #291570 is a reply to message #291568] Sat, 05 January 2008 00:21 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
I do not get any errors.

The fields just reset. The service dbconsoletest .. test been the sid is running.

I have a doubt should I run the webconsole logging into the system as a administrator. I run this webconsole logging into the system as an administrator into the company network. So should I get into the system as an administrator.

Thanks for any help.
Re: Error with webconsole [message #291577 is a reply to message #291570] Sat, 05 January 2008 01:36 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:


I have a doubt should I run the webconsole logging into the system as a administrator. I run this webconsole logging into the system as an administrator into the company network. So should I get into the system as an administrator.



Bit more specific..
On windows its not a problem.

Run this command on CMD. and check.

c:\> echo TZ
Re: Web Console for Manually Created Database [message #291579 is a reply to message #291221] Sat, 05 January 2008 01:49 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
No Message Body
Re: Web Console for Manually Created Database [message #291580 is a reply to message #291221] Sat, 05 January 2008 01:50 Go to previous messageGo to next message
skvd
Messages: 17
Registered: December 2007
Junior Member
when I enter echo TZ .. it gives back TZ

I have created another database with DBCA , even the web console of this database is having the same problem. when I enter the username and password the fields just reset and doesnot login.

Thanks
Re: Web Console for Manually Created Database [message #291623 is a reply to message #291580] Sat, 05 January 2008 09:18 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

check Internet explore ---> tools ---> internet options ---> security ---> Locat intranet (Here ADD em web console URL for eg: "http://localhost:port/em"

hope this help

[Updated on: Sat, 05 January 2008 09:18]

Report message to a moderator

Previous Topic: ORA-00471: DBWR process terminated with error
Next Topic: Temp file size
Goto Forum:
  


Current Time: Sat Dec 07 00:31:21 CST 2024