Oracle Database Discussions

Hello everyone, nice to meet you!

First of all I apologize for :

-my pretty terrible English

-the fact that I'm a complete greenhorn in databases and that my question could sound as a complete evidence for most of you

-the fact that there is probably a bilion threads on this topic, but after many hours lost in searches in this forum or elsewhere, I've just gave up..

So now that these points are mentionned, here is my problem with my own green words :

Goal : Be able to log on and restore an Oracle DB from a dump file (.dmp), and then convert it to SQL using SSMA.

My first step was to be able to install Oracle Databese Express 11gR2.

Then, I installed SSMA and launch it to fulfill my goal.

To connect to Oracle, I now have to choose a connexion mode, notably one of these two ( text from https://msdn.microsoft.com/en-us/library/hh313203(v=sql.110).aspx ):

1. If you select Standard mode, provide the following values:
   1. In the Server name box, enter or select the name or IP address of the database server.
   2. If the database server is not configured to accept connections on the default port (1521), enter the port number that is used for Oracle connections in the Server port box.
   3. In the Oracle SID box, enter the system identifier.
   4. In the User name box, enter an Oracle account that has the necessary permissions.
   5. In the Password box, enter the password for the specified user name.
2. If you select TNSNAME mode, provide the following values:
   1. In the Connect identifier box, enter connect identifier (TNS alias) of the database.
   2. In the User name box, enter an Oracle account that has the necessary permissions.
   3. In the Password box, enter the password for the specified user name.

...but I don't even know how to find the Oracle SID...I've tried with Server name : localhost, Oracle SID :XE, and SYSTEM/password, but it didn't work.

So I tried with TNSNAME mode, Connect identifier : XE (found on my default tnsnames.ora file ), SYSTEM/password, and it still doesn't work.

It would be really nice of you to reflect on this and share your ideas on how to get throught this step of the process and wether you have any idea to accomplish the rest ( BD restoration/conversion) too!

Thank you very much.