Server environment jdk1.8.0_212 + jboss-eap-6.4 system is Service R2
The data server oracle12c system is Service R2
When you first install the Oracle database, there is no big problem, reference step: http://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.html
After installation, configure the environment variable reference: http://jingyan.baidu.com/article/e73e26c0c20f1a24adb6a73e.html
1. Configure Home
Variable name oracle_home variable value E:\Oracle\product\11.2.0\dbhome_1
2. Configure tns_admin variable name tns_admin variable value E:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
3, the configuration code is used to solve the garbled variable name Nls_lang. The variable value simplified Chinese_china. Zhs16gbk
Because you want to create a database user, and then know that it is in the CDB, you can only create global users (C # #开头), at first think it is a configuration error, and finally know that it is necessary to add C # #的 (the previous version is not required),
To create a new user:
Create User by password;
Give permissions to the user (the permissions here are the highest, of course you can categorize them with):
Grant to user name; Grant Administrator Permissions
Grant CreateSession toZhangsan;//Grant Zhangsan user permission to create session, that is, login permissionGrantUnlimited tablespace toZhangsan;//granting Zhangsan users permission to use tablespacesGrant Create Table toZhangsan;//granting permissions to create tablesGrant Drop Table toZhangsan;//granting permission to delete a tableGrant Insert Table toZhangsan;//permissions to insert tablesGrant Update Table toZhangsan;//permissions to modify tablesGrant All to Public;//This one is more important, giving all permissions ( All) to all Users ( Public)
Reference: http://www.cnblogs.com/shlcn/archive/2011/07/21/2112879.html
Because the default Oracle database port is 1521, you need to open the port for external access:
How to do this: Control Panel-"System Security-" window Firewall-Advanced Settings-"Inbound rules (outbound rules) interface to the right can be new
Specific Tutorial reference: http://jingyan.baidu.com/article/ae97a646d42dc8bbfd461d1b.html
According to the above steps can be successfully installed in the database, and can be in the same LAN other terminal access, you can test, on another computer on the top of a plsql test.
The following is the configuration of JDK and JBoss two, JDK and JBoss can download a compressed version or the installation version. But remember to configure the environment variables after the installation is complete
JDK environment variable configuration:
Create a new Java_home type: E:\Java\jdk1.8.0 //java installed path: At the end, type;%java_home%\bin;%java_home%\jre\bin; new CLASSPATH type: .; %java_home%\lib;%java_home%\lib\tools.jar
JBoss Environment Traversal configuration:
New Jboss_home type: E:\jboss //jboss installation directory
Find path
At the end, type:;%jboss_home%\bin;
In this way, the basic software is installed successfully, but we want to external access, but also need to open the port, specific reference to the above method
The ports that JBOSS involves are 8080 and 9990, and of course you can change the port through the configuration file, but the port is still open.
(Take standalone as an example) this time find Standalone.bat under the bin of the JBoss installation directory (this is the window System), then double-click and JBoss will start
After successful startup, enter in the browser: http://localhost:8080/The following interface appears, it means that JBoss is installed
Select the first option:Administration Console is to enter the console, Of course, this time will jump out of the following:
This is because we need to create a user, have a Add-user.bat click in the JBoss Bin directory, select a, then enter the account password (the password will not be echoed), then log in to the console again and then enter the account password to sign in and yes 、、、。
At this time, you can access the localhost:8080 on this machine, but to enter the corresponding ip:8080 on the other host in the same LAN is not accessible, that is because it needs to be set under: E:\jboss-eap-6.4.0\standalone\ The standalone.xml below the configuration found this.
<Interfaces> <Interfacename= "Management"> <inet-addressvalue= "${jboss.bind.address.management:127.0.0.1}"/> </Interface> <Interfacename= "Public"> <inet-addressvalue= "${jboss.bind.address:127.0.0.1}"/> </Interface> <!--Todo-only Show this if the Jacorb subsystem is added - <Interfacename= "unsecure"> <!--~ used for IIOP sockets in the standard configuration. ~ To secure Jacorb-need to setup SSL - <inet-addressvalue= "${jboss.bind.address.unsecure:127.0.0.1}"/> </Interface> </Interfaces>
Change the 127.0.0.1 to 0.0.0.0 so that the other PC side of the same LAN can be accessed.
Here's how to add a data source---tomorrow is on the mend.
Documenting issues with Javaweb deployment to JBoss