![]() So we need to download two things: one is the base package (instant client-basic), the other is the ODBC package (instant client- odbc). Baidu has a lot of answers and blogs, which are useless at all. In order to do distributed experiments, we need to use ODBC to access oracle on a Windows without Oracle database. Grant connect,dba,resource to *name*Allocation of permissions To access tables of different users, the user name is added before the table name.Ĭreate user *name* identified by *passwd*Creating Users ![]() I suddenly remembered the need to restart the service when SQL Server was remotely connected before, so I went to restart Oracle’s TNSListener service once, really, after restarting the configuration reload would be good.Įach Oracle user has a table scheme. ![]() Later, I found a tutorial on the Internet saying that I lack Instant Client. I use Net Management to configure local services and listeners according to the online tutorials, but I just can’t pass the test when using Sqldeveloper remotely. What bothers me is how to connect remotely. At first, PLSQL is used, but it has not been connected, and then it is connected directly with the SQL developer provided by Oracle. (Installing Oracle on Windows will also prompt a lot of errors, just ignore them all.)Īfter Oracle is installed, it can be connected through SQL plus, but sqlplus is not a graphical interface which is not conducive to saving the SQL statements, or want to access through the graphical interface. Then I reinstalled my laptop into Windows and installed Oracle on it. I tried to install it on linux, but it failed. To learn Oracle, I first had to install it. Because of the need of advanced database course, I began to learn Oracle database.
0 Comments
Leave a Reply. |