jump to navigation

Installation / Re-Installation of Oracle Database 10g on Windows November 17, 2007

Posted by Muhammad Habib in DBA.
1 comment so far

1.    Take back-up of data (Full Database).
2.    Shutdown your database. (Shutdown Abort).
3.    Take back-up of SP file.
(If you have set some parameters previously according to your environment)
4.    Note the size and names of all table spaces.
5.    Delete Database through wizard (If previously installed).
6.    Run Installer and uninstall Oracle from your system.
7.    Remove Oracle entries from registry.
8.    Restart your system.
9.    Remove Oracle Directory from System.
10.    Check services from Administrative tools. Please verify that there should not any Oracle related service existing in the list. No TNS, no oracle home etc.
11.    Reboot your system.
12.    Run Oracle Installer and start installation. Follow wizard and select options according to your requirements.
13.    When Database is created, verify your work by connecting to database.
14.    Shutdown Database.
15.    Restore SP file.
16.    Start Database.
(Note if you find any error on startup, then you have to generate SP file from init.ora file)
17.    Install patch from its installer and run the related scripts. (It will take around 45 minutes so no need to worry).
18.    Reboot your machine.
19.    Create table spaces by same name and size as we noted in step 4.
20.    Load (Import) backup from dmp file. Create log file as well.
(View log file. If you find any error of “table space already exists”, then don’t worry. It is because we have created the table spaces our selves.)

Good Luck!!!

PO Interface Tables November 13, 2007

Posted by Muhammad Habib in Oracle Applications, Oracle Purchasing.
13 comments

If some customized system have the data and we want to Generate the interface of PO and to generate the PO directly in Oracle Purchasing; means we enter the data in our system and want a interface that directly generate the entry in PO tables, two interface tables are involved PO_HEADERS_INTERFACE and PO_LINES_INTERFACE:

INSERT INTO po.po_headers_interface
(interface_header_id, batch_id, process_code,
note_to_vendor, action, document_type_code,
currency_code, payment_terms,closed_code,
created_by, rate_type,  rate_date, rate,
agent_name, agent_id, vendor_id,  vendor_site_id,
ship_to_location_id, bill_to_location_id)
———-

INSERT INTO po.po_lines_interface
(interface_line_id,
interface_header_id, line_num,
line_type, item_id, item_description,
unit_of_measure, quantity,
unit_price, promised_date,
ship_to_organization_id,
ship_to_location_id,
closed_code,
created_by,
list_price_per_unit)
———–