- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Something about the basical usage of Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:28 AM
тАО04-12-2006 02:28 AM
Something about the basical usage of Oracle
I'm a freshman of Oracle,so maybe my questions is very idiot.
Excuse me.
My question is:
I've installed an Oracle 10g server on HP-UX and
I log on as oracle and press sqlplus /nolog then
SQL>conn / as sysdba
SQL>
Then I was confused.
how could I know where am I(I mean what database I'm in)and How could I create a user
Help me,please
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:31 AM
тАО04-12-2006 02:31 AM
Re: Something about the basical usage of Oracle
select instance_name from v$instance;
will show yout he instance name.
or !echo $ORACLE_SID at the SQl prompt.
create user x identified by y;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:34 AM
тАО04-12-2006 02:34 AM
Re: Something about the basical usage of Oracle
no points for this second mail please.
you also have to, at least :
grant connect to x;
before user x can log on.
Sorry for the second positng.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:36 AM
тАО04-12-2006 02:36 AM
Re: Something about the basical usage of Oracle
before you login with / as sysdba you can check what environment is set with the env command. Try this:
env | grep ORACLE
If you use connect / as sysdba you connect to the database instance named in ORACLE_SID.
If you are in sql*plus use this:
select * from v$instance; or
select * from v$database;
to find some informations about the instance/db.
regards
Christian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:48 AM
тАО04-12-2006 02:48 AM
Re: Something about the basical usage of Oracle
Now I'm much more clear at Oracle
then I get a new question
is there only one database running on one system simultaneously because ORALCE_SID only can have one value?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:50 AM
тАО04-12-2006 02:50 AM
Re: Something about the basical usage of Oracle
ps -ef | grep smon
should give you list of databases running.
You can also check the /etc/oratab file.
Set your ORACLE_SID to the db you want to access and enter sqlplus.
export ORACLE_SID=dbname
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:54 AM
тАО04-12-2006 02:54 AM
Re: Something about the basical usage of Oracle
then conn / as sysdba it will defaultly connect to the database presented by ORACLE_SID.
Am I right?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 02:58 AM
тАО04-12-2006 02:58 AM
Re: Something about the basical usage of Oracle
yes.
you set the db you want to connect to by setting ORACLE_SID, when you then use sqlplus it will log you onto the chosen database.
You can test this by setting the ORACLE_SID you a invalid value, and then trying to log on. You should receive an error message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-12-2006 03:02 AM
тАО04-12-2006 03:02 AM
Re: Something about the basical usage of Oracle
Now I think I've made a great step in the comprehension of Oracle
Thank you