Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
jonesel Absent Member.
Absent Member.
1499 views

Oracle Database Questions

Hello Everyone,

I have been trying for almost 4 weeks to get answers to questions our Oracle DBA's have on the database for ZCM Enterprise. I started a low priority incident and I'm still unable to get questions answered in a timely fashion. The DBA's will not create any databases for us until they have their questions resolved, so in desperation I'm hoping someone here can provide some answers. Here are the questions copied from our DBA's email back to support, the questions are referencing an Oracle back end.

1. Will the CHARACTER SET of the database and NATIONAL CHARACTER SET of the database BOTH have to be UTF8 or just ONE? If just one has to be, which one will it be?

2. Are the database name, database user name, and corresponding tablespace name(s) coded in the application or can we name the database, database user, and tablespace(s) anyway we want?

3. Any suggestions on the size of the database one year after it's put into production? (1600 workstations)

Thanks for any help you can provide.
Labels (2)
0 Likes
3 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Oracle Database Questions

jonesel,

> 1. Will the CHARACTER SET of the database and NATIONAL CHARACTER SET
> of the database BOTH have to be UTF8 or just ONE? If just one has to
> be, which one will it be?
>
> 2. Are the database name, database user name, and corresponding
> tablespace name(s) coded in the application or can we name the
> database, database user, and tablespace(s) anyway we want?
>
> 3. Any suggestions on the size of the database one year after it's
> put into production? (1600 workstations)


1. I donno, but will see if I can find out.

2. Database and user can be named. Table names No unless that is
something different than tablespace.

3. Are you using inventory? Are you using Asset Management?

--
Jared Jennings - Data Technique, Inc.
Novell Support Forums Sysop
My Blog and Wiki with Tips, Tricks, and Tutorials
http://jaredjennings.org
0 Likes
jonesel Absent Member.
Absent Member.

Re: Oracle Database Questions

Thanks for the quick reply.

Yes we are using both Asset Inventory and Managment.
0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Oracle Database Questions

jonesel,

> Yes we are using both Asset Inventory and Managment.


Oops, forgot: How long do you want to keep history around?

Actually, I would following the Asset Management DB size guidelines.
And then add 1 - 2 gb for the other ZCM stuff.

--
Jared Jennings - Data Technique, Inc.
Novell Support Forums Sysop
My Blog and Wiki with Tips, Tricks, and Tutorials
http://jaredjennings.org
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.