z***h
发帖数: 7 | 1 Hi,all:
I don't know what's the matter with my enterprise manager, i
can only login in by "connect as normal", not by using sysop
or sysdba, so i did the things below:
1. Create the password file using ORAPWD80
2. Set remote_login_passwordfile=exclusive in the init*.ora
file by notepad
3. Run svrmgr30, grant sysdba to system identified by
manager;
After that, I can log into system as sysdba in svrmgr30 and
can select * from tab.
But When I try to login in Enterprise Manager using system
as sys |
|
s***l
发帖数: 9 | 2
INTERNAL is synonym for SYS user with SYSDBA privilege. To
change the password, you should use a special program named
OraPwd80 for Oracle 8.0 NT. In the command line, change
directory to InstanceRoot\Database\, type in:
OraPWD80 FILE=Pwdorcl.ora PASSWORD=newPassword ENTRIES=30
Here the password file is assumed to be PwdOrcl.ora. You
should change it according to your installation.
That is the trick. |
|
G***o
发帖数: 5158 | 3 after you run svrmgrl
svrmgrl> connect internal/oracle as sysdba
|
|
a****o
发帖数: 37 | 4 run server manager. svrmgrl or srvmgrl, I'm not sure.
connect sys as sysdba
startup
~{!>~} ~{TZ~} suckey (~{E |
|
h****r
发帖数: 2056 | 5 Hi, aaajoo, I meet another problem for start the oracle
server on
the Solaris 2.7,
below is the problem,
/***********************************************************
******/
$ ./svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights
Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect sys as sysdba
Password:
Connected.
SVRMGR> sqlplu |
|
h****r
发帖数: 2056 | 6 Hi, I meet another problem for start the oracle server on
the Solaris 2.7,
below is the problem,
/***********************************************************
******/
$ ./svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights
Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect sys as sysdba
Password:
Connected.
SVRMGR> sqlplus intern |
|
a**w
发帖数: 11 | 7 type svrmgrl
> connect as system/manager as sysdba;
then you should have system privileges. |
|
x***u
发帖数: 9 | 8 你可以用SVRMGR30启动，CONNECT / AS SYSDBA; STARTUP。前提是把你自己的NT USER
加入到NT的ORA_XXX_DBA GROUP(如果没有这个GROUP，就手创一个)。XXX是你的Database
的SID。并修改SQLNET.ORA，把sqlnet.authentication_services设成(NTS)。 |
|
l*****k
发帖数: 587 | 9 I tried to connect to a oracle 8 db in sql:
connect system/manager@blabal as sysdba;
always get feedback like
ORA-01031: insufficient privileges
don't know why, and,which user can use exp80 in oracle 8?
Thanks, I am new in this, thanks again |
|
n********a
发帖数: 68 | 10 sqlplus /nolog @blabal
then
connect sys/****** as sysdba; |
|
a****c
发帖数: 25 | 11 You can recompile this trigger.
Connect AS SYSDBA or connect internal
SQL> ALTER TRIGGER . COMPILE ;
Hope it would help.
re-validation |
|
g****n
发帖数: 40 | 12 Try sqlplus / as sysdba |
|
B*******e
发帖数: 3882 | 13 u mean oracle enterprise manager by saying OEM?
login "sys", connect as "sysdba"
for ordianry user connect as "normal" |
|
l*****k
发帖数: 587 | 14 in 9i, it seems anyone who connect to it needs sysdba priviledge.
even for connect as normal
is that right? |
|
B*******e
发帖数: 3882 | 15 when I try to connect sys through OEM as sysdba, I can put anything as passw
ord. |
|
B*******e
发帖数: 3882 | 16 log in "sys", connect as "sysdba", in Oracle Enteriprise Manager( i
remember th personal version has this), u can u anything as the password(but
not blank)
add user by right click security/user |
|
m******g
发帖数: 91 | 17 login as sysdba (sys)
create tablespaces for this user;
create a profile for this user;
create new user with relevant tablespace and profile;
grant privileges and roles (better start with a dba role) |
|
f***e
发帖数: 17 | 18 谢谢大家的指导。
我log in 后用下面的command 对吗？
SQL> CONNECT SYS/change_on_install AS SYSDBA
然后用什么command 去 create tablespace? |
|
s*******e
发帖数: 151 | 19 Please tell me, if my database is put into a unix sever ( we are using oracle
9i ) and we lost sys Id and password, what can I do to recover them?
I use tetlnet to connect with that sever.
Please help,thanks a lot! |
|
m******t
发帖数: 2416 | 20
use SYS/change_on_install, or SYSTEM/manager to log in as SYSDBA, then create
new users.
BTW, do take a hint from the default password and change it after the first
time you log in. 8-) |
|
s*******e
发帖数: 151 | 21 after you log in to the oralce,
you can try this:
sqlplus /nolog
and you can connect as sysdba. |
|
s***m
发帖数: 28 | 22
You may want to create a database first before you create any user. Login as
dba create database, then create user with proper privilege in your database.
On Orace machine
sqlplus /nolog;
connect system as sysdba;
######Then create your user#############3
create user yourusername identified by 'password';
grant connect to yourusername;
grant resource to yourusername;
You need to setup appropriate tablespace for your user so user will not put
junk into system tablespace. |
|
s*******e
发帖数: 151 | 23 when "oracle not avaible" happens, it could be a lot of situations.
I met one error like you last week, you can try to do that,
sqlplus /nolog
connect /as sysdba
shutdown immediate;
startup;
maybe last time, you or sb else shutdown the database. |
|
l*****k
发帖数: 587 | 24 oracle 9.2 on linux 7.3
problem is, when I starte oracle dba studio by " oemapp dbastudio"
I tried to login as system as sysdba, it responded "insufficient
previlidge" I remember seeing this kinda problem on win2k, but
I forgot what was the problem.
anyone enlight on me ? Thanks |
|
a**m
发帖数: 17 | 25 system/manager
or login as oracle OS user:
sqlplus /nolog
SQL plus prompt>connect /as sysdba |
|
s*****c
发帖数: 24 | 26
try: sqlplus "/ as sysdba" or sqlplus SYSTEM/MANGER. |
|
j**i
发帖数: 419 | 27
can you do-
conn / as sysdba?
Then change the password. |
|
f********t
发帖数: 74 | 28 1. assume user A created myjunktable
2. user A, or SYSDBA, or other users who have been granted select privilege
with grant option on this table can grant the select privilege to other
users
3. put schema in the grant command like
GRANT SELECT ON A.myjunktable to johndoe;
4. test it by using SELECT command after you login as johndoe
good luck |
|
y********o
发帖数: 2565 | 29 I am using Oralce XE, but I cannot find this user_tab_columns field in user_
tables. I logged in as sysdba. |
|
B*****g
发帖数: 34098 | 30 1. are you sure you have DBA privilege?
2. If yes in 1, did you log in as sysdba? |
|
j***a
发帖数: 10844 | 31 Windows？
Did you use DHCP?
Can you login as sysdba?
failed |
|
v*****r
发帖数: 1119 | 32 Did you log into as SYS with SYSDBA option to run dbms_java.grant_permission
?
If not, the failure could be due to the login user can't query/update the
java policy dictionary table. |
|
w*m
发帖数: 1806 | 33 yes, I login as sys with sysdba.
permission |
|
B*****g
发帖数: 34098 | 34 login时选了sysdba或sysoper了吗? |
|
m********r
发帖数: 2895 | 35 选的sysdba
我查了server，启动的时候有3个oracle相关的service没能启动，估计是这里的问题，
我们的oracle是run的GIS的数据库，也有可能是那一部分造成的
thanks anyway |
|
c*****d
发帖数: 6045 | 36 su - oracle
sqlplus "/ as sysdba"
startup |
|
w*********r
发帖数: 2095 | 37 Thank you for the reply.
When I start up sqlplus, I
1) su - oracle,
2) input the password when asked
3) Oracle $: sqlplus /nolog,
4) conn / as sysdba
5) startup.
I tried to use the Oracle account username and password and they do not work
either. |
|
