Create Oracle Host
I'm new to Oracle, I downloaded Oracle 9i and want to use the SQL applications. It asks me for user name and password and host string. It didn't ask me to create these when I installed the software. So what is a host string and how do I create it and create a username and password for it. Mohammad simply type in host string as "scott" and pwd as "tiger". Lokesh Bohra There are default accounts created, following are their user name and
passwords
Abdul Qadir Thank you all. But unfortunatlly it didn't work, I tried all of them What do you think the problem is? Mohammad This means you have not configured your tnsnames. It is available in orahome/network/admin directory, insert the entry for your database and then try to connect. Alternately you can use net configuration assistant. Sumit If you are interested to create new user you must connect with dba right . So by default in oracle user system and user sys has dba right therefore initially you use user name as sys and by default sys password is change_on_install. After connecting the above user name & password you write command
on sqlplus is create user abc identified by xyz
Now you join with dba privileges Khawaja Follow the steps to access sql 1, create the service name using config. mgmt.(Net) while create the service name it will ask service name and hostname just enter your db name and your host ip address which is hosted oracle. 2, oracle provice some predefined un and pwd i.e scott and tiger. open the sqlplus environment and type the username, password and the service name. 3, after that it will connect, if not send me what error msg occur while connection. Thoppan S Karthick
Have a Oracle Question
Oracle Books
Oracle Application
Oracle Home
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|