Register  ::  Login
 
Home

Forum

About Us

Contact Us

Services

Jobs
  Forum Update : February 07, 2012
Google AdSense Minimize
  
Welcome to Asbuilt-DBA forum ! Minimize

Here you can find a community of professionals who work with INtools® (SPI) and want to interact and exchange information, including problems encountered, offer solutions, and raise new topics.

This forum is composed of two main sections:
1.      Discussions, which is an open discussion forum where you can talk about any related topic to INtools.
2.      FAQ section that offers a variety of questions and answers regarding INtools.
We hope that you will enjoy participating in this forum. Participation in the forum is free of charge.
If you want to start a new forum, please contact the Webmaster.
Add to Google
INtools is trademark of Intergraph corporation
Forum Groups Minimize
SearchForum Home
  Aggregated  Discussions  Intools Old version  Oracle Characte...
 Oracle Character Set
 
 3/20/2009 4:01:39 AM
User is offlinekedar
18 posts


Oracle Character Set

Hi,

I have a .DB of INTools version 05.03.09.03. As per the compatibility chart, Oracle 9i can be used as backend of INTools version 05.03.09.03. I tried to connect to the Oracle 9i database through DB setup Utility. But It shows the error like " Invalid Character Set ".

Can anybody give guidence on this issue?

Kedar
 3/20/2009 9:21:59 AM
User is offlineadmin
177 posts
5th


Re: Oracle Character Set

Hi,

Please try to use O84 in the DB setup.

If it will not work send me directly snapshots step by step with the error.

 

Ilan

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 3/20/2009 10:30:28 AM
User is offlineadmin
177 posts
5th


Re: Oracle Character Set

hi Again,

 

Please run regedit from command line and highlight

HKEY_LOCAL_MACHIN\SOFTWARE\ORACLE

and right click with the mouse and save it as 1.reg

rename the file to 1.txt and send it to me.

 

Ilan

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 3/25/2009 4:01:33 AM
User is offlinekedar
18 posts


Re: Oracle Character Set
Thanks Ilan,

I have created one database in Oracle 9i with following major steps.

1. Character set used : US7ASCII (Same set used in regedit) & National charcter set used: UTF8
2. Change the SYSTEM tablespace form Locally Mangaed mode to Dictinary Managed Mode
3. While running DB setup,
'Oracle version' : '8.1.5/8.1.6/8.1.7
'DBMS Paratmeter : O84,
and clear all the check boxes befor proceeing in 'Additional Darabase Parametrs" dialog box.

The DB Setup completed successfully. I have initialized a watcom database of version 05.03.09.03 succesfully, but while Opening any Module & Domain Admin it is giving error message " The version of your INTools database is older than your license. Run the Administration module and update your database".

I want to know whether it is possible to open INTools database of version 05.03.09.03 with Oracle 9i. If yes then what I missed.

Thanks

Kedar
 3/25/2009 8:15:52 AM
User is offlineadmin
177 posts
5th


Re: Oracle Character Set

Hi,

Please do the following:

1. Open the file from intools folder c_vet.ora with notepad .

2.copy the numbers from this file to c_ver.pbd (open it with notepad) and save this file.

3. Run admin module and upgrade the admin schema and after that the domain schema.

Regards

 

Ilan Hills

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 Page 1 of 2
NextNo Rating
12Next 
  Aggregated  Discussions  Intools Old version  Oracle Characte...
Intools
 Search   Forum Home     
website monitored by
host-tracker.com
website monitoring service

Search Engine Optimization and SEO Tools
My Google Pagerank
Copyright 2005 by AsBuilt - DBA   ::  AsBuilt-DBA  ::  Privacy Statement  ::  Terms Of Use