DB Hosting Problem
I am going through hosting process of my website. I build my db with oracle 9i. i bought a dedicated server which is not managed dedicated server but the hosting company has configured and provided all passwords including root to me as well as the following info provided regarding db
ORACLE
oracle owner: oracle
oracle home: /opt/oracle/product/10.2/db_1 unix DBA group: disk
starter database:
global database name: orcl
user: SYSTEM
database password: password
server parameter filename: /opt/oracle/product/10.2/db_1/dbs/spfileorcl.ora
database control url: http://domainNaem.com:1158/em
iSQL*PLus URL:
http://domainName.com:5560/isqlplus
iSQL*Plus DBA URL:
http://domainName.com:5560/isqlplus/dba
EnterpriseManager DB Control URL:
http://domainName.com:1158/em
with URL http://domainName.com:5560/isqlplus i am able to create db but facing the following problems:
1. I want to know how i'll import data from my labtop to web db as when am accessing my server and giving command ./imp it asks for login/pass but message appears
IMP-00058: ORACLE error 12546 encountered
ORA-12546: TNS:permission denied
IMP-00000: Import terminated unsuccessfully
2. how can i see the db is connected or not using tomcat
3. i putted the *.jar files from oracle jdbc/lib to WEB-INF/lib but the db driver is not connecting as java.NullPointerException appears to all of my webpages. my connection code is:
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
cnn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:gswsid","dbName","dbPassword");
stm=cnn.createStatement();
ResultSet rs;
}catch(Exception e){
System.out.println("DB is not Connected"+e.toString());
}
}
