2020.04.15
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
Simmilar are Redhat RHEL, Fedora, CentOS - rpm (yum) based Linux distros.
OEL was 7.6, after yum update 7.8. VirtualBox 6.1.4 did not work, I installed 6.1.2.
Ver. 7.8 and 8.1 clipboard sharing Win - Lin is not working (oralin_8_1_V984216-01.iso)
use older VBox Guest Additions instead ver 6.1.4 - also CPU load is ~5% and was ~50% ! :
L:\1_instalac\1_instalirano\5_virtualbox\VBoxGuestAdditions_6.1.2.iso
L:\1_instalac\1_instalirano\5_virtualbox\VBOX_UserManual.cleaned.pdf
enp0s3 HW adress=08:00:27:1D:B3:D8, manual IPv4 method, IPv6 disabled
In windows, type "winver" in the run box. My latest version is 1909. (march 2020)
[root@oralin76 ~]# uname -a
Linux oralin76 4.14.35-1902.300.11.el7uek.x86_64 #2 SMP Tue Mar 17 17:11:47 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
Linux oralin76 4.1.12-124.27.1.el7uek.x86_64 #2 SMP Mon May 13 08:56:17 PDT 2019 x86_64 x86_64 x86_64 GNU/Linux
For right click -> "New .txt" : create file shortcut : Home -> Templates -> create in Terminal or copy here moj_Blank_Doc.txt
super (winkey) + space - switch to english
sudo /opt/lampp/manager-linux-x64.run - start XAMPP
or sudo /opt/lampp/xampp start
URLs to use on Linux in vbox PC oralin76 :
URL | URL opens page |
---|---|
http://oralin76/fwphp/www/ | fwphp site on vbox PC oralin76 |
http://192.168.5.12:8083/fwphp/www/ | fwphp site on win 10 PC sspc2 (or sspc2 instead IP) |
URLs to use on win 10 PC sspc2 :
URL | URL opens page |
---|---|
http://sspc2:8083/fwphp/www | fwphp site on on win 10 PC sspc2 |
http://192.168.5.13/fwphp/www | fwphp site on vbox PC oralin76 - ERR_CONNECTION_REFUSED (why ?) (or oralin76 instead IP) |
On Linux oralin76 vbox PC (VM), in explorer : smb://192.168.5.13/htdocs/ opens Linux share defined in /etc/samba/smb.conf
/media/sf_J_DRIVE opens Windows share defined in Windows
On Windows sspc2 PC, in explorer : \192.168.5.12 and \192.168.56.1 = Win shares visible in Win Network folder on PC sspc2, but Lin does not open this, same as \sspc2 or smb://192.168.56.1/
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
Download Oracle VM VirtualBox https://www.virtualbox.org/wiki/Downloads
to L:\1_instalac\1_instalirano\5_virtualbox\001_VirtualBox-6.1.4-136177-Win.exe and install
Machine -> New or icon "New" in vbox main screen :
J:\vbox_vms
(for oralin76.vdi)J:\vbox_vms\oralin76\oralin76.vdi
100 GB
(8 GB for swap - required by Oracle 11g DB ee 2 x memory = 12 GB)Settings -> General -> Advanced
Snapshot folder is : J:\vbox_vms\oralin76\Snapshots
Enable Shared Clippboard and Drag-drop both bidirectional
Settings -> System -> MB -> Enable EFI, no more floppy
Settings -> System -> Processor -> 2 CPU (2 for Win 10 64 bit)
Settings -> Display -> Screen -> 128 MB
Settings -> Display -> Screen -> Enable 3D acceleration
Settings -> Network -> Adapter 1 -> Atached to: -> Bridged adapter
(my is cable, Realtek PCIe GBE on Gigabyte Z68AP-D3, Intel Core i5 2500K, 16 GB DDR3 - recomended)
->Promiscuous -> Mode: Allow all
Settings -> Shared folders -> Add : Folder path: J:\ , name: JWIN
My virt. Apache site doc.root on Win.10 is J:\awww\www
Auto-mount check box for all Shared folders.
Mount point : ???
Download Oracle VM Extension Pack https://www.virtualbox.org/wiki/Downloads
to L:\1_instalac\1_instalirano\5_virtualbox\Oracle_VM_VirtualBox_Extension_Pack-6.1.4.vbox-extpack
double-click on the package and a Network Operations Manager window will appear, guiding you through steps.
Extension pack provides the following added functionality:
- The virtual USB 2.0 (EHCI) device. See chapter 3.11.1, USB Settings, page 60.
- The virtual USB 3.0 (xHCI) device. See chapter 3.11.1, USB Settings, page 60.
- VirtualBox Remote Desktop Protocol (VRDP) support. See chapter 7.1, Remote Display (VRDP Support), page 116. Allows for high-performance remote access to any running virtual machine. This extension supports Remote Desktop Protocol (RDP) >originally built into Microsoft Windows, with special additions for full client USB support.
- Host webcam passthrough. See chapter 9.5, Webcam Passthrough, page 247.
- Intel PXE boot ROM.
- Disk image encryption with AES algorithm. See chapter 9.28, Encryption of Disk Images, page 286.
Extension Pack is for All supported platforms - Install it with same version as installed version of VirtualBox.
To view the extension packs that are currently installed, start VirtualBox Manager -> File menu -> select Preferences-> go to Extensions category - allows you to remove a package or add a new one.
Alternatively you can use VBoxManage on the command line: see chapter 8.41, VBoxManage extpack, page 184 for details.
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
Download Oracle Linux 7.6 64 bit : https://edelivery.oracle.com/osdc/faces/Home.jspx
to L:\1_instalac\1_instalirano\linux\2_oralinux\oracle_linux_7_6\001_oralin_7_6_V980739-01.iso and install in VBOX :
min. 8 GB for swap - required by Oracle 11g DB
Select Virtual Machine oralin81 that you just created. Click on the green Start icon on the top of vbox screen. Select 'install Oracle linux' and click Enter key. Select language to use during the installation process. Only ora Linux: Select Server with GUI. Minimal installation option is the installation without GUI. Select :Add ons for selected environment and choose : File and storage server Java platform Network filesystem client Performance tools Compatibility libraries Development tools --- at least this not !!! KDE desktop (installs also Gnome) Select other buttons (keyboard if not english, partitioning...) ethernet fwphp75 enp0s3 GENERAL: Automatic conn. to network ipv4 : during installation you will see 2 red warnings indicating that the root password is not set and no users are created - create root account and user account When system reboots, you will be directed to perform the initial setup, click on the checkbox to accept the license agreement and click on the Done button on the top left corner. Click on the FINISH CONFIGURATION button to proceed. do not forget to remove the tick at Boot Order 'CD/DVD'. Installation is finished.
su - or sudo bash yum update
if ERROR see 002_instalac02_2ERROR_add_guest_add.jpg
cd /var/log
ls
gedit vboxadd-setup.log.highest_ver_eg_4
look for "please install"... shift+ctrl+c them
yum install zlib-devel
yum install elfutils-libelf-devel
Right click on desktop then Display setings 1920 1200 (16:10) then right ctrl+f works
Add the kernel parameter divider=10 to select a guest kernel timer frequency of 100Hz to avouid High CPU load.
cat /boot/grub/menu.lst
## open port 80 /443 ##
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 443 -j ACCEPT
systemctl status httpd.service or systemctl status httpd
sudo systemctl enable httpd.service
command will create approriate symbolic links to the /usr/lib/systemd/system/httpd.service
if you want to recreate symbolic link for enabling service :
systemctl reenable httpd.service
To disable a service to be not started automatically at boot time:
sudo systemctl disable httpd.service
This command will remove appropriate symbolic links to /usr/lib/systemd/system/httpd.service
sudo systemctl start httpd.service
sudo systemctl status httpd.service
sudo systemctl restart httpd.service
To only reload the configuration of one service without interrupting their execution:
sudo systemctl reload httpd.service
I tested also Centos 7.3 and Mint 18.2 Cinnamon - do not work for me (after OS update - problems with booting same as with oralinux 7.3). To install DB 11g XE I ended with oralinux 7.3 - works better than 7.2.
This image file is located in the installation directory of VirtualBox:
C:\Program Files\Oracle\VirtualBox\VBoxGuestAdditions.iso
After installing Linux on VirtualBox we need install VBoxGuestAdditions because of not working features :
Resolution is bad, Auto-Resize (rightctrl+f), Drag-Drop, Clipboard sharing
To install the Guest Additions for a particular VM, you mount this ISO file in your VM as a virtual CD-ROM and install from there.
su - yum update
or :
C:\Program Files\Oracle\VirtualBox\VBoxGuestAdditions.iso
start Orcle VM VirtualBox Manager -> click oralin76 Virtual Machine (powered off) -> click icon Settings
-> click Button 'Storage' and add a new 'Controller: IDE' for virtual DVD device, put iso above in it
start Oracle Linux 7.6 and right click VBoxGuestAdditions icon -> open in terminal
if ERROR clipboard sharing not working use insteadd ver 6.1.4 older :
L:\1_instalac\1_instalirano\5_virtualbox\VBoxGuestAdditions_6.1.2.iso
if ERROR install VBoxGuestAdditions.iso (see 002_instalac02_2ERROR_add_guest_add.jpg)
cd /var/log
ls
gedit vboxadd-setup.log.highest_ver_eg_4 (I tried 4 times)
look for "please install"... shift+ctrl+c them
yum install zlib-devel
yum install elfutils-libelf-devel
repeat install VBoxGuestAdditions.iso
Right click on desktop -> Display setings -> 1920 x 1200 (16:10) then rightctrl+f works
see chapter 4, Guest Additions, page 83/391 software packages which can be installed inside of supported guest systems to improve their performance and to provide additional integration and communication with the host system.
- automatic adjustment of VIDEO RESOLUTIONS,
- MOUSE POINTER integration
- SEAMLESS WINDOWS - windows that are displayed on the desktop of the virtual machine can be mapped on the host's desktop, as if the underlying application was actually running on the host See ch 4.6
- SHARED FOLDERS which let you access files from the host (Win 10) system from within a guest machine see chapter 4.3
- accelerated 3D graphics
- Generic host/guest communication channels
- Time synchronization
- SHARED CLIPBOARD
- Automated logons (credentials passing)
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
to use "sudo"
su -
cd /etc
ls -alF
chmod +w sudoers
gedit sudoers
# scroll down in file and find line (root ALL=(ALL) ALL)
# right there add this for the user (example userid: roman)
root ALL=(ALL) ALL
ssoralin73 ALL=(ALL) ALL
Exit & Save
chmod -w sudoers (make the sudoers READ-ONLY again)
Use cases:
Lauch bash with elevated privilges, using your own password:
sudo bash
Lauch shell as user root, with root's password:
su - root
Lauch shell as user root, with your own password:
sudo su - root
How to elevate privileges to root in bash and return back?
sudo with heredoc syntax:
possiblevariable=something
sudo /bin/bash <<EOF
cd /somedir
pwd
commandasroot1 "$possiblevariable"
commandasroot2
EOF
nonrootcommand (and not in /somedir)
[ora@localhost ~]$ sudo bash <<EOF
cd /tmp
pwd
EOF
------------- outputs :
[sudo] password for ora:
/tmp
how variables substitution work in heredoc:
[ora@localhost ~]$ sudo bash <<EOF
cd /tmp
echo $PWD; echo \$PWD
EOF
[sudo] password for ora:
/home/ora
/tmp
how you can get output into variable
[ora@localhost ~]$ variable=$(sudo bash <<EOF
cd /tmp
echo $PWD; echo \$PWD
EOF
)
[ora@localhost ~]$ echo $variable
/home/ora /tmp
[ora@localhost ~]$
tee command read from standard input (such as keyboard) and write to standard output (such as screen) and files :
echo 'text' | sudo tee -a /path/to/file -a OR --append
echo '192.168.1.254 router' | sudo tee -a /etc/hosts
Far more commonly, you give -s alone, so it just runs your user's shell interactively. In that mode, it differs from sudo bash in that it might run a different shell than bash, since it looks first in the SHELL environment variable, and then if that is unset, at your user's login shell setting, typically in /etc/passwd.
https://snapcraft.io/install/notepad-plus-plus/rhel
sudo snap install --classic notepadqq
/var/lib/snapd/snap/bin was not found in your $PATH. If you've not restarted your session since you installed snapd, try doing that. Please see https://forum.snapcraft.io/t/9469 for more details.
NOT WORKING Open it so : winkey in gnome or sudo /usr/bin/notepadqq
https://github.com/notepadqq/notepadqq#distribution-packages
https://github.com/notepadqq/notepadqq-packaging
Alternate Repository for RPM based systems Fedora, CentOS, etc.
(has good terminal tabs GUI)
(needed in vbox guest ? how to see Win diks ?)
su -c "yum install gparted"
No package gparted available
http://tutorialforlinux.com/2017/03/14/how-to-install-gparted-on-red-hat-linux-desktop/
enable the EPEL Repository (Extra Packages for Enterprise Linux) -Fedora Special Interest Group that creates, maintains, and manages a high quality set of additional packages for Enterprise Linux including, but not limited to, Red Hat Enterprise Linux (RHEL), RedHat and Scientific Linux (SL), Oracle Enterprise Linux (OEL).
Download Latest EPEL Release for RedHat 7: 2017-06-24 15:08 15K
https://dl.fedoraproject.org/pub/epel/7/x86\_64/e/
su -c "rpm -ivh ./epel-release-7*noarch.rpm"
or
su -
cd /tmp
wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
ls *.rpm
yum install epel-release-latest-7.noarch.rpm
yum repolist
repo id repo name status
epel/x86_64 Extra Packages for Enterprise Linux 7 - x86_64 11,932
ol7_UEKR4/x86_64 Latest Unbreak.Enterp.Kernel R 4 for 7 Server 396
ol7_latest/x86_64 Oracle Linux 7Server Latest (x86_64) 19,362
repolist: 31,690
sudo yum install gparted
start gparted: sudo gparted
cp /media/sf_2_oralinux/1_oralinux_7_2_Downloads_rpm.zip /home/ssoralin73
Not needed:
cd /home/ss/Desktop
su -
mkdir /mnt/**sf_aplw
mount -t vboxsf fw /mnt/**sf_aplw
ls -alF /mnt/**sf_aplw or ls -alF /mnt/**sf_2_oralinux**
[root@oralin73 ~]# ip addr show enp0s3 | grep inet | awk '{ print $2; }' | sed 's/\/.*$//'
192.168.5.95
fe80::9760:1dcd:9a9b:92
or curl http://icanhazip.com
89.164.133.80
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
L:\1_instalac\1_instalirano\5_virtualbox
-- not on oralin gksu gedit /etc/samba/smb.conf
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access
uname -a
Linux localhost.localdomain 4.14.35-1902.300.11.el7uek.x86_64 #2 SMP Tue Mar 17 17:11:47 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
?? map to guest = bad user
?? dns proxy = no
####Share Definitions
[Anonymous]
path = /samba/anonymous
browsable =yes
writable = yes
guest ok = yes
read only = no
Load smb config files from /etc/samba/smb.conf
Loaded services file OK.
Server role: ROLE_STANDALONE
Press enter to see a dump of your service definitions
drwxr-xr-x. 5 root root 4096 Apr 9 04:35 ./
drwxr-xr-x. 31 root root 4096 Apr 9 04:37 ../
-rw-r--r--. 1 root root 3607 Aug 27 2019 applications.html
-rw-r--r--. 1 root root 177 Aug 27 2019 bitnami.css
drwxr-xr-x. 21 root root 4096 Apr 9 04:35 dashboard/
-rw-r--r--. 1 root root 30894 May 11 2007 favicon.ico
drwxr-xr-x. 2 root root 65 Apr 9 04:35 img/
-rw-r--r--. 1 root root 260 Jul 9 2015 index.php
drwxr-xr-x. 2 daemon daemon 6 Apr 9 04:35 webalizer/
cd /opt/lampp/htdocs
chmod -R 0775 /opt/lampp/htdocs/
chown -R ora:ora /opt/lampp/htdocs/ - to be able to ctrl+c, v and rename and update lin dir from Win 10 !!
??? chown -R nobody:nobody /opt/lampp/htdocs/
chcon -t samba_share_t /opt/lampp/htdocs/
But \192.168.5.13 Error :
It is available but is not responding to connection attempts. A firewall or network security policy on the remote computer might be blocking the connection on port "file and print sharing resource". You can run below commands to stop Linux firewall services :
service firewalld stop
service iptables stop
Now loginscreen appears ! login so : ora/MYSHORTPSW
systemctl enable smb.service
systemctl enable nmb.service
systemctl restart smb.service
systemctl restart nmb.service
[root@localhost ora]# systemctl enable smb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/smb.service to /usr/lib/systemd/system/smb.service.
[root@localhost ora]# systemctl enable nmb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/nmb.service to /usr/lib/systemd/system/nmb.service.
[root@localhost ora]# smbclient -L oralin76
Enter WORKGROUP\ora's password:
Anonymous login successful
Sharename Type Comment
--------- ---- -------
htdocs Disk Shared dir
IPC$ IPC IPC Service (Samba Server 4.10.4)
Reconnecting with SMB1 for workgroup listing.
Anonymous login successful
Server Comment
--------- -------
Workgroup Master
--------- -------
WORKGROUP ORALIN76
smbpasswd -a ora answer when asks : MYSHORTPSW
Added user ora.
not : gedit /etc/passwd gedit /etc/shadow
gedit /etc/samba/smbusers and put linusr=winusr so (Only user security model uses Samba passwords) :
in npp ctrl+o Z:\etc\samba\smbusers
ora = ss
root = admin administrator root
nobody = guest nobody pcguest smbguest
To access a share on a Samba server from Windows Explorer :
\server_name\share_name or only \server_name
\oralin76\htdocs or only \oralin76
C:\Program Files\Oracle\VirtualBox
λ ping 192.168.5.13
Pinging 192.168.5.13 with 32 bytes of data:
Reply from 192.168.5.13: bytes=32 time=5ms TTL=64
Reply from 192.168.5.13: bytes=32 time=14ms TTL=64
Reply from 192.168.5.13: bytes=32 time=13ms TTL=64
Reply from 192.168.5.13: bytes=32 time=16ms TTL=64
Average = 12ms
https://wiki.centos.org/HowTos/SELinux
'chcon' command may be used to change SELinux security context of a file or files/directories in a similar way to how 'chown' or 'chmod' may be used to change the ownership or standard file permissions of a file.
Using Apache as an example, suppose you want to change the DocumentRoot to serve web pages from a location other than the default /opt/lampp/htdocs (/var/www/html/) directory. Assume we create a directory (or maybe a mount point) at /html/ and create an index.html file there:
mkdir /html
touch /html/index.html
ls -Z /html/index.html
outputs : -rw-r--r-- root root user_u:object_r:default_t /html/index.html
ls -Z | grep html
drwxr-xr-x root root user_u:object_r:default_t html
We see that both the directory /html/ and file /html/index.html have the security context type: default_t. If we start our web browser and try to view the page, SELinux will properly deny access and log the error because the directory and file(s) have the wrong security context. We need to set the correct security context type for Apache of: httpd_sys_content_t.
chcon -v --type=httpd_sys_content_t /html
context of /html changed to user_u:object_r:httpd_sys_content_t
chcon -v --type=httpd_sys_content_t /html/index.html
context of /html/index.html changed to user_u:object_r:httpd_sys_content_t
ls -Z /html/index.html
-rw-r--r-- root root user_u:object_r:httpd_sys_content_t /html/index.html
ls -Z | grep html
drwxr-xr-x root root user_u:object_r:httpd_sys_content_t html
Equally we could have set both in one go using the -R recursive switch:
chcon -Rv --type=httpd_sys_content_t /html
Modifying security contexts in this manner will persist between system reboots but only until the modified portion of the filesystem is relabeled. This is a not uncommon operation and the proper solution, after testing, is to write a local custom rule (a so-called Policy Module) and merge it into the base local rules. This will be an additional rule on top of the 200+ rules mentioned above. To make the security context changes permanent, even through a complete filesystem relabel, we can use the SELinux Management Tool or the 'semanage' command from the command line:
semanage fcontext -a -t httpd_sys_content_t "/html(/.*)?"
to add a file context of type httpd_sys_content_t for everything under /html.
# See smb.conf.example for a more detailed config file or
# read the smb.conf manpage.
# Run 'testparm' to verify the config is correct after
# you modified it.
[global]
workgroup = WORKGROUP
security = user
server string = Samba Server %v
####backend used to store user information in. No additional configuration is required for tdbsam :
passdb backend = tdbsam
####I gave this name :
netbios name = oralin76
####dns proxy = no
####server min protocol = SMB2_10
####client min protocol = SMB2
####client max protocol = SMB3
####ntlm auth = yes
wins support = yes
local master = yes
preferred master = yes
####
printing = cups
printcap name = cups
load printers = yes
cups options = raw
####[homes]
####comment = Home Directories
####valid users = %S, %D%w%S
####browseable = No
####read only = No
####inherit acls = Yes
####
####[printers]
####comment = All Printers
####path = /var/tmp
####printable = Yes
####create mask = 0600
####browseable = No
####
####[print$]
####comment = Printer Drivers
####path = /var/lib/samba/drivers
####write list = @printadmin root
####force group = @printadmin
####create mask = 0664
####directory mask = 0775
[printers]
comment = All Printers
#### location of a spooling directory that receives print jobs from Win clients before submitting them to the local print spooler. Samba advertises all locally configured printers on the server.
path = /var/spool/samba
browseable = no
guest ok = yes
writable = no
printable = yes
####unknown param : printer admin = root, @ntadmins, @smbprintadm
[homes]
comment = User home directories
####=personal share for each user in the smbusers group - browsable and writable prevent other users from browsing home directories, while allowing full access to valid users
valid users = @smbusers
browsable = no
writable = yes
guest ok = no
####share /usr/local/apps, for Windows users : browsing (read-only permission) : admin:///opt/lampp/htdocs
[htdocs]
comment = Shared dir
path = /opt/lampp/htdocs
browsable = yes
writable = yes
guest ok = yes
valid users = ora
[global]
workgroup = WORKGROUP
security = user
server string = Samba Server %v
####dns proxy = no
####I gave this name :
netbios name = oralin76
####server min protocol = SMB2_10
####client min protocol = SMB2
####client max protocol = SMB3
ntlm auth = yes
wins support = yes
local master = yes
preferred master = yes
####
load printers = yes
printing = cups
printcap name = cups
[printers]
comment = All Printers
#### location of a spooling directory that receives print jobs from Win clients before submitting them to the local print spooler. Samba advertises all locally configured printers on the server.
path = /var/spool/samba
browseable = no
guest ok = yes
writable = no
printable = yes
#unknown param : printer admin = root, @ntadmins, @smbprintadm
[homes]
comment = User home directories
####=personal share for each user in the smbusers group - browsable and writable prevent other users from browsing home directories, while allowing full access to valid users
valid users = @smbusers
browsable = no
writable = yes
guest ok = no
####share /usr/local/apps, for Windows users : browsing (read-only permission) : admin:///opt/lampp/htdocs
[htdocs]
comment = Shared dir
path = /opt/lampp/htdocs
browsable = yes
writable = yes
guest ok = yes
valid users = ora
systemctl enable smb.service
systemctl enable nmb.service
systemctl restart smb.service
systemctl restart nmb.service
Turn on the Samba server and make sure it starts automatically on reboot.
service smb start
systemctl enable smb.service
or chkconfig smb on
service smb restart
Redirecting to /bin/systemctl restart smb.service
You can check samba services by running ps -eaf | grep smbd; ps -eaf | grep nmbd Now go to the windows Run prompt and type \yourhostname\anonim. \ssvbox\anonim \10.0.2.15\anonim and 10.0.2.2 Thats it!! You will be able to access anonymous shared drive by now. Windows cant communicate with the device or resource (10.0.2.15). The computer or service you are trying to reach might be temporarily unavailable.
If this doesnt connect to the shared folder make sure your firewall services are stopped and try again. You can run below commands to stop the services. service firewalld stop -----Redirecting to /bin/systemctl stop firewalld.service service iptables stop ---- Unit iptables.service not loaded.
Now test shared folder by creating a sample text file on linux machine and opening it on windows machine.
https://www.youtube.com/watch?v=oRHSrnQueak 2018 https://www.youtube.com/watch?v=iXcMxo6f1kA 2017
https://www.youtube.com/watch?v=_MlD21kcHVc
https://www.youtube.com/watch?v=bDF8hLM1iUM
https://www.youtube.com/watch?v=IMPEjYoP3N4 2018 year 25 minutes
https://www.youtube.com/watch?v=OhOPCbM2JUY 2016 year 23 minutes
oct.2018, oct.2019 :
https://www.dataneb.com/blog/samba-installation-on-oel-oracle-enterprise-linux-configuration-and-file-sharing
http://www.samba.org/ http://www.samba.org/samba/what_is_samba.html
http://www.dataneb.com/single-post/2018/05/16/Installing-Oracle-Linux-on-Virtual-Box
Static hostname: oralin76
Icon name: computer-vm
Chassis: vm
Machine ID: eed0ccecb5878547bcf515f9e0477887
Boot ID: 494e06c2fca94c01b68be39aa9115ce9
Virtualization: kvm
Operating System: Oracle Linux Server 7.8
CPE OS Name: cpe:/o:oracle:linux:7:8:server
Kernel: Linux 4.14.35-1902.300.11.el7uek.x86_64
Architecture: x86-64
NAME="Oracle Linux Server"
VERSION="7.8"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.8"
PRETTY_NAME="Oracle Linux Server 7.8"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:8:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"
ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.8
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.8
[root@oralin76 ~]# systemctl status vboxadd
● vboxadd.service
Loaded: loaded (/opt/VBoxGuestAdditions-6.1.2/init/vboxadd; enabled; vendor preset: disabled)
Active: active (exited) since Mon 2020-04-13 15:38:49 CEST; 18min ago
[ss@ssvbox ~]$ whoami ss [ss@ssvbox ~]$ sudo bash
[root@ssvbox ss]# whoami root [root@ssvbox ss]# cd [root@ssvbox ~]# ping -c 3 www.google.com
64 bytes from fra16s24-in-f4.1e100.net (216.58.207.36): icmp_seq=1 ttl=51 time=24.5 ms 64 bytes from fra16s24-in-f4.1e100.net (216.58.207.36): icmp_seq=2 ttl=51 time=24.3 ms 64 bytes from fra16s24-in-f4.1e100.net (216.58.207.36): icmp_seq=3 ttl=51 time=24.4 ms
--- www.google.com ping statistics --- 3 packets transmitted, 3 received, 0% packet loss, time 2003ms rtt min/avg/max/mdev = 24.307/24.434/24.545/0.097 ms
[root@ssvbox ~]# uname -a Linux ssvbox 4.14.35-1818.3.3.el7uek.x86_64 #2 SMP Mon Sep 24 14:45:01 PDT 2018 x86_64 x86_64 x86_64 GNU/Linux [root@ssvbox ~]# yum install kernel-uek-devel-$(uname-r) bash: uname-r: command not found... Loaded plugins: langpacks, ulninfo ---------- was unsuccesfull : https://www.youtube.com/watch?v=GKvCTKoPIrQ No package kernel-uek-devel- available. Error: Nothing to do [root@ssvbox ~]# yum install kernel-uek-devel-$(uname -r) Loaded plugins: langpacks, ulninfo No package kernel-uek-devel-4.14.35-1818.3.3.el7uek.x86_64 available. BECAUSE 1992 is available (first update os then from sys -> sw install that kernel-uek-devel) Error: Nothing to do [root@ssvbox ~]#
Verifying archive integrity... All good.
Uncompressing VirtualBox 6.0.8 Guest Additions for Linux........
VirtualBox Guest Additions installer
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules. This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup \
---------- was unsuccesfull : https://www.youtube.com/watch?v=GKvCTKoPIrQ do all with one command as root : sudo bash uname -a ---------- was unsuccesfull : yum install kernel-uek-devel-$(uname -r)
This will install all the prereqs and necessary packages you explained in your video.Then all you need to do is insert the Guest Additions in your vms ROM drive and install the Guest Additions. Then goto Devices and enable Drag and Drop, Shared Clipboard and Shared Folder (configuring your desired shared folder)
After installing guest additions you will need to add your non root users to the vboxsf group so you can access the Shared Folder and reboot.
sudo usermod -a -G vboxsf \
[global]
#editat la ora 20:30 in data 07.06.2017
server max protocol = SMB3
encrypt passwords = yes
dns proxy = no
strict locking = no
oplocks = yes
deadtime = 15
max log size = 51200
max open files = 933761
logging = file
load printers = no
printing = bsd
printcap name = /dev/null
disable spoolss = yes
getwd cache = yes
guest account = nobody
map to guest = Bad User
obey pam restrictions = yes
directory name cache size = 0
kernel change notify = no
panic action = /usr/local/libexec/samba/samba-backtrace
nsupdate command = /usr/local/bin/samba-nsupdate -g
server string = Media Server
# habarnam de ce dar urmatoarele lini au importanta in wingoz
ea support = yes
store dos attributes = yes
lm announce = yes
hostname lookups = yes
# time server nu conteaza dar mi-l trebuie
time server = yes
acl allow execute always = true
dos filemode = yes
multicast dns register = yes
domain logons = no
local master = yes
idmap config *: backend = tdb
idmap config *: range = 90000001-100000000
server role = standalone
netbios name = MEDIA SERVER
workgroup = WORKGROUP
# am incercat si cu = share si apar erori la pornirea samba
security = user
pid directory = /home/server-media/Desktop/test
# aici am incercat cu mai multe variante ca si 0775 sau 0700 sau 0600 etc.
create mask = 0666
directory mask = 0777
client ntlmv2 auth = yes
# asta iara nu mai e important!
dos charset = CP437
unix charset = UTF-8
log level = 1
[homes]
comment = Home Directories
path = /home
valid users = %U
read only = no
available = yes
browseable = yes
writable = yes
guest ok = no
public = no
printable = no
locking = no
strict locking = no
[netlogon]
comment = Network Logon Service
path = /var/lib/samba/netlogon
#din no in yes la read
read only = yes
available = yes
browseable = yes
writable = no
#din no in yes la guest
guest ok = yes
public = no
printable = no
locking = no
strict locking = no
[profiles]
comment = User Profiles
path = /var/lib/samba/profiles
read only = no
available = yes
browseable = yes
writable = yes
guest ok = no
public = no
printable = no
#din 0600
create mode = 0666
#din 0700
directory mask = 0777
locking = no
strict locking = no
[printers]
comment = All Printers
path = /var/spool/samba
browseable = yes
writable = no
#guest am pus yes
guest ok = yes
public = no
printable = yes
locking = no
strict locking = no
#am bagat urm linii
read only = no
create mask = 0775
[pdf-documents]
path = /var/lib/samba/pdf-documents
comment = Converted PDF Documents
admin users = %U
available = yes
browseable = yes
writeable = yes
guest ok = yes
locking = no
strict locking = no
[pdf-printer]
path = /tmp
comment = PDF Printer Service
printable = yes
guest ok = yes
use client driver = yes
printing = bsd
print command = /usr/bin/gadmin-samba-pdf %s %u
lpq command =
lprm command =
[test]
path = /home/server-media/Desktop/test
comment = doar de test
valid users = test
write list = test
admin users = test
directory mask = 0755
create mode = 0777
read only = no
available = yes
browseable = yes
writable = yes
guest ok = no
public = yes
printable = no
locking = no
strict locking = no
Advanced sharing settings. Make sure that in the Private network profile section the following options checked:
Turn on network discovery + Turn on automatic setup of network connected devices;
Turn on file and printer sharing;
no more Allow Windows to manage homegroup connections (recommended).
Then enable the following options in the All networks section:
Turn on sharing so anyone with network access can read and write files in the Public folders;
Turn off password Protected Sharing (if you trust all the devices in your network);
Thus, you can open anonymous network access to your computer. So, when you enable this option, you must correctly set the permissions on the shared network folders and printers.
If there are legacy network devices in your network (old Windows version, Samba shares, NAS devices), enable the option “Enable file sharing for devices that use 40-bit or 56-bit encryption”.
sspc2\ss MB Asus Link-local IPv6 address: fe80::55f0:dde8:14c3:8d5d%15 IPv4 address: 192.168.5.12 IPv4 DNS servers: 213.191.128.8 213.191.128.9 Manufacturer: Realtek Description: TP-Link Gigabit PCI Express Adapter Driver version: 10.38.1118.2019 Physical address (MAC): 50-3E-AA-08-23-F8
Starting with Windows 10 1709 and Windows Server 2019 (both in Datacenter and Standard editions), the unsafe SMBv1 protocol is disabled by default because of CVE-2017-0144 (remember the WannaCry ransomware attack, which was implemented through the SMBv1 vulnerability), as well as anonymous (guest) access to network shared folders.
Win10 Settings -> Network and Internet -> Ethernet (or select Wi-Fi, if you are connected to a local network through a wireless connection). Click the "Network" icon and verify that "Private" ee Make this PC discoverable option is enabled.
To enable the Network Discovery traffic on Windows 10 Defender Firewall, you must run the following command in the elevated command prompt:
Or you can enable the network discovery traffic in Windows Firewall with the PowerShell : Get-NetFirewallRule -DisplayGroup "Network Discovery" -Enabled True -Action Allow -Direction Inbound
Also, you can manually enable the Network Discovery protocol for at least the Private network in the Windows Defender Firewall settings (Control Panel\All Control Panel Items\Windows Defender Firewall\Allowed apps).
In some cases, Windows computer may not be displayed in the network environment due to incorrect workgroup settings. Try to re-add this computer to the workgroup. Go to the Control Panel -> System and Security -> System -> Change Settings -> Network ID.
If these tips did not help, and the computers in the workgroup are still not displayed, try to reset the network settings (Settings -> Network and Internet -> Status -> Network Reset).
You can also reset the network settings and firewall rules with the commands:
netsh int ip reset reset.txt netsh winsock reset netsh advfirewall reset
Then you need to reboot the computer.
In some cases, you need to completely remove your network adapter using the Device Manager (run the devmgmt.msc console -> Network Adapters -> your network card -> Delete device).
Then restart your computer. Windows should automatically detect your network adapter and install the appropriate drivers. In this case, all old protocol settings for the network card will be reset.
Also, check whether the following services are running (they should be in the automatic startup state to correctly display your network environment). Run the services.msc console and check the services state:
In some cases, third-party anti-viruses and firewalls can block NetBIOS name resolution requests, WDS and broadcast DNS queries (there was definitely a problem with ESET NOD32). Try to temporarily disable your antivirus/firewall and check if the network discovery works properly on your Windows 10 device.
J:\symenu\ProgramFiles\SPSSuite\SyMenuSuite\Cmder_sps
λ arp /a
Interface: 192.168.56.1 --- 0x7
Internet Address Physical Address Type
192.168.56.255 ff-ff-ff-ff-ff-ff static
224.0.0.22 01-00-5e-00-00-16 static
224.0.0.251 01-00-5e-00-00-fb static
224.0.0.252 01-00-5e-00-00-fc static
239.255.255.250 01-00-5e-7f-ff-fa static
255.255.255.255 ff-ff-ff-ff-ff-ff static
Interface: 192.168.5.12 --- 0xf
Internet Address Physical Address Type
192.168.5.1 64-6e-ea-66-9e-43 dynamic
192.168.5.13 08-00-27-ec-1d-e8 dynamic
192.168.5.255 ff-ff-ff-ff-ff-ff static
224.0.0.2 01-00-5e-00-00-02 static
224.0.0.22 01-00-5e-00-00-16 static
224.0.0.251 01-00-5e-00-00-fb static
224.0.0.252 01-00-5e-00-00-fc static
239.255.255.250 01-00-5e-7f-ff-fa static
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
http://oralin76/fwphp/www = fwphp site on vbox PC oralin76
This site can’t be reached ERR_CONNECTION_REFUSED why ? Firewal
Same for http://192.168.5.13/fwphp/www
https://www.ionos.com/digitalguide/hosting/technical-matters/err-connection-refused/
$> netstat -an | grep "LISTEN " if outputs this : tcp 0 0 127.0.0.1:3000 0.0.0.0:*
Only 127.0.0.1:3000 is listed in netstat output meaning server is listening on the localhost interface only, ee you won't be able to access it from a remote computer.
Use "0.0.0.0" - I believe this acts as a wildcard, now allowing for public resolution via the domain name and it also works with "localhost". Here's a link to a serverfault page on the 0.0.0.0 topic:
https://serverfault.com/questions/78048/whats-the-difference-between-ip-address-0-0-0-0-and-127-0-0-1
chances are you need only do http://192.168.5.13 or http://oralin76
if 1. doesnt work,may be firewall running on your computer - work out how to add port 80 to it to let other machines in. In Windows : Control Panel > Windows Firewall > Allow an app through Windows Firewall > Allow another app > Browse to: XAMPP/apache/bin/httpd.exe and allow it (see https://www.tomshardware.com/news/how-to-open-firewall-ports-in-windows-10,36451.html).
or httpd.conf is only listening on 127.0.0.1
See J:\awww\www\zinc\img\img_big\site_on_LAN_or_WEB.png :
#### First VirtualHost section is default or fallback virtual host (testing site),
#### used f or all requests that do not match **ServerName or ServerAlias**
#### in any <VirtualHost> block.
#### 8083 0r 80 :
<VirtualHost *:8083>
DocumentRoot "/xampp/htdocs/"
ServerName localhost
</VirtualHost>
#### sets up a virtual host named dev1 (development site)
#### To see http://dev1:8083/fwphp/www/ (dev1 is apache virtual host) :
<VirtualHost *:8083>
DocumentRoot "J:/awww/www/"
#### on oralin76 PC : oralin76.sspc (symfony.local) :
ServerName dev1
</VirtualHost>
For the client (your browser in that case) to understand what dev1 means, you need to edit the hosts file on your computer. Everytime you type an URL in your browser, your computer tries to understand what it means! dev1 doesn't mean anything for a computer. So it will try to resolve the name dev1 to an IP address. It will do this by first looking into the hosts file on your computer to see if he can match an IP address to what you typed in the address bar. If it can't, then it will ask DNS servers. The trick here is to append 127.0.0.1 localhost dev1
to your hosts file :
From now on, everytime you type dev1 on this computer, your computer will use the loopback interface to connect to dev1. It will understand that you want to work on localhost (127.0.0.1).
We need to tell the other computers how they could find localhost eg on oralin76.
3a Get the IP address of the computer hosting the website:
In the terminal (CLI),
ipconfig
Let's assume the IP address of oralin76 is 192.168.5.13 . 3b Edit hosts file on oralin76 computer you are trying to access the website from :
Trick is to use IP address of oralin76 (computer we are trying to access/talk to):
192.168.5.13 oralin76.sspc2
You can now go into your browser and type http://oralin76.sspc2 (symfony.local) to beautifully see your website on different computers! Note that you can apply the same strategy if you are a OSX user to test your website on Internet Explorer via Virtual Box (if you don't want to use a Windows computer). This is beautifully explained in Crafting Your Windows / IE Test Environment on OSX
http://www.studiobanks.com/blog/post/279/crafting-your-windows-ie-test-environment-on-osx-106.
You can also access your localhost from mobile devices, see http://egalo.com/2012/05/29/testing-mac-web-site-using-local-hostname-on-mobile-device/
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
How we can see RHEL type linux 64 bit share in Windows 10 64 bit Network folder ?
I can in Linux file explorer ctrl+c, v files on win10 to/from Linux.
With WinSCP FTP I can sync website tree.
chown -R someuser:somegroup /your/folder/here/* (Recursive mode only works on directories, not files.)
This will apply chown to all files and all subdirectories and sub-subdirectories of the specified folder. Use with care.
sudo chown -R oracle:oracle /opt/lampp/htdocs/fwphp/ On Debian Linux : var/www/html/fwphp
sudo chmod 755 /opt/lampp/htdocs/fwphp -R
WinSCP FTP -> "New session" icon -> button "Edit" -> button "Advanced" assign SFTP value : /usr/libexec/openssh/sftp-server assign Shell value : sudo su -
See http://dev1:8083/fwphp/glomodul/mkd/?edit=01/001_config_ssl_tls/ftp.txt
/opt/lampp/htdocs /u01/userhome/oracle
To create or delete file you need have a write permissions to the directory;
To change file or directory permissions you need to be its owner;
To change file modification time you need to be its owner (note that by default WinSCP updates file modification time when uploading).
Top | VBox | VM | Utils | XAMPP | Samba | Deploy | Lin. site access | Ora 11g
on Ora Linux 64 bit
See mikesmithers
cd $HOME/Downloads or cd ~/Downloads
[root@oralin76 ora11gxe]# mkdir ora11gxe
cd ora11gxe
ls -alF
cp //media/sf_JWIN/a_instl/oralinux/oracle-xe-11.2.0-1.0.x86_64.rpm.zip .
chmod 776 oracle-xe-11.2.0-1.0.x86_64.rpm.zip
done : -rwxr-x---. to -rwxrwxrw-.
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
Archive: oracle-xe-11.2.0-1.0.x86_64.rpm.zip
creating: Disk1/ - here are .rmm and 2 dirs
creating: Disk1/upgrade/
inflating: Disk1/upgrade/gen_inst.sql
creating: Disk1/response/
inflating: Disk1/response/xe.rsp
inflating: Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
cd Disk1
Preparing... /var/tmp/rpm-tmp.rBXMH8: line 257: [: 18446744073692774399: integer expression expected
/var/tmp/rpm-tmp.rBXMH8: line 271: [: 18446744073692774399: integer expression expected
Updating / installing... 1:oracle-xe-11.2.0-1.0
Executing post-install steps... You must run '/etc/init.d/oracle-xe configure' as the root user to configure the database.
This will configure on-boot properties of 11g XE. The following questions will determine whether DB should be starting upon system boot, ports it will use, passwords that will be used for DB accounts.
Press ENTER to accept the defaults. Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:8085
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts - same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration:
Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:y
Starting Oracle Net Listener...Done Configuring database...Done Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
We need to re-boot Linux so that Linux menu items in App -> Other are visible.
NOTE : from this point on you can stop being root (although you may need to sudo occasionally).
To confirm that your database is up and running :
conn system/pwd
select sysdate from dual
/
Log on with root permissions is not needed.
do not exit (from root user)
DB XE provides a script that sets environment variables :
cd /u01/app/oracle/product/11.2.0/xe/bin
[ora@oralin76 bin]$ cat /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=$ORACLE_HOME/bin/nls_lang.sh
export PATH=$ORACLE_HOME/bin:$PATH
No need : gedit ./oracle_env.sh
sudo gedit /u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh
At end : NLS_LANG=${nlslang}.${charset} should be : NLS_LANG="${nlslang}.${charset}"
. ./oracle_env.sh
echo $ORACLE_HOME
echo $ORACLE_SID
echo $NLS_LANG
echo $PATH
[ora@oralin76 bin]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/xe
[ora@oralin76 bin]$ echo $ORACLE_SID
XE
[ora@oralin76 bin]$ echo $NLS_LANG
AMERICAN_AMERICA.AL32UTF8
[ora@oralin76 bin]$ echo $PATH
/u01/app/oracle/product/11.2.0/xe/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/usr/sbin:/bin:/sbin:/var/lib/snapd/snap/bin:/home/ora/.local/bin:/home/ora/bin
Oracle bin directory is now at the start of $PATH.
We need to ensure that these environment variables are set for all sessions :
sudo cp /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh /etc/profile.d/
To check this, you can start a new terminal session and echo the environment variables to make sure they have been set.
Getting the Menu Items to Work - make sure that the oracle user, as well as your own user, is a member of the dba group :
sudo usermod -a -G dba oracle
sudo usermod -a -G dba ss
sudo grep dba /etc/group
dba:x:1001:oracle
Right-click icon and select Properties.
In the Permissions Tab check the box to "Allow executing file as program".
Icon has transformed into Oracle beehive and is now called "Get Started With 11g XE".
Installation on Red Hat system is reasonably painless when compared with doing the same thing on a Debian system.
run it :
./oracle/env.sh
cd /etc/skel
ls -la | grep .bash_profile
Edit login or profile files so that these environment variables are set each time you log in or open a new shell :
gedit .bash\profile
enter the following line at end /etc/skel/.bash\profile
:
/u01/app/oracle/product/11.2.0/xe/bin/oracle\_env.sh
Starting Oracle Database XE
To start the database manually, run this command as root user:
/etc/init.d/oracle-xe start or /etc/init.d/oracle-xe stop
or :
After you have installed Oracle Database XE, DB is up and running and you can start it if it is currently stopped:
Main menu (on Gnome)->Oracle Database 11g Express Edition
or Applications->Other menu (on KDE),
and then click Start Database or Run SQL Command Line or...
Connect to the database using the user name SYSTEM, and supply the password that you created during configuration.
conn sys/ss141 as SYSDBA (system can not)
On ssoralin73@oralin73 Ora Linux 7.3 64 bit
1-- [ssoralin73@oralin73 ~]$
su -
links = browser
ctrl+shift+t = new tab terminal
su -
mc (Midnight commander)
in ms's left pane: cd /media/**sf_2_oralinux/
in ms's right pane: cd /home/ssoralin73
F5 (copy) oracle-xe-11.2.0-1.0.x86_64.rpm.zip left -> right
**
# gedit /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
# For more information, see sysctl.conf(5) and sysctl.d(5).
fs.file-max = 6815744
https://www.oracle.com/database/technologies/112010-linx8664soft.html
https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6
Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled.
Unzip both zip files and 7 path zip-s and you will see "database" folder created.
/etc/hosts
127.0.0.1 localhost.localdomain localhost
192.168.0.181 ol6-112.localdomain ol6-112
<ip address > <full name of machine > <short name of your machine>
oracle@t01odsdev201:/opt/oracle/11.2.0.3 INT$ cd database
oracle@t01odsdev201:/opt/oracle/11.2.0.3/database INT$ ls
doc install readme.html response rpm runInstaller sshsetup stage welcome.html
oracle@t01odsdev201:/opt/oracle/11.2.0.3/database INT$ export DISPLAY=10.109.38.156:0
oracle@t01odsdev201:/opt/oracle/11.2.0.3/database INT$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 3893 MB Passed Checking swap space: must be greater than 150 MB. Actual 9565 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-05_03-55-01PM. Please wait ...oracle@t01odsdev201
December 3, 2014 https://shi2wei3.github.io/posts/2014-12-03-oracle-11g-xe-on-rhel7.html
database
The prerequisite is i assume you already got a RHEL7 installed with GNOME3
it needs swap volume at least specify space 2 x memory (12 GB)
unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
cd Disk1
sudo rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm
su -
cd /home/ssoralin73
chmod 776 oracle-xe-11.2.0-1.0.x86_64.rpm.zip
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip
unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
cd instantclient_12_2
ls -l
ln -s libclntsh.so.12.1 libclntsh.so
ln -s libocci.so.12.1 libocci.so
To avoid error ee to see libsqlplus.so :
./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
export LD_LIBRARY_PATH=$(pwd)
./sqlplus sys/ss141@localhost/XE as SYSDBA (system can not)
alter user hr account unlock;
alter user hr identified by hr;
grant CONNECT,DBA,RESOURCE to hr IDENTIFIED BY hr;
or grant create table to hr; ...
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
# cd /home/ssoralin73/instantclient_12_2
# ./sqlplus hr/hr@localhost/XE
put all three rpm in some tmp dir and :
ls *rpm
rpm -i *rpm
ls /usr/lib/oracle/12.1/client64/lib
ls /usr/lib/oracle/12.1/client64/bin - here is sqlplus dir
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
/usr/lib/oracle/12.1/client64/bin/sqlplus hr/hr@localhost/XE
or :
sudo rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
sudo rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
If you got the error below, you need to add library path manually: sqlplus64: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/12.1/client64/lib/
/usr/bin/which: no sqlplus in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
# updatedb
# locate sqlplus
/home/ssoralin73/instantclient\_12\_2/sqlplus
/u01/app/oracle/product/11.2.0/xe/sqlplus - dir, not script
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus
...
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus hr/hr@localhost/XE
Error 6 initializing SQL\*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE\_HOME to your Oracle software directory
[root@oralin73 instantclient\_12\_2\]# ls -alF
total 219860
drwxr-xr-x. 3 root root 4096 Jul 30 17:59 ./
drwx------. 23 ssoralin73 ssoralin73 4096 Jul 30 17:25 ../
-rwxrwxr-x. 1 root root 44220 Jan 26 2017 adrci\*
...
Install jdk
sudo rpm -ivh jdk-7u72-linux-x64.rpm
sudo rpm -ivh sqldeveloper-4.0.3.16.84-1.noarch.rpm
Update JDK_HOME to SetJavaHome in: ~/.sqldeveloper/4.0.0/product.conf
Add the command below to /usr/local/bin/sqldeveloper: unset GNOME_DESKTOP_SESSION_ID
http://localhost:8085/apex/apex_admin
usr/psw: ADMIN/ss141 ss141 -> Ss141!!
Application Express 4.0.2.00.09
Workspace: INTERNAL User: ADMIN
Language: en | Copyright � 1999, 2010, Oracle. All rights reserved.
if you forgot the admin password, you can change it follow the steps
/etc/init.d/oracle-xe restart
Do experiment for Joel Spolsky's The Law of Leaky Abstractions
...
Outputs:
public
interfaces: enp0s3 (or wlp1s0)
You might have active zone like public, FedoraWorkstation, FedoraServer.
firewall-cmd --permanent --zone=public --add-port=8083/tcp
systemctl restart firewalld.service
Access following address, with your browser. http://your.domain/test.php
http://oralin73/test.php - WORKS !!
192.http://192.168.5.102:8083/test.php - WORKS !!
http://localhost/test.php - WORKS !!
-> Open Web server Port (80) on Iptables Firewall (as root user again)
1. Edit /etc/sysconfig/iptables file:
gedit -w /etc/sysconfig/iptables
2. Add following INPUT rule:
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
3. Restart Iptables Firewall:
service iptables restart ## OR ## /etc/init.d/iptables restart
3. Test remote connection
http://your.domain/test.php
-
L:_ISO_ISO\LINUX\oracle_linux\Instalac11gXE_on_oralin7_6.txt
https://www.virtualbox.org/wiki/Downloads J:\awww\apl\dev1\dev1_zinstalac_dok\linux\oralinux\vbox_UserManual.pdf
file:///L:/1_instalac/1_instalirano/video/centos/Install_CentOS8_on_VirtualBox_Linux_Hint.html - pictures
(https://linuxhint.com/install_centos8_virtualbox/)
https://www.linuxtechi.com/install-configure-samba-centos-8/
https://davidghedini.com/pg/entry/install_oracle_11g_xe_on_centos/
https://www.youtube.com/watch?v=9lMifqB6Y8s
https://www.youtube.com/watch?v=HSPbwezgMno
https://appuals.com/how-to-fix-the-windows-10-file-sharing-not-working-problem/
Why vbox ? Before larger installations we make snapshot to return to (any previos) state-snapshot before (failed) installation.
L:\1_instalac\1_instalirano\linux\1_virtualbox\2_VirtualBox 5.1.26_forWindowshosts_oralinux7.3.txt
L:\1_instalac\1_instalirano\linux\2_oralinux\2_VirtualBox 5.1.26_forWindowshosts_oralinux7.3.txt
L:_ISO_ISO\LINUX\oracle_linux\Instalac11gXE_on_oralin7_6.txt
L:\1_instalac\1_instalirano\linux\2_oralinux\1_instalac_moj_oracle_linux_or_fedora_64bit_virtualbox_Apache_PHP_11gXE.html
L:\2_knjige\linux\z_doc\How to install Oracle Express Edition on Centos_RHEL - COMPUTER TECHNOLOGY SPECIAL.html
EXPENSIVE, NO DB XE SUPPORT, COMPLICATED (more appl. than development SW - APEX BETTER ? PHP ?) :
http://dev1:8083/fwphp/glomodul/z_help/oracle/00oraForms12_instalac_moj.html#download
L:/1_instalac/2_instalac_ora11g/forms_instalac/1_forms11/00_instalac_help/00oraForms11_1_2_2_0_instalac_moj.html
https://github.com/finos/exodus/wiki/Installing-Oracle-Forms-12.2.1.4
Supports all the features that the graphical user interface gives you access to, but it supports a lot more.
C:\Program Files\Oracle\VirtualBox
λ VBoxManage list vms
"Oracle DB Developer VM" {8b1ee087-78c7-4ebf-811f-f6b2836e06c5}
"oralin76" {ecccd0ee-87b5-4785-bcf5-15f9e0477887}
VBoxManage startvm "oralin76" or VBoxManage startvm ecccd0ee-87b5-4785-bcf5-15f9e0477887
VBoxManage createvm --name "SUSE 10.2" --register
Virtual machine ’SUSE 10.2’ is created.
UUID: c89fc351-8ec6-4f02-a048-57f4d25288e5
Settings file: ’/home/username/.config/VirtualBox/Machines/SUSE 10.2/SUSE 10.2.xml’
VBoxManage showvminfo "oralin76" | grep JWIN
To change settings while a VM is powered off, use VBoxManage modifyvm. For example:
VBoxManage modifyvm "Windows XP" --memory 512
• To change the storage configuration, such as to add a storage controller and then a virtual
disk, use VBoxManage storagectl and VBoxManage storageattach. See chapter 8.18,
VBoxManage storagectl, page 173 and chapter 8.17, VBoxManage storageattach, page 169.
• To control VM operation, use one of the following:
– To start a VM that is currently powered off, use VBoxManage startvm. See chapter
8.12, VBoxManage startvm, page 161.
– To pause or save a VM that is currently running or change some of its settings, use
VBoxManage controlvm. See chapter 8.13, VBoxManage controlvm, page 162.
**********if ERROR clipboard sharing not working use instead ver 6.1.4 older ver 6.1.2 (6.1.3 also not working)
Verifying archive integrity... All good.
Uncompressing VirtualBox 6.1.2 Guest Additions for Linux........
VirtualBox Guest Additions installer
Removing installed version 6.1.4 of VirtualBox Guest Additions...
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules. This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
4.14.35-1902.300.11.el7uek.x86_64.
VirtualBox Guest Additions: Running kernel modules will not be replaced until
the system is restarted
Press Return to close this window...
************** NOT WORKING ver. 6.1.4 :
## 30-MART-2020 vbox 6.1.4
sudo /opt/lampp/manager-linux-x64.run
sudo /opt/lampp/xampp start
#### sudo gedit /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
[ora@localhost VBox_GAs_6.1.4]$ sudo ./VBoxLinuxAdditions.run
We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:
#1) Respect the privacy of others.
#2) Think before you type.
#3) With great power comes great responsibility.
[sudo] password for ora:
Verifying archive integrity... All good.
Uncompressing VirtualBox 6.1.4 Guest Additions for Linux........
VirtualBox Guest Additions installer
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules. This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
4.14.35-1818.3.3.el7uek.x86_64.
[ora@localhost VBox_GAs_6.1.4]$