> Hi listers!
> I had to do a hardware upgrade on my RS6000-F40 server, (AIX 4.21, =
Oracle
> 7.3.4) last weekend, and after that I redistributed the database =
files on
> the disks.
> To acomplish this I did:
> - Full backup of the database,
> - Full Export
> - Mksysb (System Operating Backup)
>=20
> I restored the mksysb on one of the new disks. I replaced the one =
that had
> the operating system....
> Thanks to David Barbour, I finally used the tips you gave me to do =
that...
> it worked great!
>=20
> After the operating system was ok, I restored the physical files to =
their
> original position, and proceded to rebuild the schema distributing =
the
> objects in the new disks. What I did was:
>=20
> - disabled constraints, droped the indexes, tables and user
> - droped tablespaces where the tables were
> - deleted the corresponding physical files
> - created two tablespaces for data, three for indexes
> - recreated the user
> - created tables using scripts, distributing them in their new =
tablespaces
> - imported data, indexes=3DN ignore=3DY
> - created indexes using scripts, distributing them in their new
> tablespaces
> - enabled constraints
>=20
> After the work was done, I checked that the numbre of tables, =
indexes, and
> constraints where the same as they where before. So I assumed that =
nothing
> was missing.
>=20
> I ended this work yesterday, and so far I have two anomalies I don't =
know
> how to solve:
>=20
> 1- NLS_LANG=3DAmerican_America.we8iso8859p1
>=20
> This variable is set in the oracle user enviroment, (operating =
system),
> and is set in Oracle database too:
>=20
> nls_language=3DAMERICAN
> nls_territory=3DAMERICA
>=20
> Problem: When users enter the database using this application called
> TRUCK, the caracter =D1 is replaced by ?
>=20
> Anyone can tell me why and what can I do to solve this?
>=20
> 2- Some users use Oracle Discoverer to print some reports (created by =
our
> developers) and this morning one of the users claimed that there are =
no
> reports on the screen when he loded discoverer.
> I have no idea of how discoverer works, and don't know where to start
> looking..
> So far, all I know is that at some point when the report is =
developed,
> they save the report in the server, not their local machine.....the
> questions is WHERE
>=20
> If anyone could help me out on this one, I would appreciate it a =
lot!!!
>=20
> Thanks in advance!
>=20
>=20
> **************************************************
> Ver=F3nica Levin Enriquez
> Administrador AIX
> Compa=F1=EDa Cervecera de Nicaragua
> Tel=E9fono: 505-2493779
> Fax: 505-2443979
> Email: vlevin_at_victoria.com.ni=20
> http://victoria.com.ni
Received on Wed May 03 2000 - 13:08:58 CDT
