locked
SSMA for Oracle, cannot connect to Oracle started with upgrade option RRS feed

  • Question

  • Hi everybody,

     

    I have to migrate an Oracle (9i) database to SQL Server 2008. As SSMA for Oracle is developed to do this I decided to try it.

    It took me some time to get the Oracle environment working. Since I was not able to find any 9i database setup I installed 11g and tried to startup the Oracle instance with that. After a lot of 'challenges' (I don't know anything of Oracle), I was able to startup the Oracle instance. It returned me an error stating that I have to start it up with the 'upgrade-option' (ORA-00704: bootstrap process failure). So I did and I was able to open the database and even browse through it using the Toad tool. To gain access to it I had to check the option to login as 'sysdba'.

     

    Now I want to migrate, but SSMA won't let me connect to Oracle. It does not have an option like Toad to login as sysdba, and because of the upgrade-option I cannot login as a normal user.

    I tried to avoid the upgrade-option to start Oracle by trying to upgrade the database to 11g. But utlu112i.sql and catalog.sql give me errors like ORA-04023: Object SYS.STANDARD cannot be validated.

     

    So, is there a possibility for me to connect using the 'login as sysdba' option? Or do I really have to get the Oracle instance running without upgrade-option before I can migrate it to SQL Server?

     

    Any help is appreciated!

    Thursday, August 12, 2010 9:21 AM

Answers

  • Hello,

    Your Oracle is not in state “open”. The database is not accessible. You can try connecting to that instance using “connect / as sysdba” from the operating system, and try to finish the upgrade. If you don’t do that you won’t be able to mount the Oracle database.

    You won’t be able to connect to Oracle using SSMA until you solve that issue on the Oracle side.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by Keshav Ramarao Wednesday, August 25, 2010 7:54 PM
    Thursday, August 12, 2010 3:14 PM
  • Hello,

    I am glad my previous post help you understand there is some work to be done on the Oracle side, for you to use SSMA with that Oracle server.

    I will love to help you with Microsoft SQL Server or any software that belongs to Microsoft anytime, but Microsoft software only.

    Hope you can solve that issue quickly with Oracle support.

    Thank you for participating at MSDN forums!

    Have a good day!

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, August 13, 2010 11:38 AM

All replies

  • The listener seems to be running ok, I get the following error:

     

    ORA-12527:

    TNS:listener: all instances are in restricted mode or blocking new connections

    Cause: All appropriate database instances supporting the service requested by the client reported that they either were in restricted mode or were blocking the new connections. The Listener does not allow connections to such instances. This condition may be temporary, such as at instance startup.
    Action: Attempt the connection again. If error persists, then contact the database administrator to check the status of the instances.

     

    Does this mean that I'm screwed or is there any other way to connect SSMA to an Oracle Instance in restricted mode?

     

    Thanks in advance!

     

    Greetings,

    Dirco

     

    Thursday, August 12, 2010 2:54 PM
  • Hello,

    Your Oracle is not in state “open”. The database is not accessible. You can try connecting to that instance using “connect / as sysdba” from the operating system, and try to finish the upgrade. If you don’t do that you won’t be able to mount the Oracle database.

    You won’t be able to connect to Oracle using SSMA until you solve that issue on the Oracle side.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by Keshav Ramarao Wednesday, August 25, 2010 7:54 PM
    Thursday, August 12, 2010 3:14 PM
  • Hello Alberto,

     

    Thank you for your response. 

     

    I'm able to access the database with Toad and sqlplus, using "sys as sysdba". But if you say that is not possible with SSMA then I'm screwed and will indeed have to solve the problem on the Oracle side to finish the upgrade.

    Google tells me "ORA-04023: Object SYS.STANDARD cannot be validated." is not easily fixed and something to investigate for customer support.

    I guess I'd better post this issue on the Oracle forum then, or are you also an Oracle expert? 

     

    Thanks anyway!

     

    Regards,

     

    Dirco

     

    Friday, August 13, 2010 8:05 AM
  • Hello,

    I am glad my previous post help you understand there is some work to be done on the Oracle side, for you to use SSMA with that Oracle server.

    I will love to help you with Microsoft SQL Server or any software that belongs to Microsoft anytime, but Microsoft software only.

    Hope you can solve that issue quickly with Oracle support.

    Thank you for participating at MSDN forums!

    Have a good day!

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, August 13, 2010 11:38 AM