How to create a database user for oracle 11g on windows 8

installationoracleoracle-11gusers

I am new to oracle database and therefore is trying to follow the office guide. (link to the guide) However, it seems that the guide is for Windows 7, so in step 2 – creating database user, it says:

Display the SQL command prompt window. For example, on Windows, click Start, then Programs (or All Programs), then Oracle Database 11g
Express Edition, and then Run SQL Command Line.

And in windows 8, there is not start button. I try to search the menu using keyword oracle but nothing with similar name is found. I tried to go to the Program Files directly but also no similar file found. So, how should I create a database user on Windows 8?

Best Answer

In Windows 8 use shortcut to start command line option (Windows Key+R). It will open "Run" terminal. Then type keyword "cmd". It will start your command line then type "sqlplus" it will start sqlplus for interacting with your Oracle database. Use your SYS user with login credential for entering in sqlplus. After login into sqlplus, create your user using commands.

Related Solutions

Oracle 11g SYSDBA login

It depends on the GUI but they all should have a way of selecting the SYSDBA privilege. Toad has it appear as a drop-down box called 'Connect as:' as does Oracle Enterprise Manager. For SQL Developer you use the 'Role' box when creating a new connection.

As far as / as sysdba is concerned it just means that operating system authentication is being used so no password is needed. You can only use it if you are logged in as the oracle user or a member of the dba group (or for Windows, I believe as an administrator).

When you grant a user the SYSDBA privilege it only means they have the option to log in with the SYSDBA privilege and not that they will have dba privileges when they log in normally. The same is true for the SYS user: you can log in as SYS without the SYSDBA privilege and so lack the ability to shutdown the database, for example.

Oracle 10g dump file into Oracle 11g database

That error is most likely due to incorrect environment settings indeed, probably your PATH is mixed up too.

In a command prompt, assuming that your Oracle 11g home is indeed as you posted above, run:

set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1
set ORACLE_SID=ORCL11R1
set PATH=%ORACLE_HOME%\bin;%PATH%

Make sure you can connect with sqlplus, then start imp.

(Do consider using the expdp/impdp Data pump tools instead though. imp/exp are essentially deprecated in 11g.)

Best Answer

Related Solutions

Oracle 11g SYSDBA login

Oracle 10g dump file into Oracle 11g database

Related Question