User SYS or System

[fehein]

Environment information:
* Oracle version:
* Operating system:

Good afternoon ...

Install my first BD Oracle 10g. For testing on a lap with view, I know it's not the most advisable but VA la, it worked.
My prolema is now simpler (it seems).

I only have 3 users available on my bank. SYS, System and Scott.
Scott does not have the many privileges, but I am not getting access to SYS (an error appears connect sys should by a sysdba. How do I connect with SYS?
System I can not create users or tables, shows me the message option not found or invalid.

could give me a better explanation about SYS and System and, if possible orient me of how to create A new user so I can study with this user?

Muuito Thanks for the help ....

[diegoleite]

Let's go ...


When using SYS you should specify what your privilege so you can authenticate in the password file.More forget this part ...

That way you connect as SYS

Select all

conn sys/senha@nomedainstancia as sysdba 
 
conn sys/senha@nomedainstancia as sysoper

already with the system Try to create a tablespace and a user (OWNER) You work, not (Kghr the bank). Do not mix with Oracle data diction objects. forget this part também ..


does this way that you will be able to play

Select all

CREATE  
 TABLESPACE nometablespace 
 LOGGING 
 DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\nomedatafile.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE 6000M 
 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

[99]

Select all

CREATE USER nomedoowner 
 IDENTIFIED BY senha DEFAULT TABLESPACE nometablespace 
 QUOTA UNLIMITED 
 ON nometablespace 
  ACCOUNT UNLOCK;

I know that someone will speak to not use a 6GB Datafile etc. . Remembering that it is a bank for you to play legal and not have problems in case of doing some bullshit type importing a database gignatates ...... or if you prefer ..

Select all

CREATE  
 TABLESPACE nometablespace 
 LOGGING 
 DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\nomedatafile.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M, 
 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\nomedatafile2.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M, 
 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\nomedatafile3.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M 
 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

99]] [99]

Note: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ is the Camiho of his Datafiles. Choose the path
Ex:

Select all

D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\

or

Select all

C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\

I hope I have helped. .. let me run ... I went ...

[fehein]

Thanks Diego, he helped me a lot.

Now to complicate a little more. I'm starting to work with the OWB tool. I have already installed the OWB, but when I will create the repository it presents me the Error ins0003 and informs me that my user is not permission from SYSDBA.

I already did the Grant Sysdba to Fernando, but the error continues.

Someone has any light ???


Thanks again.

[diegoleite]

Friend,

Did you try to connect as SYS? Influctly do not know the OWB product. Soon someone will help you ...