| Web Console for Manually Created Database [message #291221] |
Thu, 03 January 2008 07:37  |
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 #291284 is a reply to message #291221] |
Thu, 03 January 2008 11:28  |
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 #291290 is a reply to message #291287] |
Thu, 03 January 2008 12:25 |
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 #291406 is a reply to message #291291] |
Fri, 04 January 2008 02:01 |
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. 
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 |
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 #291570 is a reply to message #291568] |
Sat, 05 January 2008 00:21 |
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 |
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 #291580 is a reply to message #291221] |
Sat, 05 January 2008 01:50 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
