![]() ![]() To know how to connect to the database through sqlplus, we have some ways to do it. Used TNSNAMES adapter to resolve the aliasĪttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCLPDB)))Ĭan we make a connection? ~]$ sqlplus /nolog We spent the last few months testing out several of the best NAS drives for the home / home office user, to sort out the best across categories like Best Overall, Best Budget NAS, Best Media. u01/app/oracle/product/19.3.0/dbhome_1/bin/sqlplusĬan we read tnsnames.ora? ~]$ tnsping orclpdb ![]() Connection TestĬan we see the sqlplus command? ~]$ which sqlplus In FreeNAS go to directory services - active directory and click Advanced Mode. However, you can also run sqlplus without using server's tnsnames.ora, so I said this step is optional. In this configuration, FreeNAS polls the Windows 2012 Active Directory. In this step, we logged in OS as oracle, and then changed permission mode to readable to other users. ~]$ chmod o+r $ORACLE_HOME/network/admin/tnsnames.ora If the user wants to use local naming (TNSNAMES) to connect to the database, we should make tnsnames.ora readable to others. SSSD provides PAM and NSS modules to integrate these remote sources into your system and allow remote users to login and. Please note that, for scripting the database connection, it's safer to add the command to the first line of your script. The new environment variables have been added to the user's shell. We can make the new profile effective immediately by souring it. Please note that, the profile file could be ~/.bash_profile for Linux (BASH) or ~/.profile for AIX (KSH) and Solaris. Add binary directory of ORACLE_HOME to PATH.ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1Īs you can see, we do the following things in profile: In this case, the user is erp who is a normal user and not in oinstall group. Its not realistic to assume we will be able to have every zip file on the ibiblio archive to use the FreeDOS pkg directory structure. We need to add some environment variables to the shell for the user, the best place to add them is user's profile. For all 'normal' files, people now are forced to unzip > to a temp directory and spend time to sort the files to put them in > the right directories in their installed freedos. In this post, we introduce the steps to configure and make SQL*Plus executable to other non-oracle users. Which means, any user other than the product owner (usually oracle) can also run sqlplus without problem. rwxr-xr-x 1 oracle oinstall 29144 /u01/app/oracle/product/19.3.0/dbhome_1/bin/sqlplusĪs we can see, the permission set shows that other users can read and execute the file. For example, we access our FreeNAS test machine using 192.168.0.13 in the web browser.In Linux or Unix platform, installed SQL*Plus in database server can be executed by anyone. The FreeNAS machine should provide a URL, which is essentially the IP that has been assigned to that particular machine by the network. Once FreeNAS has loaded, it's possible to select from various entries on the main menu, or detach the PC from a monitor and log in to the web interface from another PC on the same network. Select the spare USB drive (FreeNAS will not install on the one containing the OS so fear not if you select the wrong one) with the spacebar.If nothing appears, you may need to hit the boot menu shortcut for your motherboard (ours is F11) during startup or make sure the USB drive has been successfully set up. ![]() When firing up your FreeNAS PC, you should see a boot screen that displays FreeNAS as an option.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |