ORACLE_HOME/network/admin/Status:Failure-Testfailed:Listenerrefusedtheconnectionwiththefollowingerror:ORA-12505,TNS:listenerdoesnotcurrentlyknowofSIDgiveninconnectdescriptorSID_LIST_LISTENER=(SID_LIST
1.表空间创建createtablespaceabcdatafile‘/u01/app/oracle/oradata/TestDB11/catalog.dbf’自定义数据文件位置及名字size100Mextentmanagementlocalautoallocate扩展自动管理segmentspacemanagementauto;删除droptablespaceabcincludingconten
vi.bashrcexportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/xeexportORACLE_SID=xe_pmon_XEexportPATH=$PATH:/u01/app/oracle/product/11.2.0/xe/bin1.启动sqlplus/assysdba
1.初次启动#mysqlupdatemysql.usersetauthentication_string='newpass',plugin='mysql_native_password'whereuser='root';flushprivileges;exit;$mysql-uroot-p//本地登陆$mysql-ualoha-p-hip//远程登陆
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号