| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SOLVED : Problems after hardware upgrade.....Please Help!
Hi again!
In casi anyone is interested in this....
to case 1- somhow the import did not recognized the character the =
export
was made with. I did not used the cahset parameter in the import, I =
thought
it was not necessary. I was wrong.=20
If I insert anything in a table, with letter =D1 it registers it, so I =
know
the character set is working fine. Now we will have to do some cleanup
becase we can not afford to re import everything and loose a day of =
work.
to case 2- It seems that Discoverer registers somewhere the tablespace =
where
the tables belonging to it are created, and sice I redistributed the =
tables
it just got lost.
I will recreate them at the original tablespace and check this out =
tomorrow,
Nobody replied this post, but somehow I got this almost solved.
have a nice day!
-----Mensaje original-----
De: Veronica Levin [mailto:vlevin_at_victoria.com.ni]
Enviado el: Mi=E9rcoles 3 de Mayo de 2000 10:30 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Problems after hardware upgrade.....Please Help!
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,
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!
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:
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.
I ended this work yesterday, and so far I have two anomalies I don't =
know
how to solve:
1- NLS_LANG=3DAmerican_America.we8iso8859p1
This variable is set in the oracle user enviroment, (operating system), =
and
is set in Oracle database too:
nls_language=3DAMERICAN
nls_territory=3DAMERICA
Problem: When users enter the database using this application called =
TRUCK,
the caracter =D1 is replaced by ?
Anyone can tell me why and what can I do to solve this?
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
If anyone could help me out on this one, I would appreciate it a lot!!!
Thanks in advance!
--=20
Author: Veronica Levin
INET: vlevin_at_victoria.com.ni
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L Received on Wed May 03 2000 - 18:11:10 CDT
 |
 |