--CMD登录Oracle--
sqlplus / as sysdba
--创建表空间和用户--
select name from v$datafile;
select name from v$datafile;
create tablespace emaoyi
logging
datafile 'D:\app\Administrator\product\11.2.0\dbhome_1\database\emaoyi.dbf'
size 10m
autoextend on
next 10m maxsize 20480m
extent management local;
logging
datafile 'D:\app\Administrator\product\11.2.0\dbhome_1\database\emaoyi.dbf'
size 10m
autoextend on
next 10m maxsize 20480m
extent management local;
create user emaoyi identified by emaoyi
default tablespace emaoyi;
default tablespace emaoyi;
--给用户赋值权限--
grant connect,resource,dba to emaoyi;
grant connect,resource,dba to emaoyi;
--导入DMP文件--
> set oracle_sid=orcl
imp sys/admin file=E:\fzcq.dmp ignore=y full=y
> set oracle_sid=orcl
imp sys/admin file=E:\fzcq.dmp ignore=y full=y
--ORACLE修改密码期限--
SELECT username,PROFILE FROM dba_users;
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
SELECT username,PROFILE FROM dba_users;
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
--关闭防火墙后javaweb项目无法访问--
Windows server 2008 r2 防火墙启用后客户端不能访问Web工程。
那是因为Web工程的端口默认配置为8080或8099端口,需要将端口开启并放入防火墙规则中。
1、先查看端口是否被启用
netsh firewall show portopening
2、添加8099端口到防火墙规则中
netsh firewall add portopening TCP 8099 EManWebPort
--TOMCAT环境变量配置--
新建 CATALINA_BASE,变量值:D:\java\apache-tomcat-8.5.14
2、新建 CATALINA_HOME,变量值:D:\java\apache-tomcat-8.5.14
3、编辑 PATH,添加变量值:%CATALINA_HOME%\lib;%CATALINA_HOME%\bin;
新建 CATALINA_BASE,变量值:D:\java\apache-tomcat-8.5.14
2、新建 CATALINA_HOME,变量值:D:\java\apache-tomcat-8.5.14
3、编辑 PATH,添加变量值:%CATALINA_HOME%\lib;%CATALINA_HOME%\bin;
--Tomcat部署web项目,如何直接通过域名访问,不加项目名称--
修改conf/server.xml文件
在Host 这个元素中间加入如下元素(当然已经有这个元素的情况下只需要把docBase的值改成你自己项目部署路径)
<Context docBase="项目部署路径\项目部署名" path="" reloadable="false"/>