5 Replies Latest reply on Jul 24, 2012 7:59 PM by SriniVEERAVALLI

    obiee 11g import

    DileepKumar
      HI

      i am using obiee 11g i want to import sh schema from oracle 10g

      how can i import
      any plz help me

      Thx in Advance
        • 1. Re: obiee 11g import
          SriniVEERAVALLI
          Update the TNS entry at location
          OFM_HOME\Oracle_BI1\network\admin

          and Import Metadata or else

          use tns entry at Data Source Name at connection pool using OCI 10/11g
          (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = XE) ) )


          If helps Pls mark correct or helpful
          • 2. Re: obiee 11g import
            DileepKumar
            thx a lot

            can u tell clearly plz dont mind
            • 3. Re: obiee 11g import
              SriniVEERAVALLI
              Select Start > Programs > Oracle Business Intelligence > BI Administration to open the Administration Tool.
              Select File > New Repository
              Enter a name for the repository. Leave the default location as is. It points to the default repository directory
              Leave Import Metadata set to Yes.
              Enter and retype a password for the repository

              Import Metadata:
              Change the Connection Type to OCI 10g/11g. The screen displays connection fields based on the connection type you selected.
              Enter a data source name (You can go for any of one what i mentioned earlier). In this example the data source name is orcl. This name is the same as the tnsnames.ora entry for this Oracle database instance.
              Enter a user name and password for the data source
              Click Next
              Accept the default metadata types and click Next
              In the Data source view,
              The Connection Pool dialog box appears. Accept the defaults and click OK
              The Importing message appears


              If helps, Pls mark correct or helpful
              • 4. Re: obiee 11g import
                DileepKumar
                thx a lot

                where we have to create tsn and where we have to copy and paste code
                • 5. Re: obiee 11g import
                  SriniVEERAVALLI
                  From location
                  C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN
                  To
                  \Oracle_BI1\network\admin

                  If helps close this thread by marking as correct or helpful